c# datagridview中DataGridViewComboBoxColumn用法

最新推荐文章于 2024-04-26 09:48:04 发布

G鑫莹

最新推荐文章于 2024-04-26 09:48:04 发布

阅读量5.6k

点赞数 1

文章标签： c# 数据库开发语言

本文链接：https://blog.csdn.net/gong56/article/details/125848269

版权

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;        
        }