How to load multiple data table in DataSet

ASP.NET C# : Load multiple data table in DataSet. If you want to add multiple table in DataSet then need two SqlDataAdapter for DataSet.
Source code :

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default3.aspx.cs" Inherits="Default3" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
 
    </div>
        <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Add multiple table in dataSet" />
        <asp:GridView ID="GridView1" runat="server">
        </asp:GridView>
        <br />
        <asp:GridView ID="GridView2" runat="server"></asp:GridView>
    </form>
</body>
</html>

Code Behind Code

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class Default3 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection();
        con.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
        con.Open();

        SqlDataAdapter productadapter = new SqlDataAdapter();
        productadapter.TableMappings.Add("Table", "Suppliers");
        SqlCommand cmd = new SqlCommand();
        cmd.CommandText = "Select * from [Suppliers]";
        cmd.Connection = con;
        productadapter.SelectCommand = cmd;
        DataSet ds = new DataSet();
        productadapter.Fill(ds);

        SqlDataAdapter adapter = new SqlDataAdapter();
     adapter.TableMappings.Add("Table", "Products");
        SqlCommand cmd1 = new SqlCommand();
        cmd1.CommandText = "Select * from [Products]";
        cmd1.Connection = con;
        adapter.SelectCommand = cmd1;
     
        adapter.Fill(ds);

        con.Close();

        GridView1.DataSource = ds.Tables["Products"];
        GridView1.DataBind();

        GridView2.DataSource = ds.Tables["Suppliers"];
        GridView2.DataBind();




    }
}
Code Generate the following output


How to load multiple data table in DataSet

How to load multiple data table in DataSet How to load multiple data table in DataSet Reviewed by Jacob Lefore on May 15, 2015 Rating: 5

No comments