Datagrid updation

[AA]

We want to edit, update data of DataGrid in Asp.Net with VB.Net.and are

writing the following code for EditCommand and UpdateCommand

Event is :

DataGrid1_EditC ommand

Code is:

DataGrid1.editi temindex=e.item .itemindex

DataGrid1.DataB ind()

Event is :

DataGrid1_Updat eCommand

Code is:

Dim s as string

s=ctype(e.item. cells[2].Controls[0],textbox).text

Response.Write( s)

DataSet1.Tables (0).Rows(e.item .itemindex)(1)= s

Dim cmp as new SqlCommandBuild er(SqlDataAdapt er1)

SqlDataAdapter1 .update(DataSet 1.Tables(0))

DataGrid1.EditI temIndex=-1

DataGrid1.DataB ind()

This code does not show any error.

But there is problem,

when we modify any value of a record then

command [ s=ctype(e.item. cells[2].Controls[0],textbox).text ]

returns previous value.

If we write a fixed value in code to change it in datagrid then it updates

DataSet1.Tables (0).Rows(e.item .itemindex)(1)= HdDH This command updates

data in database

Therefore, problem is in retrieving current value from datagrid not in

updation command. How to access modified value of DataGrid

[Bin Song, MCP]

Hi

It looks like that you bind the grid before updating
Do you do a databind in page_load event

Bin Song, MC

----- AA wrote: ----

We want to edit, update data of DataGrid in Asp.Net with VB.Net.and ar

writing the following code for EditCommand and UpdateComman

Event is

DataGrid1_EditC omman

Code is

DataGrid1.editi temindex=e.item .iteminde

DataGrid1.DataB ind(

Event is

DataGrid1_Updat eComman

Code is

Dim s as strin

s=ctype(e.item. cells[2].Controls[0],textbox).tex

Response.Write( s

DataSet1.Tables (0).Rows(e.item .itemindex)(1)=

Dim cmp as new SqlCommandBuild er(SqlDataAdapt er1

SqlDataAdapter1 .update(DataSet 1.Tables(0)

DataGrid1.EditI temIndex=-

DataGrid1.DataB ind(

This code does not show any error

But there is problem

when we modify any value of a record the

command [ s=ctype(e.item. cells[2].Controls[0],textbox).text

returns previous value

If we write a fixed value in code to change it in datagrid then it update

DataSet1.Tables (0).Rows(e.item .itemindex)(1)= HdDH This command update

data in databas

Therefore, problem is in retrieving current value from datagrid not i

updation command. How to access modified value of DataGri