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. Advertisements

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. Ron Vecchi
    Replies:
    1
    Views:
    838
    Ron Vecchi
    Jul 27, 2003
  2. Doug
    Replies:
    0
    Views:
    1,104
  3. Alex
    Replies:
    3
    Views:
    681
  4. CaptRR

    Can't update datarow

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

    Looping through datarow

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

    , Feb 23, 2007, in forum: ASP .Net
    Replies:
    2
    Views:
    853
  7. Bobby Edward
    Replies:
    0
    Views:
    1,037
    Bobby Edward
    Sep 18, 2008
  8. Marc Eggenberger

    Accessing DataRow Items by Name in Edit/Update/Delete Event

    Marc Eggenberger, Jan 31, 2005, in forum: ASP .Net Datagrid Control
    Replies:
    0
    Views:
    267
    Marc Eggenberger
    Jan 31, 2005
Loading...