How to connect microsift sql server 2005 using microsoft vb.net

[rohan4040]

Can any one suggest me how to connect the database using vb.net 2008.

[ABitSmart]

e.g.,

string connstring = "Data Source = .\\ABC;Initial Catalog = XYZ; Integrated Security = True";

SqlConnection conn = new SqlConnection(connstring);
SqlCommand comm = new SqlCommand();
comm.CommandText = "Select \* From DummyTable";
comm.Connection = conn;    
conn.Open();

comm.ExecuteScalar();
conn.Close();

MSDN[^]

[Dave Kreskowiak]

There is not just one or two ways to do this. I highly suggest picking up a book on ADO.NET to have as a learning tool and reference.

A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
     2006, 2007, 2008