vs2005 winfoms DataGridView DataGridViewColumn 数据绑定
来源:互联网 发布:云计算工程师的收入 编辑:程序博客网 时间:2024/03/29 05:50
private void SalesModelRalating(DataGridViewColumn cmb)
{
string strSql = "SELECT DISTINCT salesModel FROM Product WHERE proState='" + ProductVO.USE_STATE + "'";
string DBConnent = System.Configuration.ConfigurationSettings.AppSettings["connStr"];
SqlConnection DBconn = new SqlConnection(DBConnent);
try
{
if (DBconn.State == ConnectionState.Closed)
{
DBconn.Open();
}
SqlDataAdapter da = new SqlDataAdapter(strSql, DBconn);
DataSet ds = new DataSet();
da.Fill(ds, "Product");
DataTable dt = ds.Tables["Product"];
cmb.DataPropertyName = "salesModel";
//删除自动生成的 cmbSalesModel(业务型号) 列
this.dGVOrderProductTable.Columns.Remove("cmbSalesModel");
//为表创建列表列
DataGridViewComboBoxColumn Lists = new DataGridViewComboBoxColumn();
Lists.DisplayIndex = 1;
Lists.HeaderText = "业务型号";
//此列绑定至 salesModel 字段
Lists.DataPropertyName = "salesModel";
//列表从数据源获得数据
Lists.DataSource = dt;
Lists.ValueMember = "salesModel";
//添加该列
this.dGVOrderProductTable.Columns.Add(Lists);
}
catch (Exception ex)
{
MessageBox.Show("数据绑定异常:" + ex.Message);
}
finally
{
DBconn.Close();
}
}
{
string strSql = "SELECT DISTINCT salesModel FROM Product WHERE proState='" + ProductVO.USE_STATE + "'";
string DBConnent = System.Configuration.ConfigurationSettings.AppSettings["connStr"];
SqlConnection DBconn = new SqlConnection(DBConnent);
try
{
if (DBconn.State == ConnectionState.Closed)
{
DBconn.Open();
}
SqlDataAdapter da = new SqlDataAdapter(strSql, DBconn);
DataSet ds = new DataSet();
da.Fill(ds, "Product");
DataTable dt = ds.Tables["Product"];
cmb.DataPropertyName = "salesModel";
//删除自动生成的 cmbSalesModel(业务型号) 列
this.dGVOrderProductTable.Columns.Remove("cmbSalesModel");
//为表创建列表列
DataGridViewComboBoxColumn Lists = new DataGridViewComboBoxColumn();
Lists.DisplayIndex = 1;
Lists.HeaderText = "业务型号";
//此列绑定至 salesModel 字段
Lists.DataPropertyName = "salesModel";
//列表从数据源获得数据
Lists.DataSource = dt;
Lists.ValueMember = "salesModel";
//添加该列
this.dGVOrderProductTable.Columns.Add(Lists);
}
catch (Exception ex)
{
MessageBox.Show("数据绑定异常:" + ex.Message);
}
finally
{
DBconn.Close();
}
}
- vs2005 winfoms DataGridView DataGridViewColumn 数据绑定
- DataGridView消息与DataGridViewColumn消息
- datagridview数据绑定
- DataGridView控件绑定数据
- winform 绑定数据 dataGridView
- DataGridView数据绑定
- DataGridView基本数据绑定
- datagridview绑定数据用法
- datagridview 数据绑定方法
- DataGridView绑定数据
- dataGridView绑定数据
- dataGridView 绑定SQL数据
- Datagridview绑定dataset数据
- DataGridView数据的绑定
- 手动绑定数据到datagridview
- DataGridView绑定数据到textbox
- DataGridView动态的绑定数据
- DataGridView控件---绑定数据方法
- 汇编语言的符号、标号和变量符号
- 数据挖掘简介
- Oracle工作小結(20080901)
- web开发中文乱码问题总结
- AK922: 突破磁盘低级检测实现文件隐藏
- vs2005 winfoms DataGridView DataGridViewColumn 数据绑定
- 汉庭季琦:我用IT精神打造传统产业
- IceSword&Rootkit Unhooker驱动简析
- Windows Server 2008虚拟技术 -- 注意点
- 迎头赶上
- asp.net页面间传值
- portal
- ak922.sys分析
- 堆栈溢出技术从入门到高深(一)