Datagridview updating database

If someone could help me adjust this so when I add rows of information to the Data Grid View or edit the rows, and have the SQL file actually receive the changes/updates, I'd appreciate it.

User Added Row Dim data Row View As Data Row View = Try Cast(e. Data Bound Item, Data Row View) Dim row As Data Row = data Row View. Update(row) End Sub Private Sub rad Grid View1_Current Row Changed(By Val sender As Object, By Val e As Telerik. Current Row Changed Event Args) Handles Rad Grid View1. Old Row Is Nothing Then Return End If Dim data Row View As Data Row View = Try Cast(e. Data Bound Item, Data Row View) If data Row View Is Not Nothing Then Dim data Row As Data Row = data Row View. I'd prefer to avoid the stupid column of integers like line numbers and just make my first text column the primary key, but when I try to do this and update the database, it throws errors.If there's a way to do this, I'd appreciate the explanation of how, or if there's a way to hide the first line number column the pulls the integer value for the primary key, and have it automatically increment and/or adjust this value according to editing, changes and new rows being added that'd be great.

Leave a Reply