Another Dataset question

[anis007]

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