[ djblade @ 25.10.2006. 11:03 ] @
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] |