Calling Three Different Variable Coming From Three Different Sql Queries Which Defined In Same Stored Procedure From DataAdapter

 

My task is to bind and show 3 different values coming from three different queries into three different columns of GridView. I had done this as mention in below. Program was successful. But I want to excute these three queries in same Stored Procedure. I can do that and stored in seperated variables. I need help how to call these three different values in data adapters and store each value in three different columns of grid view.

 

Simply I want to below statement in stored procedures and call from program.  Can any one help me plz.

 

 

 

 

con = DataBaseConnection.GetConnection();

 

DataSet ds = new DataSet();

           

SqlDataAdapter da = new SqlDataAdapter("select isnull(sum(PA_DAmt),0) from PA_Deposits where PA_UID = @PA_UID", con);

da.SelectCommand.Parameters.Add("@PA_UID", SqlDbType.Int).Value = Convert.ToInt32(Session["PA_UID"]);

da.Fill(ds,"Dep");

           

SqlDataAdapter da1 = new SqlDataAdapter("select isnull(sum(PA_EAmt),0) from PA_Expenses where PA_UID = @PA_UID", con);

da1.SelectCommand.Parameters.Add("@PA_UID", SqlDbType.Int).Value = Convert.ToInt32(Session["PA_UID"]);

da1.Fill(ds,"Exp");

           

           

SqlDataAdapter da2 = new SqlDataAdapter("select isnull(sum(PA_IAmt),0) from PA_Income where PA_UID = @PA_UID", con);

da2.SelectCommand.Parameters.Add("@PA_UID", SqlDbType.Int).Value = Convert.ToInt32(Session["PA_UID"]);

da2.Fill(ds,"Inc");

 

string deposits = Convert.ToString(ds.Tables["Dep"].Rows[0].ItemArray[0]);

string expenses = Convert.ToString(ds.Tables["Exp"].Rows[0].ItemArray[0]);

string income = Convert.ToString(ds.Tables["Inc"].Rows[0].ItemArray[0]);

           

GridView1.DataSource = ds;

GridView1.DataBind();

GridView1.Rows[0].Cells[0].Text = "Total";

GridView1.Rows[0].Cells[1].Text = deposits

GridView1.Rows[0].Cells[2].Text = expenses;

GridView1.Rows[0].Cells[3].Text = income;

//The above program was success.

 

// This is another way I had tried. But failed. I am getting Index out of bound error. Can any solve this if possible to u.

SqlCommand cmd = new SqlCommand("select isnull(sum(PA_DAmt),0) from PA_Deposits where PA_UID = @PA_UID", con);

cmd.Parameters.Add("@PA_UID", SqlDbType.Int).Value = (int)Session["PA_UID"];

GridView1.Rows[0].Cells[1].Text = cmd.ExecuteScalar().ToString();

 

cmd.CommandText = "select isnull(sum(PA_EAmt),0) from PA_Expenses where PA_UID = @PA_UID";

GridView1.Rows[0].Cells[2].Text = cmd.ExecuteScalar().ToString();

 

cmd.CommandText = "select isnull(sum(PA_IAmt),0) from PA_Income where PA_UID = @PA_UID";

GridView1.Rows[0].Cells[3].Text = cmd.ExecuteScalar().ToString();

 

ASPX Code for Grid View

<h2>Account Summary</h2><br />

  

    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" emptydatatext="There are no data records to display." Width="238px" >

            <Columns>

                <asp:TemplateField >

                   

                    <ItemTemplate>

                        <asp:Label ID="Label1" runat="server" Text="Total"></asp:Label>

                    </ItemTemplate>

                </asp:TemplateField>

                <asp:TemplateField   ><%--HeaderText="Deposits"--%>

                    <ItemTemplate>

                       

                    

                    </ItemTemplate>

                    <HeaderTemplate>

                        <a href="Deposits.aspx" >Deposits</a>

                    </HeaderTemplate>

                    <ItemStyle HorizontalAlign="Center" />

                </asp:TemplateField>

              

                <asp:TemplateField >

                    

                     <HeaderTemplate>

                        <a href="Expenses.aspx">Expenses</a>

                    </HeaderTemplate>

                    <ItemStyle HorizontalAlign="Center" />

                    <ItemTemplate>

                  

                   

                    </ItemTemplate>

                </asp:TemplateField>

                <asp:TemplateField   >

                    <HeaderTemplate>

                        <a href="Income.aspx">Income</a>

                    </HeaderTemplate>

                  

                 

                    <ItemStyle HorizontalAlign="Center" />

                    <ItemTemplate>

                   <%-- <%# Eval("Course") %>--%>

                    

                    </ItemTemplate>

                </asp:TemplateField>

              

            </Columns>

        </asp:GridView>

 

Plz solve this.