Hi There:
A very new with VS.net.
I am working in VS.Net2003 and SQL server. I created a Stored Procedure in SQL. I ran the procedure and its giving me all required data in SQL Query analyzer screen. The data order is same as they are in the temporary table in the SP. Now I created a Data adaptor in .Net and linked it to the SQL stored procedure. When I tried to preview the data in the dataadopter(being filled by the Stored Procedure), I found the whole order of data been messed up. There is NO order of data.
So why there is data in order in SP but not in the Dataadaptor.
The Stored Procedure is like:
Create @temptab
Insert into @temptab
Select * from tab1
Insert into @temptab
Select * from tab2
Select * from @temptab.
--I want to see the data in order as I am Inserting them. But its not working during the Dataadaptor.
Thanks in advance
A very new with VS.net.
I am working in VS.Net2003 and SQL server. I created a Stored Procedure in SQL. I ran the procedure and its giving me all required data in SQL Query analyzer screen. The data order is same as they are in the temporary table in the SP. Now I created a Data adaptor in .Net and linked it to the SQL stored procedure. When I tried to preview the data in the dataadopter(being filled by the Stored Procedure), I found the whole order of data been messed up. There is NO order of data.
So why there is data in order in SP but not in the Dataadaptor.
The Stored Procedure is like:
Create @temptab
Insert into @temptab
Select * from tab1
Insert into @temptab
Select * from tab2
Select * from @temptab.
--I want to see the data in order as I am Inserting them. But its not working during the Dataadaptor.
Thanks in advance
