Datagrid: how to add/delete/update records in a datagrid

Question

It is related to datagrid. I have the following requiremnts: 1. Navigation of records in grid 2. add/deleteupdate records in the grid. Can anybody give me code or any pointer where I can find it?

smileoftushar · Answer

here is the code for updating records in database by datagrid Dim conNorthwind As SqlConnection Dim cmdSql As SqlCommand Dim strSql As String Sub Page_Load conNorthwind = New SqlConnection( Server=localhost;UID=sa;PWD=secret;Database=Northwind ) If Not IsPostBack Then BindDataGrid End If End Sub Sub BindDataGrid cmdSql = New SqlCommand( Select * From Products conNorthwind ) conNorthwind.Open() dgrdProducts.DataSource = cmdSql.ExecuteReader() dgrdProducts.DataBind() conNorthwind.Close() End Sub Sub dgrdProducts_EditCommand( s As Object e As DataGridCommandEventArgs ) dgrdProducts.EditItemIndex = e.Item.ItemIndex BindDataGrid End Sub Sub dgrdProducts_UpdateCommand( s As Object e As DataGridCommandEventArgs ) Dim intProductID As Integer Dim txtProductName As TextBox Dim txtUnitPrice As TextBox Dim strProductName As String Dim decUnitPrice As Decimal intProductID = dgrdProducts.DataKeys( e.Item.ItemIndex ) txtProductName = e.Item.Cells( 1 ).Controls( 0 ) txtUnitPrice = e.Item.Cells( 2 ).Controls( 0 ) strProductName = txtProductName.Text decUnitPrice = txtUnitPrice.Text strSql = Update Products Set ProductName=@ProductName  _ & UnitPrice=@UnitPrice Where ProductID=@ProductID cmdSql = New SqlCommand( strSql conNorthwind ) cmdSql.Parameters.Add( @ProductName strProductName ) cmdSql.Parameters.Add( @UnitPrice decUnitPrice ) cmdSql.Parameters.Add( @ProductID intProductID ) conNorthwind.Open() cmdSql.ExecuteNonQuery() conNorthwind.Close() dgrdProducts.EditItemIndex = -1 BindDataGrid End Sub Sub dgrdProducts_CancelCommand( s As Object e As DataGridCommandEventArgs ) dgrdProducts.EditItemIndex = -1 BindDataGrid End Sub DataGridEditProducts.aspx