Assigning values from database to a textbox or label control in ASP.net

hi, hope this answers ur query //first establish a connection string connto ="Data Source=lcalhost;Initial Catalog=Northwind;User id=sa;pwd="; SqlConnection sconn = new SqlConnection(connto); sconn.Open(); //create a command object string query = "select * from Employees"; SqlCommand cmd = new SqlCommand(query,sconn); //get the data in a reader SqlDataReader dreader = terrcmd.ExecuteReader(); // iterate through the reader using the while loop while(dreader .Read()) { label1.Text=dreader .GetString(1); // or TextBox1.Text =... // this will give u the value in Column 1 }