Editing rows in a Datagrid

I have a datagrid that I am using to track inventory. The datagrid pulls from a Access database query and populates it. I want to have a hyperlink at the end of each row that allows you to edit the information for that particular row and saves the changes to the database (reassign a computer to a different user for instance). I don't care if the hyperlink opens up a new web form or if I can do it from the original datagrid. Any help would be greatly appreciated. Thanks. Sub Page_Load If Not Page.IsPostBack Then DBConnection = New OleDbConnection( _ "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=OMLET.mdb") DBConnection.Open() SQLString = "SELECT * FROM qry_test" DBCommand = New OleDbCommand(SQLString, DBConnection) DBReader = DBCommand.ExecuteReader() DataGridDisplay.DataSource = DBReader DataGridDisplay.DataBind() DBReader.Close() DBConnection.Close() End If

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

nick 022y ago
Add a Button Column for editing. This will allow the user to edit values right on that page in the data grid. See the response I made to a question which is exactly the same. The other option is to allow open editing of all fields in the grid without a positive user action. To do this make your fields Template fields and put editable controls in the Item area of the template field. This way the user does not have to take an action to edit data.