How to Connect to SQL Server 2005 with VB.NET 2005

[ethunhunt.mi]

Hi, i have developed some database applications using vb 6 and oracle 8i and now i am using vb.net 2005 as my new development IDE. I want to know how to connect to sql server database by using vb 2005 as a backend. please tell in detail and step by step with code. Also give an example about how to Insert, Edit Delete and Update the records in a database.

 

[cjard]

Hi, i have developed some database applications using vb 6 and oracle 8i and now i am using vb.net 2005 as my new development IDE. I want to know how to connect to sql server database by using vb 2005 as a backend.

Frontend. SQLS is the back end.

please tell in detail and step by step with code. Also give an example about how to Insert, Edit Delete and Update the records in a database.

Read the DW2 link in ym signature, section on "Creating a simple application"

It will introduce select, insert, update, delete and displaying related data. After you have done this, read whichever of the walkthroughs you like