c# i problem sa dvije kolumne u DataGridView
Pozdrav.
Postavio sam dvije kolumne u DataGridView. Pokusavam da u drugoj kolumni dobijem CustomerID od one Kompanije koju sam izabrao u prvoj Columni.
string sql2 = "SELECT * FROM Customers";
SqlDataAdapter da2 = new SqlDataAdapter(sql2, conn);
DataTable dt = new DataTable();
da2.Fill(dt);
DataGridViewComboBoxColumn cbc1 = new DataGridViewComboBoxColumn();
cbc1.DataSource = dt;
cbc1.ValueMember = "CompanyName";
cbc1.DisplayMember = "CompanyName";
cbc1.HeaderText = "Autor(en)";
cbc1.DisplayStyle = DataGridViewComboBoxDisplayStyle.ComboBox;
cbc1.Width = 250;
dataGridView1.Columns.Add(cbc1);
// e ovdje dolazi do problema --> dataGridView1.Columns[0].ToString() - ne prikaze mi nista u drugok koloni iako oznacim ime kompanije u prvoj
string sql3 = "SELECT CustomerID FROM Customers WHERE CompanyName ='"+ dataGridView1.Columns[0].ToString() +"'";
SqlDataAdapter da3 = new SqlDataAdapter(sql3, conn);
DataTable dt3 = new DataTable();
da3.Fill(dt3);
DataGridViewComboBoxColumn cbc2 = new DataGridViewComboBoxColumn();
cbc2.DataSource = dt3;
cbc2.ValueMember = "CustomerID";
cbc2.DisplayMember = "CustomerID";
cbc2.HeaderText = "CustomerID";
cbc2.DisplayStyle = DataGridViewComboBoxDisplayStyle.ComboBox;
cbc2.Width = 250;
dataGridView1.Columns.Add(cbc2);
Nadam se da ste svatili sta pokusavam.
Pozdravi
[Ovu poruku je menjao djblade dana 25.10.2006. u 12:14 GMT+1]
 |  |
 |
