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();
