Hello everyone im trying to insert a record into a database but it displays the following error message:
The DataAdapter.SelectCommand.Connection property needs to be initialized;
Im using the following create function:

publicstring create(Docs dc)
{

//busl.tblDocumentRow r;
Dbconnection cd = newDbconnection();
SqlDataAdapter adp = newSqlDataAdapter("Select * From tblDocument", cd.con);
SqlCommandBuilder cmb = newSqlCommandBuilder(adp);
string msg;
busl.tblDocumentRow r = (busl.tblDocumentRow)ds.tblDocument.NewRow();
r.id = dc.id;
r.description = dc.description;
r.fpath = dc.filepath;
r.dc = dc.dc;
r.createdby = dc.usrC;
ds.tblDocument.Rows.Add(r); //for all fields

adp.Update(ds.tblDocument);
ds.AcceptChanges();

msg = "Success";
return msg;

}

This is the following connection class:

publicclassDbconnection
{
publicSqlConnection con;
public Dbconnection()
{
SqlConnection con = newSqlConnection("Data Source=MMS-AF4C3555D88/SQLEXPRESS;Initial Catalog=EDM;Integrated Security=True");
}
}

Thanks in advance

__________________
supertedz

Does the connection work? If you comment out the database requests, will it open the page and display the Success message?

__________________
-------------------------

Whatever you can do or dream you can, begin it. Boldness has genius, power and magic in it. Begin it now.
-Johann von Goethe

When Two Hearts Race... Both Win.
-Dove Chocolate Wrapper

Chroniclemaster1, Founder of www.EarthChronicle.com
A Growing History of our Planet, by our Planet, for our Planet.