المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : Datagridview ComboboxColumn Error: System.ArgumentException: The value of Datagridvie



C# Programming
04-02-2009, 06:41 PM
Hi to All,
I have a datagridview with some textbox and combobox columns. This shows some data from sql server.
It works fine bud when im trying to set the DataPropertyName of the combobox column, im getting the error:
System.ArgumentException: The value of DatagridviewComboboxCell is invalid

Here is a part of my code:
NpgsqlDataAdapter da = new NpgsqlDataAdapter(com);
DataTable dt = new DataTable();
BindingSource bs = new BindingSource();
da.Fill(dt);
bs.DataSource = dt;
if(dt.Rows.Count != 0)
{
qDesigner.dgvFilters.AutoGenerateColumns = false;
qDesigner.dgvFilters.DataSource = bs;
qDesigner.dgvFilters.Columns["dgvColTable"].DataPropertyName = dt.Columns[0].ColumnName;
//qDesigner.dgvFilters.Columns["dgvColColumn"].DataPropertyName = dt.Columns["Column"].ColumnName;
//qDesigner.dgvFilters.Columns["dgvColSort"].DataPropertyName = dt.Columns["Sort"].ColumnName;
qDesigner.dgvFilters.Columns["dgvColCriteria"].DataPropertyName = dt.Columns["Criteria"].ColumnName;
qDesigner.dgvFilters.Columns["dgvColOr1"].DataPropertyName = dt.Columns["ColOr1"].ColumnName;
qDesigner.dgvFilters.Columns["dgvColOr2"].DataPropertyName = dt.Columns["ColOr2"].ColumnName;
}

Can anyone help me with this issue?

Thanks