| Author: ABitSmart 03 Nov 2009 | Member Level: Diamond | Rating:  Points: 2 |
Can you post more code, specifically commandobject related code.
Kind regards, ABitSmart DNS Web-master, DNS MVM My blog Thoughts.exe
|
| Author: Swaroop Roy Mahidhara 03 Nov 2009 | Member Level: Gold | Rating:  Points: 2 |
commandobject.commandtext = "<stored procedure>"
//the below are the parameters for the stored proc. commandobject.parameters.add("@param1", varchar).value = val1; commandobject.parameters.add("@param2", varchar).value = val2;
//Dataset
dataset ds = new dataset(); ds.ReadXML(commandobject.executexmlreader());
int reccount; reccount = ds.tables[0].rows.count; //this statement is returning only one record.
Hope you got the problem.
Regards, swaroop
|