列表框显示system.data.datarowview [英] Listbox show system.data.datarowview

问题描述

列表框显示System.Data.DataRowView而不是实际值。



我尝试过：

listbox show System.Data.DataRowView instead of real values.

What I have tried:

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
      /*  if (DropDownList1.SelectedValue == DropDownList1.SelectedItem.Text)
        {
            string query = "SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME="+ "DropDownList1.SelectedItem.Text+" ;
            DataTable dt = _Default.ExecuteQuery(query);
            ListBox1.Items.Clear();
            ListBox1.DataSource = dt;
            ListBox1.DataBind();

        }*/
        string query = "SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='" + DropDownList1.SelectedItem.Text+"'";



        using (SqlCommand cmd = new SqlCommand(query))
        {
            using (SqlDataAdapter sda = new SqlDataAdapter())
            {
                cmd.Connection = con;
                sda.SelectCommand = cmd;
                using (DataSet ds = new DataSet())
                {

                    sda.Fill(ds);


                    ListBox1.DataSource = ds.Tables[0];
                    ListBox1.DataBind();

                }

            }
        }

推荐答案

请添加以下代码



ListBox1.DataSource = ds.Tables [0];

ListBox1.DataValueField = ds.Tables [0 ] .Columns [ 而valueColumnName]的ToString（）; //绑定值字段

ListBox1.DataTextField = ds.Tables [0] .Columns [DisplayColumnname]。ToString（）; ; //绑定显示字段

ListBox1.DataBind（）;

Please add the below code

ListBox1.DataSource = ds.Tables[0];
ListBox1.DataValueField = ds.Tables[0].Columns["ValueColumnname"].ToString(); //To bind value field
ListBox1.DataTextField = ds.Tables[0].Columns["DisplayColumnname"].ToString(); ;//To bind display field
ListBox1.DataBind();

这篇关于列表框显示system.data.datarowview的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！