c# - 无法在 asp.net web 应用程序中填充列表框

Question

我正在尝试从 SQL 数据库中的客户表填充列表框。我使用 WPF 列表框进行了测试，代码运行良好，但是当我尝试在 asp.net web 应用程序中实现时，我无法填充列表框.这是我的代码

 try
            {
                string query = "SELECT customer_ID FROM Customers WHERE ID = 1";
                SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
                conn.Open();
                SqlDataAdapter da = new SqlDataAdapter(query , conn);
                da.Fill(ds);
                foreach (DataRow row in ds.Tables[0].Rows)
                {
                    listbox1.SelectedValue = row["customer_ID"].ToString();
                    samplelist.Add(listbox1.SelectedValue);

                }

                listbox1.DataSource = samplelist;
            }
            catch (Exception)
            {
            }

谁能指导我正确的方向？

Answer 1

尝试使用下面的代码:

        try
        { 
            string query = "SELECT customer_ID FROM Customers WHERE ID = 1"; 
            SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()); 
            conn.Open(); 
            SqlDataAdapter da = new SqlDataAdapter(query, conn); 
            da.Fill(ds);

            listbox1.DataSource = ds.Tables[0];
            listbox1.DataTextField = "WORKSTATION_ID";
            listbox1.DataValueField = "WORKSTATION_ID";
            listbox1.DataBind();

        }
        catch (Exception) 
        { 
        }