rcoob

rcoob

  • NA
  • 1
  • 0

Editing rows in a Datagrid

Aug 6 2004 12:05 PM
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

Answers (1)