Just try it
table.Row(i).BeginEdit()
table.Row(i).Item("ColName")=5
table.Row(i).EndEdit()
' Then call
DataAdapter.Update(Table)
2009/2/26 [email protected] <[email protected]>
>
> Hi Guys,
> Im Inserting row in Database with DataAdapter.Update(DataTable)
> method.
> Its working fine with No error.
>
> But Sometimes if I write like
>
> table.Row(i).Item("ColName")=5 ' My Previous value is 1 and
> replacing with 5
>
> Here ,
> Current Value is 1
> Proposed Value Is 5
>
> Then Execute :
> DataAdapter.Update(Table)
>
> then execute Update method of DataAdapter then
> It will Insert '1' Instead of '5'.
>
> From My reasearch I Found that Particular Items
> Current Value is Still 1 Before Update and
> Proposed Value Is 5.
>
> What can be the problem?
>
>
>
>
--
Regards
*******************
*C.Arun Kumar *
*******************