SqlConnection con = new SqlConnection("Server=(local)\\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=SSPI");
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SELECT EmployeeID, FirstName + ' ' + LastName as FullName FROM Employees";
cmd.Connection = con;
if (con.State == System.Data.ConnectionState.Open)
{
con.Close();
}
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read()) {
}
reader.Close();
con.Close();
or
also check below link
http://forums.asp.net/post/4623355.aspx[
^]