Bind multiple ASP.Net GridViews using single Stored Procedure in C# and VB.Net

Use two select query in the procedure to select record from multiple table.

Call the procedure and fill the record in DataSet.

Then use the DataSet tables properties and assign to GridView.

Check the sample code.

C#

private void BindGridView()
{
    string conString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(conString))
    {
        SqlCommand cmd = new SqlCommand("GetReportsDate");
        using (SqlDataAdapter sda = new SqlDataAdapter())
        {
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Connection = con;
            sda.SelectCommand = cmd;
            using (DataSet ds = new DataSet())
            {
                sda.Fill(ds);

                GridView1.DataSource = ds.Tables[0];
                GridView1.DataBind();
                GridView2.DataSource = ds.Tables[1];
                GridView2.DataBind();
            }
        }
    }
}

VB.Net

Private Sub BindGridView()
    Dim conString As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
    Using con As SqlConnection = New SqlConnection(conString)
        Dim cmd As SqlCommand = New SqlCommand("GetReportsDate")
        Using sda As SqlDataAdapter = New SqlDataAdapter()
            cmd.CommandType = CommandType.StoredProcedure
            cmd.Connection = con
            sda.SelectCommand = cmd
            Using ds As DataSet = New DataSet()
                sda.Fill(ds)
                GridView1.DataSource = ds.Tables(0)
                GridView1.DataBind()
                GridView2.DataSource = ds.Tables(1)
                GridView2.DataBind()
            End Using
        End Using
    End Using
End Sub