datagridview组合框单元格 [英] datagridview combobox cell

问题描述

这可能是个老问题，但找不到答案...
我有一个DataGridView并在其中显示查询结果

表1:Field1，Field2，ID
表2:ID，LName，FName

DataSet ds从"SELECT Field1，Field2，LName&''''&FName中获取值作为Table1，Table2的名称WHERE Table1.ID = Table2.ID"
dGrid.DataSource = ds.Tables [0]

然后，我想使第3列成为组合框，并带有一个从Table2中选择值的选项

dGrid.Columns.Remove("Name");
DataGridViewComboBoxColumn cbc =新的DataGridViewComboBoxColumn();
DataSet ds1从"SELECT ID，LName和''''和FName作为Table2的名称获取"
cbc.DataPropertyName =名称";
cbc.DataSource = ds1.Tables [0];
cbc.ValueMember =名称";
cbc.DisplayMember =名称";
dGrid.Columns.Insert(2，cbc);

给我参数异常错误.不知道为什么.
有人有可行的例子吗?
谢谢

This is probably old question but can''t find an answer...
I have a DataGridView and display a query results in it

Table1: Field1, Field2, ID
Table2: ID, LName, FName

DataSet ds get values from "SELECT Field1, Field2, LName & '' '' & FName As Name FROM Table1, Table2 WHERE Table1.ID = Table2.ID"
dGrid.DataSource = ds.Tables[0]

Then I''d like to make 3rd column a combobox with an option to select values from Table2

dGrid.Columns.Remove("Name");
DataGridViewComboBoxColumn cbc = new DataGridViewComboBoxColumn();
DataSet ds1 get from "SELECT ID, LName & '' '' & FName As Name FROM Table2"
cbc.DataPropertyName = "Name";
cbc.DataSource = ds1.Tables[0];
cbc.ValueMember = "Name";
cbc.DisplayMember = "Name";
dGrid.Columns.Insert(2, cbc);

Gives me Argument Exception error. Not sure why.
Does anybody have a working example?
Thanks

推荐答案

尝试调试您的源代码并找出哪一行引发错误.

Try debugging your source code and figure out which line throws the error.

这篇关于datagridview组合框单元格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！