DataTable p = new System.Data.DataTable(); p = selectcolor(); (dataGridView1.Columns[4] as DataGridViewComboBoxColumn).DataSource = p; private DataTable selectcolor() { DataTable k = new System.Data.DataTable(); try { string str = "Data Source=C:\\Documents and Settings\\almas\\Desktop\\BazarKhodro\\khodro.sdf"; Qconnection.ConnectionString = str; Qcommand.Connection = Qconnection; string commandText = "select color from foroosh"; Qcommand.CommandText = commandText; Qcommand.CommandType = CommandType.Text; SqlCeDataAdapter a = new SqlCeDataAdapter(); a.SelectCommand = Qcommand; a.Fill(k); Qconnection.Open(); Qconnection.Close(); return k; } catch (Exception ex) { throw new Exception(ex.Message); return k; } }
(dataGridView1.Columns[4] as DataGridViewComboBoxColumn).DataSource = p; dataGridView1.Columns[4].DisplayMember ="Name"; dataGridView1.Columns[4].ValueMember = "Id";
DataGridViewComboBoxColumn
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)