C#

[RaiZen18]

Hey everybody!

I need help with C# programming. What I have is a program that links to a database from access and display the list of my movies in the database, now what I am wanting is to have a link with it so I can click it and play the movie. THanks for the help!

[HD0087]

Why use access as the database. Couldn't ya just make a text/xml file as a "database" instead? I'm sure you have a reason but still a waste of space, slow while also complicating things a bit.
I'm also assuming that you went and stored the files into the database rather than just having directories for them?

I haven't toyed around with drag and drop programming languages in ages and there could be some errors or could be all together wrong but try fetching the files from their designated access fields with oledbdatareader and adding them to listboxes or what ever and write a simple code to play them by clicking at the item.

So in .NET it should look something like this and because .Net and C# are almost "indentical" it shouldn't be that hard to ficure out how to transfer this sample to it. Theres even online converters floating around if I remember correctly.

Private Sub RaiZensTop5PornVideos_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Dim con As OleDbConnection = New OleDbConnection("Your Database")

Dim cmd As OleDbCommand = New OleDbCommand("Your Table, con)

con.Open()

Dim Video_Data As OleDbDataReader = cmd.ExecuteReader
While Video_Data.Read

ListBoxVideo.Items.Add(Video_Data.Item("Animal_Pr0n"))
End While

End Sub

Private Sub ListBoxVideo_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ListBoxVideo.SelectedIndexChanged
Process.Start(ListBoxVideo.SelectedItem.ToString)
End Sub

[RaiZen18]

thanks for the post, but I got database connection working this afternoon, now I need to know how to open the movie file, so the link is there and I click it and it plays the movie.... but now how? struggling to get this 2 work. don't know where to start lol!

[HD0087]

So you have stored the files into access?
The Process.Start command in my sample should start the video file from the Access "Animal_Pr0n" Item into what ever app your defined to open the file format in your system. "Process.Start command should be same in C#"
This method just assumes that you have put the files into their own Items in Access for it to work.

[RaiZen18]

k kwl but wat do you mean stored the files in access? you mean included the link for it in a field or wat?

[HD0087]

Stored as in the files are actually in there. I was assuming that was the case for somereason.
Okay so it should be alot easyer then.. you have the link in the database and your abel to fetch it from the database to your app since you have the database connection working and all? So you could display the path in a text box for instance? so the only thing you would have to do is to pass the same argument you use to fetch that to Process,Start()
I'm too lazy to write any code at this hour so I hope ya understood.