Q: update through datarow

G

Guest

Hello,

I decided to use stored procedure for select, update, insert, and delete and
these are my first stored procedures. This code was working when I created my
adapter through wizard.
DataRow dr= dataSet11.myTableName.NewRow();
string myPar=tb myPar.Text;
dr["myPar "]= myPar;
dataSet11.Tables[myTableName].Rows.Add(dr);
sqlDataAdapter1.Update(dataSet11, myTableName);

Once I created stored procedures and create adapter by pointing to them, now
it says @myPar is not supplied for myInsert stored procedure. @myPar is a
parameter in myInsert stored procedure however I do not know how I should
supply it in this structure since I am actually putting it into datarow and
expecting that the table will be updated after adapter update. What should I
do to supply parameter?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Staff online

Members online

Forum statistics

Threads
473,774
Messages
2,569,598
Members
45,152
Latest member
LorettaGur
Top