DataGridViewComboBoxColumn主要用来在datagridview中添加combox选项,其效果图如图,下面附代码
一、DataGridViewComboBoxColumn添加方法如图:
二、接下来是程序部分
//加载
private void Main_Load(object sender, EventArgs e)
{
InitDataGridView();
this.ComponentPackageComboxShow();
}
/// <summary>
/// combox显示数据
/// </summary>
private void ComponentPackageComboxShow()
{
DataSet data = stockInOp.GetComponentPackageShow();
DataGridViewComboBoxColumn combox = dataGridViewMain.Columns["ComponentPackage"] as DataGridViewComboBoxColumn;
DataTable datatable = data.Tables[0];
combox.DataSource = datatable;
combox.DisplayMember = "ComponentPackage";
combox.ValueMember = "Id";
//第一行显示空数据
DataRow newdr = datatable.NewRow();
datatable.Rows.InsertAt(newdr, 0);
}
/// <summary>
/// SQL获取数据
/// </summary>
/// <returns></returns>
public DataSet GetComponentPackageShow()
{
DataSet dst = new DataSet();
string sqlStr = string.Format("SELECT [Id], [ComponentPackage] FROM [SMS].[dbo].[SMS_ComponentPackage] order by ComponentPackage Asc");
try
{
using (IDataAccess ida = DataAccessFactory.getInstence())
{
ida.EnterQuery();
dst = ida.ExecuteDataset(sqlStr);
ida.LeaveQuery();
}
}
catch (Exception ex)
{
Logger.Error(string.Format("[数据库]关闭数据库连接异常:{0}{1}",
ex.Message.ToString(), ex.StackTrace.ToString()));
}
return dst;
}