How to define the parameter in UPDATE statement in DataGrid

Discussion in 'ASP .Net Datagrid Control' started by Luke Xu, May 9, 2006.

  1. Luke Xu

    Luke Xu Guest

    I start learning asp.net 2.0. When I try to use Edit function in DataGrid to
    update database (DB2), how can I put parameter there?

    For example, there are two columns EMP_ID, EMP_NAME. I want to update
    employee name and issue the SQL statement in data source:

    UPDATE EMPLOYEE SET EMP_NAME=?? WHERE EMP_ID=??

    What I need to put into ?? ?

    In Command and Parameter Editor of ASP.NET, how can I bind the new parameter
    with the field in data grid?


    Thanks
    Luke
     
    Luke Xu, May 9, 2006
    #1
    1. Advertising

  2. Luke Xu

    Luke Xu Guest

    Any answer I can find here?

    "Luke Xu" <> wrote in message
    news:...
    > I start learning asp.net 2.0. When I try to use Edit function in DataGrid

    to
    > update database (DB2), how can I put parameter there?
    >
    > For example, there are two columns EMP_ID, EMP_NAME. I want to update
    > employee name and issue the SQL statement in data source:
    >
    > UPDATE EMPLOYEE SET EMP_NAME=?? WHERE EMP_ID=??
    >
    > What I need to put into ?? ?
    >
    > In Command and Parameter Editor of ASP.NET, how can I bind the new

    parameter
    > with the field in data grid?
    >
    >
    > Thanks
    > Luke
    >
    >
     
    Luke Xu, May 12, 2006
    #2
    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. NKOBAYE027

    weird #define statement

    NKOBAYE027, Mar 2, 2004, in forum: C++
    Replies:
    8
    Views:
    1,705
    David White
    Mar 2, 2004
  2. theotyflos
    Replies:
    3
    Views:
    474
    Thomas Matthews
    Feb 19, 2004
  3. robin liu
    Replies:
    3
    Views:
    824
    Robin Liu
    Apr 21, 2006
  4. Andreas Klemt
    Replies:
    0
    Views:
    308
    Andreas Klemt
    Oct 8, 2003
  5. Brian Takita

    #define _ and #define __

    Brian Takita, Jan 23, 2006, in forum: Ruby
    Replies:
    0
    Views:
    467
    Brian Takita
    Jan 23, 2006
Loading...

Share This Page