karina

karina

  • NA
  • 4
  • 4.3k

display a dataBase Table in my multiple column comboBox

Jul 11 2014 4:44 AM
Hi,
I 'am using multi column in combo box. So,I would like to display a database table like this http://www.codeproject.com/Articles/3206/Multi-Column-ComboBox
I tried the below coding but I get only the table date without the table borders:(without the table's form only the data from the Table) 
 
private void affich() {
SqlConnection connection = new SqlConnection(connectionString); 
connection.Open();            
req = "select id_amort_fiscal+''+amort_fiscal as combined from amortissementFiscal;"; 
SqlCommand sql = new SqlCommand(req, connection); 
dr = new SqlDataAdapter(req, connection);
dr.Fill(ds, "amortissementFiscal");
multiColumnComboBox1.DataSource = ds.Tables["amortissementFiscal"];
multiColumnComboBox1.DisplayMember="combined";
multiColumnComboBox1.ValueMember = "combined";
connection.Close(); 
}
thanks for Help 

Answers (1)