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
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