Get Query string from Dataset/Datatable

[Johnny E. Jensen]

Hello

When i fetch data from database i do the following:

DataSet ds = new DataSet();
OledbConnection con = new OledbConnection(ConnectionString);
using ( OledbCommand cmd = con.CreateCommand())
{
cmd.CommandText = "SELECT * FROM [tblCustomers] WHERE [CustomerName]
LIKE 'A%';";
using ( OledbDataAdapter da = new OleDbDataAdapter(cmd))
{
da.Fill(ds);
ds.Tables[0].TableName = "tblCustomers";
}
}

The above just ment as an illustration.
The DataSet ds now contain one table with the result of the query within the
cmd.
Now my question, is the cmd Query stored somewhere within the DataSet/Table?

Kind regards

Johnny E. Jensen

 

[Norman Yuan]

No. DataSet/Table is disconnected data model, which has no knowledge about
the data source which its data may be from.