Results 1 to 3 of 3

Thread: Adding new records to more than one column

  1. #1

    Thread Starter
    Hyperactive Member gmatteson's Avatar
    Join Date
    Feb 2002
    Location
    Rhode Island, USA
    Posts
    293

    Adding new records to more than one column

    Dim oDataAdapter As New MySqlDataAdapter
    Dim oRow As DataRow
    oRow = oDataset.Tables(strSelectedValue).NewRow()
    oRow.Item(0) = txtName.Text
    oDataset.Tables(strSelectedValue).Rows.Add(oRow)

    This is what i have so far that add's a new record to a table with one column... how can i make it so that i can add 3 values to the table one for each column?

    i.e.

    Table1
    NAME Date of Birth SS
    john doe xx/xx/xxxx xx-xxx-xxxx

    thank you.

  2. #2
    Frenzied Member
    Join Date
    Oct 2002
    Location
    Gammapolis
    Posts
    1,474
    oRow.Item(Column_name_or_number_here)=Desired_Value
    'Heading for the automatic overload'
    Marillion, Brave, The Great Escape, 1994

    'How will WE stand the FIRE TOMORROW?'
    Eloy, Silent Cries and Mighty Echoes, The Vision - Burning, 1979

  3. #3

    Thread Starter
    Hyperactive Member gmatteson's Avatar
    Join Date
    Feb 2002
    Location
    Rhode Island, USA
    Posts
    293

    thanks

    thanks, forgot about that

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width