Bharat,

Might help to tell us what the error is ....

~~Bonnie

>Hi,
>
> I am filling a data set using data adapter from remote sql server. I am selecting only three columns of large number of columns.
>
>da.Fill ( ds , "claim_header_in" ) ;
>
> I am updating each column by iterating through each row using
>
>foreach ( DataRow aRow in ds.Tables["claim_header_in"].Rows )
> {
>
> clm++;
> aRow[2] = Client + LeftBatch ;
> aRow[1] = aRow[2] + Zero + Convert.ToString(clm);
> Console.WriteLine("{0}, {1}, {2}", aRow[0], aRow[1], aRow[2]);
> }
>da.Update(ds,"claim_header_in");
>}
>
> Even "console.writeline" shows that data in the data set is updating. Now I want to send the updates to Sql server table. I get system error when I use
>da.Update(ds,"claim_header_in");
>
> Can any one suggest me the solution.
>
>Thanks
>Bharat