将数据从数据库加载到muticolumn组合框中 [英] Loading data from database into muticolumn combobox

问题描述

我在实现多列组合框时遇到问题（使用windows组合框）。我需要将数据库中的四个字段填充到ComboBox中（但不连接）。我有下面给出的代码。我在每一行都收到错误。请帮帮我。







提前致谢。

Hi, I am having a problem on implementing multi-column combo box (using windows combo box). I need to populate four fields from database into ComboBox (but not concatenated). I have the code given below. I getting error on every line. Please help me in this regard.



Thanks in advance.

string selectString = "SELECT tCode,tName,tShName,tPrice " +
"FROM tTests " +
"WHERE dpCode =2";

DataTable dt = new DataTable();
con.Open();
SqlCommand sqlCmd = new SqlCommand(selectString, con);
sqlCmd.CommandTimeout = 0;
sqlCmd.CommandType = CommandType.Text;
sqlCmd.ExecuteNonQuery();
SqlDataAdapter adptr = new SqlDataAdapter(sqlCmd);
adptr.Fill(dt);


dt.Columns.Add("tCode", typeof(string));
dt.Columns.Add("tName", typeof(string));
dt.Columns.Add("tShName", typeof(string));
dt.Columns.Add("tPrice", typeof(string));


foreach (DataRow myDataRow in dt.Rows)
{
dt.Rows.Add("tCode = " + myDataRow["tCode"]);
dt.Rows.Add("tName = " + myDataRow["tName"]);
dt.Rows.Add("tShName = " + myDataRow["tShName"]);
dt.Rows.Add("tPrice = " + myDataRow["tPrice"]);
}

cboTests.DataSource = dt;
cboTests.DisplayMember = "tName";
cboTests.ValueMember = "tShName";
cboTests.SelectedIndex = -1;
cboTests.Text = "";
con.Close();

推荐答案

请参阅：多列组合框 [ ^ ]（CP文章）

另一个有用的链接： ListBox和ComboBox [ ^ ]

See this: Multi-Column ComboBox[^] (CP article)
Another useful link: ListBox and ComboBox[^]

这篇关于将数据从数据库加载到muticolumn组合框中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！