You can manipulate datatables before sending them to the grid. But you can also do some manipulation in the grid or through sql.
Doing multiple query's or having multiple grids on a page isn't a problem. ----- Original Message ----- From: "Karthick Kumar" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 21, 2004 6:07 PM Subject: RE: [AspNetAnyQuestionIsOk] Two sql queries > OK, I kow what you mean. But I want two individual SQL queries and not a > joint one ! > > Karthick > > > ________________________________ > > From: Subramanya K Vemuri-Venkata [mailto:[EMAIL PROTECTED] > Sent: 21 May 2004 17:03 > To: [EMAIL PROTECTED] > Subject: Re: [AspNetAnyQuestionIsOk] Two sql queries > > > 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 > ADVERTISEMENT > click here > <http://rd.yahoo.com/SIG=129p5lmf6/M=295196.4901138.6071305.3001176/D=gr > oups/S=1705006764:HM/EXP=1085241902/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=481584620> > > ________________________________ > > 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 > > > > > ------------------------ 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/
