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