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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Extreme basics

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 details

SELECT columns
FROM Table
WHERE 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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

Yvonne
Starting Member

2 Posts

Posted - 2013-05-01 : 20:00:12
Thanks! I will try that.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-05-02 : 02:05:16
welcome

let us know if you face any issues

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
   

- Advertisement -