我在datagridview中有一个组合框,已成功将记录添加到db中并将组合框id(value成员)值存储到db中.我正在使用搜索按钮将已保存的值分配到datagridview中. 例如: 组合框列: 显示成员:A,B,C(Prod) 会员:1,2,3(ID) 表格:--- ID日期产品 2 7/26/2012 B 3 7/27/2012 C 2 7/27/2012 B 1 7/28/2012 A 从2012年7月26日到2012年7月27日搜索时,Datagridview显示3条记录: 我的Datagridview包含组合框-(产品),文本框(日期) 我在组合框中显示产品,在文本框中显示日期 产品日期 B 7/26/2012 C 7/27/2012 B 7/27/2012 任何人都请发送代码 在此先感谢 Sucharitha
Hi, I have a combobox in datagridview,successfully adding the record into db and storing the combobox id(value member)value into db.I am using search button to dispaly that saved values into datagridview. Ex: combo box column: display members: A,B,C(Prod) Value Memeber:1,2,3(ID) Table:--- ID Date Prod 2 7/26/2012 B 3 7/27/2012 C 2 7/27/2012 B 1 7/28/2012 A when search from 7/26/2012 to 7/27/2012, Datagridview display the 3 records: my Datagridview consists Combobox-(Products),textbox(Date) i am displaying the products in combobox and date in textbox Products Date B 7/26/2012 C 7/27/2012 B 7/27/2012 any one please send the code Thanks in advance Sucharitha
推荐答案查询数据库 Query the DB sql="Select uID,cUnit from tblUnit";
现在,在datagridview中添加一个组合列,并传递数据表
Now add a combo column in datagridview and pass datatable
public void AddColumnCombo(DataGridView Grid, string sCaption, DataTable dt, string sDisplayMember, string sValueMember) { DataGridViewComboBoxColumn GColumn = new DataGridViewComboBoxColumn { HeaderText = sCaption, DataSource = dt, DisplayMember = sDisplayMember, ValueMember = sValueMember }; Grid.Columns.Add(GColumn); }现在将值赋值以设置所需的数据,例如设置2以显示B
now asign the value to set required data for eg set 2 to display B
DataGridView[0,0].Value = Convert.ToString(datarow["UId"]) == "" ? null : (object)Convert.ToInt32(datarow["UId"]);
更多推荐
根据搜索将值分配到datagridview组合框列中
发布评论