Database connection

Question

Can anyone tell me.hoe to make connection between microsoft sql server and c#, Any simple example of reading some datas from a table in sql and display them in a text box 

Answer 1

Hi Dyson,

See this example, will help you.

http://vb.net-informations.com/dataadapter/dataadapter-selectcommand-sqlserver.htm

Answer 2

Hai Senthilkumar : i got that but i need an example ill use select command and how can i make it display in text box 

Answer 3

connectionString="Data source=localhost; initial catalog= example1; user id=sa password=sa"

Answer 4

Krishna Garad :you had mentioned "Ur connection string here" how can i get that idont know Im a beginner only 

Answer 5

Hai  Krishna Garad i need full coding.

Answer 6

you can try like this

SqlConnection cn=new SqlConnection("U r Connection String Here...");
cn.Open();
SqlCommand cmd=new SqlCommand("Select * From TableName",cn);
DataSet ds=new DataSet();
SqlDataAdapter da=new SqlDataAdapter(cmd);
da.Fill(ds);
cn.Close();
//display data in textboxes from the dataset

TextBox1.Text=ds.Tables[0].Rows[0]["ColumnName"].ToString();
.....