Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on Jul 24th, 2012  |  syntax: None  |  size: 1.64 KB  |  hits: 9  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Listbox Returns Empty String on SelectedIndexChanged Event
  2. <asp:ListBox ID="lstBxMyList" runat="server" CssClass="binorderlst1"
  3.      DataTextField="myName"
  4.      DataValueField="myID"
  5.      OnSelectedIndexChanged ="lstBxMyList_SelectedIndexChanged"
  6.      AutoPostBack="true" Rows="10">
  7. </asp:ListBox>
  8.        
  9. protected void lstBxMyList_SelectedIndexChanged(object sender, EventArgs e)
  10. {
  11.     myID = Convert.ToInt32(lstBxSiteList.SelectedValue.ToString());
  12.  
  13.     ... rest of code
  14. }
  15.        
  16. private void BindLstBxMyList(int myOtherID)
  17.     {
  18.         DataTable dt = new DataTable();
  19.         SqlConnection conn;
  20.         SqlCommand comm;
  21.  
  22.         using (conn = new SqlConnection(aSHconns.aconn))
  23.         {
  24.             comm = new SqlCommand("myStoredProc", conn);
  25.             comm.CommandType = CommandType.StoredProcedure;
  26.             comm.Parameters.Add(new SqlParameter("@myOtherID", SqlDbType.Int));
  27.             comm.Parameters["@myOtherID"].Value = myOtherID;
  28.             SqlDataAdapter sqlDa = new SqlDataAdapter(comm);
  29.  
  30.             try
  31.             {
  32.                 conn.Open();
  33.                  sqlDa.Fill(dt);
  34.                  if (dt.Rows.Count > 0)
  35.                  {
  36.                      lstBxMyList.DataSource = dt;
  37.                      lstBxMyList.DataTextField = "myName";
  38.                      lstBxMyList.DataValueField = "myID";
  39.                      lstBxMyList.DataBind();
  40.                  }
  41.  
  42.             }
  43.  
  44.             finally
  45.             {
  46.                 conn.Close();
  47.             }
  48.         }
  49.  
  50.     }
  51.        
  52. protected void Page_Load(object sender, EventArgs e)
  53.         {
  54.             if (!IsPostBack)
  55.             {
  56.              //Bind your listbox here
  57.             }
  58.          }