c# - System.Data.DataRowView，C#

Question

我有一个问题:

SqlDataAdapter da = new SqlDataAdapter("SELECT dbo.User.name FROM dbo.User", con);
DataTable dt = new DataTable();
comboBox1.DataSource = dt;
da.Fill(dt);

它在每一行中返回 System.Data.DataRowView。

我试过:

comboBox1.ValueMember = "idUser";
comboBox1.DisplayMember = "dbo.User.name"

然后出现错误:

Cannot bind to the new display member. Parameter name: newDisplayMember

我想获取idUser 和name。谢谢

Answer 1

填写DataTable后，需要在SELECT语句中返回ID，并将DataTable指定为DataSource:

 SqlDataAdapter da = new SqlDataAdapter("SELECT IDUser, Name FROM dbo.User", con);
 DataTable dt = new DataTable();
 da.Fill(dt); 

然后您可以这样设置 ComboBox:

comboBox1.DataSource = dt.DefaultView;
comboBox1.ValueMember = "IDUser";
comboBox1.DisplayMember = "Name"

更新

如果您想访问组合框中所选项目的所选文本或值，那么您需要执行如下操作:

DataRowView drvItem = comboBox1.SelectedItem as DataRowView;

if (drvItem != null)
{
    label4.Text = drvItem["ID"].ToString();
    label3.Text = drvItem["Name"].ToString();
}