I Need This To Be Done Using Only Single Stored Procedure For Binding Field Value To DropDownBox And For Adding Income. Plz Tell Me How To Do This?

 

My task is to add income by taking few variables from webpage. I had take User ID(From database), Field value by selecting it from DropDownBox( Which value is once again taken from database), Income Description, Date, Amount . I had completed this task successfully by binding DropDownBox to database by query string and added income using stored procedure as below.

 

  I need this to be done using only single Stored Procedure for binding Field Value to DropDownBox  and for adding income. Plz tell me how to do this?

ASPX.CS file

protected void Page_Load(object sender, EventArgs e)

    {

        SqlConnection con = null;

       

            con = DataBaseConnection.GetConnection();

            DataSet ds = new DataSet();

            SqlDataAdapter da = new SqlDataAdapter("select PA_IFName from PA_IncomeFields where PA_UID=@PA_UID", con);

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

            da.Fill(ds);

          

            IFDdl.DataSource = ds;

        IFDdl.DataTextField= ds.Tables[0].Columns[0].ToString();

        IFDdl.DataValueField = ds.Tables[0].Columns[0].ToString();

            IFDdl.DataBind();

       

       

    }

    protected void IncAddBtn_Click(object sender, EventArgs e)

    {

        SqlConnection con = null;

        try

        {

            con = DataBaseConnection.GetConnection();

 

            SqlCommand cmd = new SqlCommand("AddIncome", con);

            cmd.CommandType = CommandType.StoredProcedure;

            //SqlCommand cmd = new SqlCommand("",con);

            //cmd.CommandText = "insert into PA_Income values(@PA_UID,@PA_IFName,@PA_IDesc,@PA_IDate,@PA_IAmt)";

           

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

            cmd.Parameters.Add("@PA_IFName", SqlDbType.VarChar, 10).Value = IFDdl.SelectedValue;

            cmd.Parameters.Add("@PA_IDesc", SqlDbType.VarChar, 50).Value = IFDescTB.Text;

            cmd.Parameters.Add("@PA_IDate", SqlDbType.DateTime).Value = Convert.ToDateTime(IFDateTB.Text);

            cmd.Parameters.Add("@PA_IAmt", SqlDbType.Money).Value = Convert.ToDecimal(IFAmtTB.Text);

 

            cmd.ExecuteNonQuery();

            IFLabelMsg.Text = "Income Added Successfully!";

 

        } // end of try

        catch (Exception ex)

        {

            IFLabelMsg.Text = "Error : " + ex.Message;

        }

        finally

        {

            con.Close();

        }

    }

 

Stored Procedure

ALTER PROCEDURE dbo.AddIncome (@PA_UID int,@PA_IFName varchar(10),@PA_IDesc varchar(50),@PA_IDate datetime,@PA_IAmt money)

      /*

      (

      @parameter1 int = 5,

      @parameter2 datatype OUTPUT

      )

      */

AS

 

 

/*SET NOCOUNT ON*/

 

     

      insert into PA_Income values(@PA_UID,@PA_IFName,@PA_IDesc,@PA_IDate,@PA_IAmt)

 

ASPX File

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="AddIncome.aspx.cs" Inherits="AddIncome" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

 

<h2>

        Add Income </h2>

    <br />

        <table>

            <tr>

                <td>

                    Select Income Field</td>

                <td>

                    <asp:DropDownList ID="IFDdl" runat="server" Width="247px"   >

                    </asp:DropDownList>

                    <a href="addincomefield.aspx">Add Income Field</a>

                   

                    </td>

                   

            </tr>

            <tr>

                <td>

                    Enter Income Amount

                </td>

                <td>

                    <asp:TextBox ID="IFAmtTB" runat="server" Width="96px"></asp:TextBox>

                    Date &nbsp;<asp:TextBox ID="IFDateTB" runat="server" Width="93px"></asp:TextBox>(MM/DD/YY)</td>

            </tr>

            <tr>

                <td>

                    Enter Income Description

                </td>

                <td>

                    <asp:TextBox ID="IFDescTB" runat="server" Width="239px"></asp:TextBox></td>

            </tr>

        </table>

   <br />

    <asp:Button ID="IncAddBtn" runat="server"  Text="Add Income" OnClick="IncAddBtn_Click"  /><br />

    <br />

    <asp:Label ID="IFLabelMsg" runat="server"></asp:Label>

</asp:Content>

 

 

 

  I need this to be done using only single Stored Procedure for binding Field Value to DropDownBox  and for adding income. Plz tell me how to do this?