Loading data from database into muticolumn combobox

See more:

C#3.5

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();