Another Dataset question

Results 1 to 2 of 2

Thread: Another Dataset question

  1. #1
    Join Date
    Dec 1969

    Default Another Dataset question

    If I fill a dataset with the following code:<BR><BR>cmd = New SqlDataAdapter("SELECT * FROM Projects",conn)<BR>cmd.Fill(ds,"Projects")<BR><BR> and then want to add data from another table do you need to set cmd equal to a new SqlDataAdapter before I fill ds again, or is there another method I should call that takes the new sql statement? Thanks.

  2. #2
    Join Date
    Dec 1969

    Default RE: Another Dataset question

    I think you should be able to do:<BR><BR>cmd.selectcommand.commandtext = "select * from somethingelse"<BR>cmd.fill(ds,"something")<BR><BR>

Posting Permissions

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