How to access SQL Server 2005 with VB.net?

Question

I have a database in Microsoft's SQL Server 2005. It is hosted on the school's... wherever they host these things.

I decided to make the front end in Visual Basic .net because I didn't want to spend forever making the GUI.

But I can't figure out how to access the database through VB, and I have not found any sites with good information.

How do I connect to the database through VB.net?
Or what are some good sites where I can learn about how to do this? I will need to run stored procedures and such.

Thanks much.

Answer 1

here are some of the answers



refer

http://searchcode.tm-sol.com/codeid.php?Code_ID_Code=218&dowhattodo=&pageid=1&skey=connect to database



or



http://searchcode.tm-sol.com/codeid.php?Code_ID_Code=108&dowhattodo=&pageid=1&skey=connect to database



Cheers,

N

Answer 2

a million. Create a clean database on your sq. Server 2005 2. authentic click database which pops up the menu. 3. opt for initiatives -> Import archives which pops up a sq. server import export wizard 4. click next 5. From the archives source Drop down record opt for Microsoft get entry to six. opt for the record and enter person call and password. 7. click next and end

Answer 3

check out the slideshow at http://www.vkinfotek.com



one of the slide is about connection string. you can try the connection string in your code. i also came across a page with more about connection strings.



to copy the source code, you can place your mouse on the slide. i think you can write down the source code.