OH, that was SQL view NOT stored procedure... could anybody please tell me how to execute a SQL views in asp.net ?. thanks.....
Karthick -----Original Message----- From: Karthick Kumar [mailto:[EMAIL PROTECTED] Sent: 15 October 2004 09:45 To: [EMAIL PROTECTED] Subject: RE: [AspNetAnyQuestionIsOk] data from 3 tables Hi, can anybody please tell me how to execute a stored procedure in asp.net ?. I use VB. Thanks. Regards, Karthick -----Original Message----- From: Eric Cantrall [mailto:[EMAIL PROTECTED] Sent: 14 October 2004 18:27 To: '[EMAIL PROTECTED]' Subject: RE: [AspNetAnyQuestionIsOk] data from 3 tables I don't really think you want to use a stored procedure for your query. It sounds like you need to create a view. You must code a stored procedure with output variables to get data back from a stored procedure. Create a view which is like a compiled query. Then select from the view all the records you need. HTH --Eric -----Original Message----- From: Karthick Kumar [mailto:[EMAIL PROTECTED] Sent: Thursday, October 14, 2004 1:10 PM To: [EMAIL PROTECTED] Subject: [AspNetAnyQuestionIsOk] data from 3 tables Hi, As I am building a Report app in asp.net, I want to just display the retrieved data in a Data table instead of binding to a datagrid etc. I have written a stored procedure for it, which queries the data from 3 tables. My question is how can I use the dataset or datareader and display the retrieved values in the data table ?. Please help, thanks. Karthick [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT <http://us.ard.yahoo.com/SIG=12986da0s/M=315388.5497957.6576270.3001176/D=gr oups/S=1705006764:HM/EXP=1097860266/A=2372354/R=0/SIG=12id813k2/*https:/www. orchardbank.com/hcs/hcsapplication?pf=PLApply&media=EMYHNL40F21004SS> click here <http://us.adserver.yahoo.com/l?M=315388.5497957.6576270.3001176/D=groups/S= :HM/A=2372354/rand=867756807> _____ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/> * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED] e> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . [Non-text portions of this message have been removed] Yahoo! Groups Links Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
