Question

当试图填充Combo盒时

con.Open();
da = new SqlDataAdapter("Mt_Post_select",con);
//Mt_Post is Stored procedure with Select Command
ds1 = new DataSet();
da.Fill(ds1, "Mt_Post");
// The table has only one row
comboBox1.DataSource = ds1.Tables[0];
comboBox1.DisplayMember = "Mt_Post";

但是它没有数据显示它有<编码>System.Data.DataRowView。

该法典是错误的请告诉我:

Answer 1

替换Mt_Post,载于comboBox1.Display Members = “Mt_Post”;,其数值是你希望显示的栏目。

Answer 2

我希望以下样本有所帮助;

        DataTable dt = new DataTable();
        dt.Columns.Add("Name");
        dt.Columns.Add("Email");
        dt.AcceptChanges();

        DataRow dr0 = dt.NewRow();
        dr0[0] = "Kadir Sumerkent";
        dr0[1] = "kadir@sumerkent.com";

        DataRow dr1 = dt.NewRow();
        dr1[0] = "Kadir Sumerkent 2";
        dr1[1] = "kadir@sumerkent2.com";

        dt.Rows.Add(dr0);
        dt.Rows.Add(dr1);
        dt.AcceptChanges();

        comboBox1.DisplayMember = "Name";
        comboBox1.ValueMember = "Email";
        comboBox1.DataSource = dt;

Answer 3

让我们努力:

附录

SELECT 
     Users.User_name AS username
     Users.User_Code AS userID
FROM Users
-- WHERE CONDITONS ARE APPLIED

现在,为了<代码>Fetch,DataSet,你将做如下工作:


// YOUR OWN CODE
con.Open();
da = new SqlDataAdapter("Mt_Post_select",con);
//Mt_Post is Stored procedure with Select Command
ds1 = new DataSet();

// JUST FILL THE DataSet in THIS WAY
da.Fill(ds1);

// JUST TO MAKE SURE WE HAVE AN EMPTY COMBOBOX
comboBox1.Items.Clear();
comboBox1.DataSource = null;

// NOW POPULATE comboBox1 LIKE THIS
if (ds.Tables[0].Rows.Count  > 0)
{
  comboBox1.DataSource = ds1.Tables[0];
  comboBox1.DisplayMember = "username";
  comboBox1.ValueMember = "userID"
}

友情链接