"Johnny E. Jensen" <johnny@XXemde.dk> wrote in message
news:uzg2WKOGIHA.4712@TK2MSFTNGP04.phx.gbl...
> 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
>