How to run basic query in C# and ASP.NET
Connect to the database, execute query command and collect row data in datareader object. Retrieve data from datareader.
SqlConnection sqlConnection1 = new SqlConnection("Your Connection String"); SqlCommand cmd = new SqlCommand(); SqlDataReader reader; cmd.CommandText = "SELECT * FROM Customers"; cmd.CommandType = CommandType.Text; cmd.Connection = sqlConnection1; sqlConnection1.Open(); reader = cmd.ExecuteReader(); // Data is accessible through the DataReader object here. while(reader.Read()) { txtControl.text = reader["field name"].ToString(); } sqlConnection1.Close();