How to populate fields on form from database

[AustinGal]

I need to populate my textfields from values in database. I also need navigation buttons to scroll through all records, similar to an access form. Below is what I have on the OnLoad event:

protected void Page_Load(object sender, EventArgs e)
        {
 
            SqlConnection conn = new SqlConnection(GetConnectionString());
 
            SqlCommand cmd = new SqlCommand("SELECT * from CriminalHistoryCriteria", conn);
 
            cmd.Connection.Open();           
            cmd.ExecuteReader();
 
            cmd.Connection.Close();
            cmd.Connection.Dispose();
 
        }

[Frinavale]

Please review the following article about how to use a database.

It demonstrates how to loop through data that is retrieved from the database and set it to a TextBox's Text property.

-Frinny