am trying to export 2 tables data in one excel sheet.

See more:

C#

C#4.0

Hi,

am trying to export 2 tables data in one excel sheet.

but it's exporting only 1st table data in excelsheet.

SqlDataAdapter dscmd2 = new SqlDataAdapter("SELECT * FROM DriveInfo; SELECT * FROM NetworkInfo", conn);
            dscmd2.TableMappings.Add("Table", "DriveInfo");
            dscmd2.TableMappings.Add("Table1", "NetworkInfo");
            DataSet ds2 = new DataSet();
            dscmd2.Fill(ds2);

            for (i = 0; i <= ds2.Tables[0].Rows.Count - 1; i++)
            {
                for (j = 0; j <= ds2.Tables[0].Columns.Count - 1; j++)
                {
                    //data = ds.Tables[0].Columns[j].ColumnName.ToString();

                    data = ds2.Tables[0].Rows[i].ItemArray[j].ToString();
                    //xlWorkSheet.Cells[i + 3, j + 1] = data;
                    xlWorkSheet2.Cells[i + 3, j + 1] = data;
                }
            }

Thanks
sam.198979