DB Connection Of SQL server 2008 to MS visual c# 2010 ?

Hi Kiran,

To achieve this purpose, you will have to use the classes inside System.Data namespace. Add a reference if haven't done yet. In the sample code below I have used the connection string for my local database, you can find other syntax and formats of connection string as well at:
http://connectionstrings.com/sql-server-2008


Below are the sample code for you on how to access data... :
-------------------------------------------------------------
string ConStr = "Server=SUNNY-PC\\SQLEXPRESS;Database=students;Integrated Security=true;";
SqlConnection MyCon = new SqlConnection(ConStr);
SqlCommand cmd = new SqlCommand("select * from students", MyCon);
try
{
MyCon.Open();
}
catch(Exception ex)
{
Console.WriteLine("Database connection error: " + ex.Message);

}
if (MyCon.State == ConnectionState.Open)
{
SqlDataReader reader = cmd.ExecuteReader();
Console.WriteLine("******** NAMES **********");
while (reader.Read())
{
// do whatever you want here with data. You can also use SqlDataAdapter to fill in a DataTable instead of using SqldataReader
Console.WriteLine(reader.GetString(1));
}
Console.WriteLine("--------- ****** -----------");
}

if (MyCon.State == ConnectionState.Open)
{
try
{
MyCon.Close();
}
catch { }
}
--------------------------------------------------------------------

Reply back for any clarification.

Please don't forget to mark this as answer if it helps :)

Thanks.