The Selected value from the drop down list is passing only "All"

See more:

C#

ASP.NET

The program below has to select from a drop down list.

I select from the drop which has in addition the element "All'.


However I noticed that it only the "All" element which is passed .

Any other selection is made redundant.


Please peruse the program and correct it.


Thanks

protected void Page_Load(object sender, EventArgs e)
        {

          dfi();

        }

        public void dfi()
        {
            try
            {
                
                {
                   
                    {
                        SqlConnection connect = new SqlConnection();
                        connect.ConnectionString = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString;
                        connect.Open();
                        SqlDataAdapter da = new SqlDataAdapter("select INT_NAME from Interest order by Int_name ", connect);

                        DataTable dt = new DataTable();

                        // DataSet ds = new DataSet();
                        da.Fill(dt);
                        ddInterest_Code.DataSource = dt;
                        ddInterest_Code.DataValueField = "INT_NAME";
                        ddInterest_Code.DataTextField = "INT_NAME";
                        ddInterest_Code.DataBind();
                        // connect.Close();

                        //Adding "Please select" option in dropdownlist for validation
                       // ddInterest_Code.Items.Insert(0, new ListItem("      ", "0"));
                        ddInterest_Code.Items.Insert(0, new ListItem("All", "All"));
                    }
                }
            }
            catch
            {

            }

        }

        

        protected void btn_Close_Click(object sender, EventArgs e)
        {
            Response.Redirect("~/Default.aspx");
        }

        protected void btn_Create_Click(object sender, EventArgs e)
        {

            ///PROCESS BEGIN
            string str;
            str = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString;
            SqlConnection sqlCon = new SqlConnection(str);


            try
            {
                sqlCon.Open();
                SqlCommand SqlCmd = new SqlCommand("rpt_group_statement", sqlCon);
                SqlCmd.CommandType = System.Data.CommandType.StoredProcedure;

                //Create and supply the output parameters

                SqlCmd.Parameters.AddWithValue("@ZGROUP", SqlDbType.VarChar).Value  = ddInterest_Code.Text;
                SqlCmd.Parameters.AddWithValue("@ZPERIOD", SqlDbType.VarChar).Value = ddl_Period.Text;
                SqlCmd.Parameters.AddWithValue("@ZYEAR", SqlDbType.VarChar).Value   = ddl_Year.Text;

              
                SqlCmd.ExecuteNonQuery();

                Session["dfi"] = ddInterest_Code.Text.Trim();

                Response.Redirect("~/statement/rpt_Group_Statement.aspx");
           

            }
            catch (Exception ex)
            {
                lblStatus.Text = ex.Message;
            }
            finally
            {

                //*********   ReportViewer1.LocalReport.Refresh();

            }

            ///PROCESS END

        }

        protected void ddInterest_Code_SelectedIndexChanged(object sender, EventArgs e)
        {
            Session["dfi"] = ddInterest_Code.Text;
        }