Hi,
I have sql statment something like this
string sql = "Insert into table1 values('abc',100);Select * from table1;Insert into table1 values('xyz',200);";
when I execute this sql in sqlcommand using ExecuteNonQuery, the result is 2 (Total Insert)
When I execute this sql in SqlAdapter using fill, the result is dataset is filled by select * from table1.
But I would like to have one execution which will return 2(number of insert (in order of insert exeuction) and dataset for select statement.
What I understand from the execution is that It executes all sql which is there in commandtext, but it returns based on your exeuction method.
So is there anyway I can get all result in one exeuction
Thanks.
.NET Development5
|