Ad:

ASP.NET Discussion Thread
Unsolved
Views: 1682

Oct 14th, 2009

How to combine two tables into a single datagrid

Expand Post »

Hi,

I have a dataset which is having 5 tables. I want to get only two tables from that dataset and assign into a single datagrid. How can i do this?

Thanks in advance...

Similar Threads

combine three tables in MySQL
Can i use two tables in a single query in PHP
Searching Multiple tables... Please help me!!!!! in PHP
How to properly use tables in db? in PHP
how to get the difference between the data of the two files in Visual Basic 4 / 5 / 6

sanjanaa

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

6 posts
since Oct 2009

Permalink

Oct 14th, 2009

Re: How to combine two tables into a single datagrid

Try this Merge option,
ds.Merge(DataSet);

Splitting that two datatables in separate dataset.

chandru7

Reputation Points: 9

Solved Threads: 13

Junior Poster in Training

Offline

72 posts
since Sep 2009

Permalink

Oct 19th, 2009

Re: How to combine two tables into a single datagrid

Hi Chandru, Thank you very much for your kind reply. I did that method, but in that my problem is, i have 3 rows, 8 columns in table1 and 3 rows, 8 columns in table2. First 2 columns of both the tables are same. Always i will get row count is same for both the tables. So, if i use this merge method then it creates a table with 6 rows, and also after the 8th columns has no values in first 3 rows and first 8 columns has empty values in second 3 rows.

sanjanaa

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

6 posts
since Oct 2009

Permalink

Oct 19th, 2009

Re: How to combine two tables into a single datagrid

Hi,

i will work if both structure's or same.For different structure just try like this,

ASP.NET Syntax (Toggle Plain Text)
if(firstDataTable.Rows.Count > 0)
{
   //Add all Coulmns and values to 3rd datatable.
 
}
if(firstDataTable.Rows.Count > 0)
{
   //Add all Coulmns and values to 3rd datatable.
   
}

In that same way Add second datatable to third.

Last edited by peter_budo; Oct 24th, 2009 at 6:17 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks)

chandru7

Reputation Points: 9

Solved Threads: 13

Junior Poster in Training

Offline

72 posts
since Sep 2009

Permalink

Oct 19th, 2009

Re: How to combine two tables into a single datagrid

Hello there

If i understand u correctly, u need a Nested/group dataset in a single dataset

Do the following, i have created an eg for you.
follow the steps
1) In solution explorer Add-> new Items -> Select "XML Schema"
2) Give the name eg : CommonDS Set
3) Go to the properities of "CommonDS" and Change Custom tool Property: MsDataSetGenerator
4) Right Click CommonDS -> View Code
5) Paste the following code Then change the Table NAme & Column names as per your requirement.

ASP.NET Syntax (Toggle Plain Text)
<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="CommonDS" targetNamespace="http://tempuri.org/CommonDS.xsd" elementFormDefault="qualified" xmlns="http://tempuri.org/CommonDS.xsd" xmlns:mstns="http://tempuri.org/CommonDS.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema">
  <xs:element name="CommonDS">
    <xs:complexType>
      <xs:sequence>
        <xs:element name="Table1">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Col1" type="xs:string" />
              <xs:element name="Col2" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
 
        <xs:element name="Table2">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Column1" type="xs:string" />
              <xs:element name="Column2" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
 
      </xs:sequence>
    </xs:complexType>
  </xs:element>
</xs:schema>
<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="CommonDS" targetNamespace="http://tempuri.org/CommonDS.xsd" elementFormDefault="qualified" xmlns="http://tempuri.org/CommonDS.xsd" xmlns:mstns="http://tempuri.org/CommonDS.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema">
  <xs:element name="CommonDS">
    <xs:complexType>
      <xs:sequence>
        <xs:element name="Table1">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Col1" type="xs:string" />
              <xs:element name="Col2" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
       
        <xs:element name="Table2">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Column1" type="xs:string" />
              <xs:element name="Column2" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        
      </xs:sequence>
    </xs:complexType>
  </xs:element>
</xs:schema>

Pls. Mark as solved if it helps you

reach_yousuf

Reputation Points: 12

Solved Threads: 38

Junior Poster

Offline

194 posts
since Sep 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP.NET Forum Timeline: calling javascript after databse validation??

Next Thread in ASP.NET Forum Timeline: thumbnails for flv

DaniWeb Message

Cancel Changes

User Name
Password