I have a GridView with which I am populating 3 columns with data from a SQL table. The columns are populated after an ontextchanged event. The data populates the columns just fine, however the data is erased when I add a new row to the GridView by clicking the update button. The data returns if I click on the GridView edit button. The columns I am manually completing do not erase after adding a row. Also, it appears that the data I am populating from the SQL table appears in the GridView column as a label instead of inside of the column text box.
How can I keep the data from erasing?