Modifica dati in tabella db usando dataset & co

[djciko]

no, che io ricordi basta associare un altro SelectCommand con la seconda query all'Adapter:

.....
connection etc..
.....

Dataset ds = new Dataset();

string primaQuery = "Select * from pippo";
string secondaQuery = "Select * from paperino";

try
{
    connection.Open();

    command = new SqlCommand(primaQuery, connection);
    adapter.SelectCommand = command;
    adapter.Fill(ds, "prima tabella");

    adapter.SelectCommand.CommandText = secondaQuery;
    adapter.Fill(ds, "seconda tabella");

    adapter.Dispose();
    command.Dispose();
    connection.Close();
}

.....

cosi' avrai

ds.Tables[0]
ds.Tables[1]