-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: PKandoth
Message 1 in Discussion
Hi
I'm new to .net. I've a SQL Database Test with Table Procedure
Structure for The table
ProcID int
Description Varchar[50]
I've the follwing piece of code
try
{
SqlDataAdapter adapter = new
SqlDataAdapter("Select * from
process","server=Home\\Home;uid=sa;database=olb");
DataSet ds = new DataSet();
adapter.Fill(ds,"Procedure");
DataTable table =
ds.Tables["Procedure"];
DataRow row = table.NewRow();
row["ProcID"] = "800";
row["Description"]="Test Case";
table.Rows.Add(row);
// adapter.Update(table);
DataTable inserts =
table.GetChanges(DataRowState.Added);
adapter.Update(inserts);
}
catch(Exception ee)
{
MessageBox.Show(ee.Message);
}
It gives me the Error :
"Update requires a valid InsertCommand when passed DataRow
collection with new rows."
What mistake am i making ? please help!!!!!!
Warm Regards
Pradeep
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/BDOTNET/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
