Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 How to return a set of data to the calling program

Author  Topic 

Johny
Starting Member

1 Post

Posted - 2007-07-09 : 01:56:21
hi,
i am new to SQL. i am trying to retrieve a set of data(i.e. set of rows which satisfies my condition given in the select statement). i want to output this recordset to my calling program i.e C#.net. how could i do this. i was adviced to use temp tables. but i am not sure how to do it. can any one say that using the temp table is the correct way. if so can u give me some sample code.

my proble is

Table name: ProductDetails Table



It has following columns



ProductID Name UnitPrice Category Stock

when i give a category value from front end it should bring me the rows which comes under the given category. there will be many rows under this category. how could i send this set of rows back to my calling program.

regards,
Johny

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-07-09 : 02:36:18
If you are more worried on how to return data to .NET, better you post your question in .NET forums

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -