Use a "UNION" or "CROSS JOIN" in your SQL Query. - Subramanya K Vemuri-Venkata.
----- Original Message ----- From: Karthick Kumar To: [EMAIL PROTECTED] Sent: Friday, May 21, 2004 11:50 AM Subject: RE: [AspNetAnyQuestionIsOk] Two sql queries But I need to format the table and the data and customise it, can I do that with the results of the Datagrids using a datareader or datatable ?. Karthick ________________________________ From: Mischa Kroon [mailto:[EMAIL PROTECTED] Sent: 21 May 2004 16:41 To: [EMAIL PROTECTED] Subject: Re: [AspNetAnyQuestionIsOk] Two sql queries use 2 datagrids and fill them :) using a datareader or datatable ----- Original Message ----- From: "Karthick Kumar" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 21, 2004 10:30 AM Subject: [AspNetAnyQuestionIsOk] Two sql queries > Hi, > > In a web form in a .aspx page, I need to display information > from two tables, simultaneously. So obviously, it means that I need to > execute two queries. And I need all the data in all the fields of two > tables to be displayed in a formatted table, separately. How do I > achieve it ?. > > Please help. Thanks in advance. > > Regards, > Karthick > > > ------------------------------------------------------------------------ -- ---------------- > Louth Local Authorities supporting- Nissan Irish Open- Co. Louth Golf Club, Baltray 22nd-25th July > ------------------------------------------------------------------------ -- ---------------- > ******************************************************************** > This message is intended only for the use of the person(s) ("the intended > recipient(s)") to whom it is addressed. It may contain information which is > privileged and confidential within the meaning of applicable law. If you > are not the intended recipient, please contact the sender as soon as > possible. The views expressed in this communication may not necessarily > be the views held by Louth County Council. > > Any attachments have been checked by a virus scanner and appear to be > clean. > Please ensure that you also scan all messages, as Louth County > Council does not accept any liability for contamination or damage > to your systems. > ******************************************************************** > > > > > > > Yahoo! Groups Links > > > > > Yahoo! Groups Sponsor ADVERTISEMENT click here <http://rd.yahoo.com/SIG=1299opnke/M=295196.4901138.6071305.3001176/D=gr oups/S=1705006764:HM/EXP=1085240714/A=2128215/R=0/SIG=10se96mf6/*http:// companion.yahoo.com> <http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group s/S=:HM/A=2128215/rand=418242510> ________________________________ 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] <mailto:[EMAIL PROTECTED] cribe> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . ------------------------------------------------------------------------------------------ Louth Local Authorities supporting- Nissan Irish Open- Co. Louth Golf Club, Baltray 22nd-25th July ------------------------------------------------------------------------------------------ ******************************************************************** This message is intended only for the use of the person(s) ("the intended recipient(s)") to whom it is addressed. It may contain information which is privileged and confidential within the meaning of applicable law. If you are not the intended recipient, please contact the sender as soon as possible. The views expressed in this communication may not necessarily be the views held by Louth County Council. Any attachments have been checked by a virus scanner and appear to be clean. Please ensure that you also scan all messages, as Louth County Council does not accept any liability for contamination or damage to your systems. ******************************************************************** [Non-text portions of this message have been removed] ------------------------------------------------------------------------------ Yahoo! Groups Links a.. To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ b.. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor ---------------------~--> Yahoo! Domains - Claim yours for only $14.70 http://us.click.yahoo.com/Z1wmxD/DREIAA/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/
