title: Index is not changing in Drop Down Menu C# Asp.Net
body: <p>I have a <code>DropDownList</code> which is filled up from database. When I select a record on index 1, it comes up with right results but when I select second index, it comes up with same index. it looks like <code>DropDownList</code> shows First Index as by default. How can I select change index in <code>DropDownList</code>?
  So if would select index 3 the result must be from index 3.
  I have tried <code>DropDownList.SelectedItem</code>,<code>DropDownList.SelectedValue</code>,<code>DropDownList.SelectedIndex</code>,<code>DropDownList.Text</code> but No effect seems to be there.</p>
  
  <p><strong>DropDownList Loading on Page_Load</strong></p>
  
  <pre><code> public void load_Individual()
      {
          if (IsPostBack == false)
          {
              SqlDataAdapter sdaIndividual = new SqlDataAdapter("select * from tbl_trip", _connectionString);
              DataTable dtIndividual = new DataTable();
              sdaIndividual.Fill(dtIndividual);
              if (dtIndividual.Rows.Count &gt; 0)
              {
                  ddl_Individual.DataTextField = "TruckNo";
                  ddl_Individual.DataValueField = "TruckNo";
                  ddl_Individual.DataSource = dtIndividual;
                  ddl_Individual.DataBind();
              } 
          }
      }
  </code></pre>
  
  <p><strong>DropDownList For Selecting Values</strong></p>
  
  <pre><code>if (ddl_Individual.Text != string.Empty)
          {
              ddl_Individual.ClearSelection();
              adp = new SqlDataAdapter(@"Select * , '' as c1, '' as c2, 0 as c3 , 0 as c4 , 0 as c5 , 0 as c6, 0 as c7 , 0 as c8 from tbl_Trip 
              where TruckNo='" + ddl_Individual.SelectedValue + "'", _connectionString);
              adp.Fill(Dt);
              Session["mydata"] = Dt;
              Response.Redirect("LoadReport.aspx");
          }
          else
          {
              ScriptManager.RegisterClientScriptBlock(this, this.GetType(),"alertMessage","aler('select valid value')", true);
          }
  </code></pre>