Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Yvonne
Starting Member
2 Posts |
Posted - 2013-04-28 : 22:39:28
|
Do I query the SQL database from my html files? If so, what is required for that? Is there a good commented example so I will know what to do for my site? I want people to be able to search various categories to find certain kinds of music, but certain artists, on certain topics. I started trying to use Visual Basic, hoping to access the database of music links using the DetailsView, and then copy the code into the html file, but I don't know if it will work. I would also prefer something more visually engaging than DetailsView, hopefully something that could automatically include Youtube thumbnails for selected songs (there are too many YT songs I want to put links to in the database to display all the thumbnails). Also, I'm wanting to take these songs from the html file, and put them in the database. Does anyone know of a tool I could use, so I could specify the format, and use the tool to put the right info in the right database columns? Thank you so much! |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-04-29 : 00:19:31
|
you need to create forms in Visual Basic and pass your serach strings by means of database call. For that in code behind you'll create a connection to database where you've the details and then create a select query like below to get detailsSELECT columnsFROM TableWHERE SearchField = @yourSearchString for showing tumbnails you need to get images and store them in a file share. Store the path information in database and in vbcode retrieve the path from db and using it fetch and display your image.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
Yvonne
Starting Member
2 Posts |
Posted - 2013-05-01 : 20:00:12
|
Thanks! I will try that. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-02 : 02:05:16
|
welcomelet us know if you face any issues------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|