Q: update through datarow

Discussion in 'ASP .Net' started by =?Utf-8?B?SklNLkgu?=, Mar 13, 2006.

  1. 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?
     
    =?Utf-8?B?SklNLkgu?=, Mar 13, 2006
    #1
    1. Advertising

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Doug
    Replies:
    0
    Views:
    932
  2. Alex
    Replies:
    3
    Views:
    596
  3. CaptRR

    Can't update datarow

    CaptRR, May 11, 2004, in forum: ASP .Net
    Replies:
    4
    Views:
    4,486
    Kevin Yu [MSFT]
    May 13, 2004
  4. AMD Desktop

    Looping through datarow

    AMD Desktop, Nov 3, 2004, in forum: ASP .Net
    Replies:
    2
    Views:
    12,465
    AMD Desktop
    Nov 3, 2004
  5. Update DataRow

    , Feb 23, 2007, in forum: ASP .Net
    Replies:
    2
    Views:
    711
Loading...

Share This Page