ASP.NET C# add Multiple table into DataSet

January 12, 2016 , 0 Comments

In this article, I will show you, How to add multiple Database tables in DataSet. I write many articles on DataSet. We all know that we can store multiple Database Table in it. To do this task, first of all add two Gridview control on web form, now your web form look like :

Source Code

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

<!DOCTYPE html>

<html xmlns="">
<head runat="server">
    <form id="form1" runat="server">

        <asp:GridView ID="GridView1" runat="server">
        <br />
        <asp:GridView ID="GridView2" runat="server">


Here, I am using two Gridview control. Both are bind with different tables. Actually i am retriving two tables using SQL Query. For the binding we are using two class i.e SqlConnection and SqlCommand.

Code Behind File

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 addmultipletable : System.Web.UI.Page
    protected void Page_Load(object sender, EventArgs e)

    private void bindgrid()
        string query="select * from [user_table]";
        query +="select * from [customer]";
        SqlConnection con = new SqlConnection();
        SqlCommand cmd=new SqlCommand();
        cmd.CommandText =query;
        DataSet ds=new DataSet();
        SqlDataAdapter da=new SqlDataAdapter(cmd);
        GridView1.DataSource = ds.Tables[0];
        GridView2.DataSource = ds.Tables[1];
      //  throw new NotImplementedException();

Jacob Lefore

Some say he’s half man half fish, others say he’s more of a seventy/thirty split. Either way he’s a fishy bastard. Google