hello everyone i've written the code below from vb to C#. but it gives me an error saying it cannot explicitly convert "System.Data.DataRow" to "Busl.tblDocument" ( busl is my dataset and tblDocument is my Table.) An explicit conversion exist(are you missing a cast). It underlines the ds variable where r=ds.tblDocument.Rows.Find(Usr.id);

publicstring Update(Docs Usr)
{
busl.tblDocumentRow r;
Dbconnection cd = newDbconnection();
SqlDataAdapter adp = newSqlDataAdapter("Select * From Account", cd.con);
SqlCommandBuilder cmb = newSqlCommandBuilder(adp);
String msg;
adp.Fill(ds.tblDocument);
r = ds.tblDocument.Rows.Find(Usr.id);
r.Description = Usr.description;
r.Fpath = Usr.filepath;
r.Createdby = Usr.usrC;
r.Datec = Usr.dc;
//for all fields
adp.Update(ds.tblDocument);
ds.AcceptChanges();
msg = "Success";
return msg;
}

thanks in advance

__________________
supertedz

Hello, you need the cast (VB background??)

r = (busl.tblDocumentRow) ds.tblDocument.Rows.Find(Usr.id);

__________________
HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the proof.
================================================== =========