well i have come up from structured programming.i have programmed in Vb and C but i do not know how to make a connection to the database using C#.Can anyone tell me the code for connection to the Northwind.

Thanks.

// Create Conn
SqlConnection myConnection = new SqlConnection("Initial Catalog=Northwind;Data Source=localhost;Integrated Security=SSPI;");

// Connect

myConnection.Open();
// Do what u want...
myCommand.Connection.Close();
//Close Conn

HTH.

Always:),
Hovik Melkomian.