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

Senthilkumar · Answer

Hi Dyson See this example will help you. http://vb.net-informations.com/dataadapter/dataadapter-selectcommand-sqlserver.htm

Dyson Dyson · Answer

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

Senthilkumar · Answer

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

Dyson Dyson · Answer

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

Dyson Dyson · Answer

Hai Krishna Garad i need full coding.

Krishna Garad · Answer

you can try like this SqlConnection cn=new SqlConnection(U r Connection String Here...); cn.Open(); SqlCommand cmd=new SqlCommand(Select * From TableNamecn); 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(); .....