Quote Originally Posted by killer7k
Now it Say that i should use This Stored Procedure in .Net
i thought DataGrid will attached to this Stored procedure & show me the exact display
but Not
If i am not wrong you are seeing your query output in Text Mode (In query analyser) Just change it to Grid mode and u will noticed that its not just a single table but for every Group in your case it's NReg you will get different table,so when you call this stored procedure you get bunch of table so how you can expect grid (using dataset) to show Formatted output what you might be getting in SQL analyser