When I Filter the data using dropdown selected Index Changed event the gridview shall load data based on what is searched.I need to do the updating operation on what row is clicked.On Row Updating is fired when the 'Edit' button is clicked. Is the data bound to the gridview, your gridview markup doesn't say that it is bound to Category Name. In the Row Updating event handler, it fetches the Category Name data to which the textbox is bound to. Try something the gridview is bound to in your case Product [email protected] Vijay : I agree that its bad idea to enable any Id to be editable, but before going to my module i just create one table containing Prod ID and prod Name.
Edit Index = -1; after debugging code with breakpoint this it goes back to page and it shows gridview with below and if I want change quantity=67 and click update . Value); string str = "update testitem set [email protected], [email protected], [email protected] where [email protected] and [email protected]"; Sql Command cmd = new Sql Command(str, con); cmd. For example if you display data with category "ABC" then you change category to "DEF", the row will disapear because you only display "ABC" data." Select Command="SELECT a.tenantcode, a.name, a.fixedrate, a.percentrate, a.percentage, b.locationd, c.status FROM TENANTNEW AS a INNER JOIN LOCATION AS b ON a. I've a sample below, the Grid View Template is bound to Category Name. Add(New Data Column("Col1_ML", Get Type(String))) dt. Add(New Data Column("Col1_PH", Get Type(String))) dt. In my VB Gridview, I had bind several column from datatable into one single column of the gridview. The following is the VB code: Protected Sub Grid View1_Row Editing(By Val sender As Object, By Val e As Grid View Edit Event Args) 'Set the edit index. Bind Data() End Sub Protected Sub Grid View1_Row Canceling Edit(By Val sender As Object, By Val e As Grid View Cancel Edit Event Args) 'Reset the edit index. Edit Index = -1 'Bind data to the Grid View control. But I have no idea how to get those value when doing Row Editing & Row Updating. Bind Data() End Sub Protected Sub Grid View1_Row Updating(By Val sender As Object, By Val e As Grid View Update Event Args) 'Retrieve the table from the session object. New Edit Index 'Bind data to the Grid View control. Bind Data() End Sub Private Sub Create Data Table() Dim cmd As New System. Dim dt = CType(Session("dt"), Data Table) 'Update the values.