Adding row to ADO reccrodset table

Discussion in 'ASP .Net' started by MattB, Jan 23, 2004.

  1. MattB

    MattB Guest

    I have an ADO recordset that is not associated with any particular database.
    I want to add a row. Sounds simple but I'm not sure how to do it. Examples
    I've found use an insert statement, but they are all connected to a SQL
    database. I'm familiar with SQL and VFP but this is uncharted territory to
    me. Can I still use a SQL insert? Should I do it using all object
    references?

    So I want to do the equivalent of this:

    insert into myDataTable values(1, 'mystring1', 'mystring2', '2.5')

    Thanks!
    --

    Matt

    "Gravity. It's not just a good idea, it's the law!"
    MattB, Jan 23, 2004
    #1
    1. Advertising

  2. MattB

    Gerald Klein Guest

    Are you talking about a datatable??
    "MattB" <> wrote in message
    news:busb5t$ld196$-berlin.de...
    > I have an ADO recordset that is not associated with any particular

    database.
    > I want to add a row. Sounds simple but I'm not sure how to do it. Examples
    > I've found use an insert statement, but they are all connected to a SQL
    > database. I'm familiar with SQL and VFP but this is uncharted territory to
    > me. Can I still use a SQL insert? Should I do it using all object
    > references?
    >
    > So I want to do the equivalent of this:
    >
    > insert into myDataTable values(1, 'mystring1', 'mystring2', '2.5')
    >
    > Thanks!
    > --
    >
    > Matt
    >
    > "Gravity. It's not just a good idea, it's the law!"
    >
    >
    Gerald Klein, Jan 23, 2004
    #2
    1. Advertising

  3. MattB

    MattB Guest

    Yes, and I just figured it out, so nevermind. Thakns for the reply!

    Gerald Klein wrote:
    > Are you talking about a datatable??
    > "MattB" <> wrote in message
    > news:busb5t$ld196$-berlin.de...
    >> I have an ADO recordset that is not associated with any particular
    >> database. I want to add a row. Sounds simple but I'm not sure how to
    >> do it. Examples I've found use an insert statement, but they are all
    >> connected to a SQL database. I'm familiar with SQL and VFP but this
    >> is uncharted territory to me. Can I still use a SQL insert? Should I
    >> do it using all object references?
    >>
    >> So I want to do the equivalent of this:
    >>
    >> insert into myDataTable values(1, 'mystring1', 'mystring2', '2.5')
    >>
    >> Thanks!
    >> --
    >>
    >> Matt
    >>
    >> "Gravity. It's not just a good idea, it's the law!"
    MattB, Jan 24, 2004
    #3
    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. nita
    Replies:
    1
    Views:
    856
    Saravana
    Nov 20, 2004
  2. ronaldlee

    Transfer ADO Code to ADO.NET

    ronaldlee, Dec 17, 2004, in forum: ASP .Net
    Replies:
    1
    Views:
    445
    Kevin Spencer
    Dec 17, 2004
  3. Replies:
    0
    Views:
    1,301
  4. phl
    Replies:
    1
    Views:
    4,330
    Martin Jay
    Jun 8, 2006
  5. Navin
    Replies:
    1
    Views:
    672
    Ken Schaefer
    Sep 9, 2003
Loading...

Share This Page