SqlCommand & DataSet

melvik · April 4th, 2004, 03:51 AM

Hi friends:
How can I fill DataSet with SlqCommand Obj. ?!
Any help appreciated & Tnx in advance.

Always:),
Hovik Melkomian.

planoie · April 5th, 2004, 06:05 AM

<s>Usually, you do this like so:

objSqlCommandObject.Fill(objDataSet, "tablename")</s>

(My mistake, responded too quick.)

melvik · April 5th, 2004, 09:10 AM

no dear it for DataAdapter Obj. not for Command Obj.

Always:),
Hovik Melkomian.

bmains · April 5th, 2004, 11:47 AM

Hey,

I was looking around in the MSDN, and the only thing I can think of is:

Code:

objXMLReader = objCommand.ExecuteXMLReader()
objDataSet.ReadXML(objXMLReader.ToString())

Didn't test it out. Hope this helps,

Brian

bmains · April 5th, 2004, 11:50 AM

Oh, that response was also assuming you didn't want to use the SQLDataAdapter? If you do, then you could do:

Code:

objAdapter.SelectCommand = objCommand
objAdapter.SelectCommand.CommandType = <type>
objAdapter.Fill(objDataSet)