Can I set a DataSet by Command object instead of DataAdapter?!?! or both?! if yes How??
Please help

Always:),
Hovik Melkomian.

__________________
Always,
Hovik Melkomian.

You can't populate a DataSet with Command object but you can populate DataReader object which is regarded as the fastest way to access the read-only data. Exp:
   SqlDataReader mySqlReader = mySqlCommand.ExecuteReader();

Use DataAdapter to get a DataSet:

   SqlDataAdapter da = new SqlDataAdapter();
   DataSet ds = new DataSet();
   da.SelectCommand = new SqlCommand(sql, connection);
   da.Fill(ds);

tnx for reply