Get Query string from Dataset/Datatable

  • Thread starter Thread starter Johnny E. Jensen
  • Start date Start date
J

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
 
No. DataSet/Table is disconnected data model, which has no knowledge about
the data source which its data may be from.
 
Back
Top