DataGrid Interesting problem

[yogesh_bagul]

-----------------------------------------------------------

New Message on MumbaiUserGroup

-----------------------------------------------------------
From: yogesh_bagul
Message 1 in Discussion

hi,
  frnds i m facing very interesting problem in datagrid..
  
  i have 2 Tables
  Table Name-Vendor
       cols-      Vendor_Id (primary Key)
                    Vendor_Name
  
  Table2 Name-Product 
   cols-           vendor_Id (ref Vendoe.Vendor_Id)
                     Product_Id ( Pk)
                     Product Name 
                    Product Prize
  
  and i want to disaply it as
  
  --------------------------------------------------
 
 |                Vendor Name1                        |
  --------------------------------------------------
  |Pr ID1 | product Name1 | Product Prize1    |
  -------------------------------------------------
  |Pr ID2 | product Name2 | Product Prize2    |
    -------------------------------------------------
  --------------------------------------------------
  |                Vendor Name2                         |
    --------------------------------------------------
    |Pr ID | product Name | Product Prize    |
   
 -------------------------------------------------
  --------------------------------------------------
  |                Vendor Name3                         |
    --------------------------------------------------
    |Pr ID | product Name | Product Prize    |
    -------------------------------------------------
  
  if anybody have some idea pls help me !!!!
  
  thanks in adavance...
  
     
  

<TABLE CELLSPACING="1" CELLPADDING="1" BORDER="0">
 <TR><TD>
 <A HREF="http://sig.graphicsfactory.com/";>
 <IMG SRC="http://sig.graphicsfactory.com/Flaming_Text/y.gif"; BORDER="0"><IMG 
SRC="http://sig.graphicsfactory.com/Flaming_Text/o.gif"; BORDER="0"><IMG
 SRC="http://sig.graphicsfactory.com/Flaming_Text/g.gif"; BORDER="0"><IMG 
SRC="http://sig.graphicsfactory.com/Flaming_Text/e.gif"; BORDER="0"><IMG 
SRC="http://sig.graphicsfactory.com/Flaming_Text/s.gif"; BORDER="0"><IMG 
SRC="http://sig.graphicsfactory.com/Flaming_Text/h.gif"; BORDER="0">
 </A><DIV ALIGN="right"><a href="http://www.graphicsfactory.com/"; title="Clip 
Art, Inc."><FONT FACE="Verdana" SIZE="-2">Images by Graphics 
Factory.com</FONT></a></DIV></TD></TR></TABLE>
 
 


                New Yahoo! Messenger with Voice. Call regular phones from your 
PC and save big.

-----------------------------------------------------------

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/MumbaiUserGroup/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member 
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you 
received this message by mistake, please click the "Remove" link below. On the 
pre-addressed e-mail message that opens, simply click "Send". Your e-mail 
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]