Now we access this connection string on the page so we can open a connection with the relation database. The first one accesses the connection string and the other is for the SQL connection.
In practical scenario you should use your existing architecture to populate and update the data.
Some applications may require updating the data base when the end-user is up to exit the applications. Current If current Is Not Nothing Then Edit Row = (CType(current, Data Row View)).
In other cases the end-user may be required to click a special button in order to update the database. Row End If End Sub Private Sub employees Binding Source_Current Changed(By Val sender As Object, By Val e As Event Args) Dim data Row As Data Row = (CType((CType(sender, Binding Source)). Row If last Edit Row Is Not Nothing And Also last Edit Row.
And here I’m explaining some basic functions of this gridview control such as insert edit and delete a record.
First, we need to prepare the database table and stored procedure for gridview operations such as insert, update & delete a records, here I’m using sql server 2008 for all database activities, for this sample I have created the customer table and stored procedure for all mentioned gridview operations.