SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Extreme basics
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Yvonne
Starting Member

2 Posts

Posted - 04/28/2013 :  22:39:28  Show Profile  Reply with Quote
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

India
52317 Posts

Posted - 04/29/2013 :  00:19:31  Show Profile  Reply with Quote
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 - 05/01/2013 :  20:00:12  Show Profile  Reply with Quote
Thanks! I will try that.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 05/02/2013 :  02:05:16  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000