如题.谢谢各位!!!!!!!
what kind of 数组? if it is an object array, you could do something like
dropdownlist.DataSource = ObjArray;
dropdownlist.DataTextField = "Property1";
dropdownlist.DataValueField = "Property2";
dropdownlist.DataBind();
otherwise, you have to manually add them to the dropdownlist:
foreach (object o in YourArray)
dropdownlist.Items.Add(o.ToString());
DataGridComboBoxColumn dgdlbSP = new DataGridComboBoxColumn();
dgdlbSP.MappingName = "SP";
dgdlbSP.HeaderText = "商品";
dgdlbSP.ColumnComboBox.DataSource = _dsS.Tables[0];
dgdlbSP.ColumnComboBox.DisplayMember = "spmc";
dgdlbSP.ColumnComboBox.ValueMember = "spdm";
dgdlbSP.Width = 120;
dgdstDefault.GridColumnStyles.Add(dgdlbSP);
用一个datareader就可以把datagrid,dropdownlist都可以绑定好啊!
另外dropdownlist只能绑定datagrid中的一个列,否则就出错了,
datagrid完全可以绑定在datareader上,具体如下:
以下是用vc#.net 编写的。
oledbconnetion conn=oledbconnetion(userid= ;password= ;database= ;);
conn.open();
string sql="select * from tablename";
oledbcommand com=oledbcommand(sql,conn);
oledbdatareader dr=com.executereader();
while (dr.reader()){
dropdownlist.items.add(new itemlist(dr["cloumns"].tostirng());
***************
以下是datagrid绑定的
***************
datagrid.datasouce=dr;
datagrid.databand();
conn.close();
dr.close();
就可以了,sql和aesscess都可以的,