Information générale
Titre:
Data Adapter question.
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement