Winform带dataGridview的Combox控件

最新推荐文章于 2024-08-21 10:21:00 发布
最新推荐文章于 2024-08-21 10:21:00 发布
阅读量2.3k 收藏 1
点赞数
文章标签： winform textbox string dropdown object null

Winform带dataGridview的Combox控件

(2009-02-17 16:57:46)
转载
标签：

combox

it

分类： Winform

如图所示：

Winform带dataGridview的Combox控件

调用控件：

public partial class Form1 : Form
    {
        public Form1()
        {

InitializeComponent();
           
            //---------------------------------------
            //设置dataWindow1属性
            this.dataWindow1.PopupGridAutoSize = false;
            this.dataWindow1.DropDownHeight = 300;
            this.dataWindow1.DropDownWidth = 340;
            this.dataWindow1.DataSource = GetDataTable();//DataTable 类型
            this.dataWindow1.RowFilterVisible = false;

this.dataWindow1.AfterSelector += new EventHandler(dataWindow1_AfterSelector);
        }
     
        //选择完下拉表格后执行的事件
        private void dataWindow1_AfterSelector(object sender, EventArgs e)
        {
            textBox1.Text = dataWindow1.GetDataProperty("username");
            textBox2.Text = dataWindow1.GetDataProperty("department");
            textBox3.Text = dataWindow1.GetDataProperty("postion");

}

 

重写ComboBox控件代码：

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Text;
using System.Windows.Forms;
using System.Drawing.Design;

namespace WindowsApplication21
{
    public class DataWindow : ComboBox
    {
        #region 成员变量
        private const int WM_LBUTTONDOWN = 0x201, WM_LBUTTONDBLCLK = 0x203;
        ToolStripControlHost dataGridViewHost;
        ToolStripControlHost textBoxHost;
        ToolStripDropDown dropDown;

private string m_sKeyWords = "";
        private string m_sDisplayMember = "";
        private string m_sValueMember = "";
        private string m_sDisplayField = "";
        private string m_Separator = "|";
        private string m_NullValue = "";


        private bool m_blDropShow = false;
        private bool m_blPopupAutoSize = false;
        private int m_SelectedIndex=-1;
        public event EventHandler AfterSelector;
       
        #endregion
        #region 构造函数
        public DataWindow()
        {
            DrawDataGridView();
        }
        #endregion
        #region 属性
        [Description("空值时的默认值"), Browsable(true), Category("N8")]
        public string NullValue
        {
            set
            {
                m_NullValue = value;
            }
            get
            {
                return m_NullValue;
            }
        }
        [Description("查询关键字"), Browsable(true), Category("N8")]
        public string sKeyWords
        {
            get
            {
                return m_sKeyWords;
            }
            set
            {
                m_sKeyWords = value;
            }
        }
        [Description("文本框显示字段用逗号分割！"), Browsable(true), Category("N8")]
        public string sDisplayMember
        {
            set
            {
                m_sDisplayMember = value;
              
            }
            get
            {
                return m_sDisplayMember;
            }
        }
        [Description("是否显示条件输入窗口！"), Browsable(true), Category("N8")]
        public bool RowFilterVisible
        {
            set
            {
                dropDown.Items[0].Visible = value;
            }
            get
            {
                return dropDown.Items[0].Visible;
            }
        }
        [Description("取值字段"), Browsable(true), Category("N8")]
        public string sValueMember
        {
            set
            {
                m_sValueMember = value;
            }
            get
            {
                return m_sValueMember;
            }
        }
        public DataView DataView
        {
            get
            {
                DataTable dataTable = GetDataTableFromDataSource();
                if (dataTable == null)
                {
                    return null;
                }
                return dataTable.DefaultView;
            }
        }
        [Description("设置DataGridView属性"), Browsable(true), Category("N8")]
        public DataGridView DataGridView
        {
            get
            {
                return dataGridViewHost.Control as DataGridView;
            }
        }
        public TextBox TextBox
        {
            get
            {
                return textBoxHost.Control as TextBox;
            }
        }
        [Description("下拉表格显示列，空为显示所有列！"), Browsable(true), Category("N8")]
        public string sDisplayField
        {
            set
            {
                m_sDisplayField = value;
            }
            get
            {
                return m_sDisplayField;
            }
        }
        [Description("数据源"), Browsable(true), Category("N8")]
        public new Object DataSource
        {
            set
            {
                if (m_sDisplayField != String.Empty)
                {
                   DataGridView.Columns.Clear();
                   DataGridView.AutoGenerateColumns=false;
                    string[] sDisplayFields = m_sDisplayField.Split(',');
                    foreach (string sDisplay in sDisplayFields)
                    {
                        DataGridViewTextBoxColumn dgvCell = new DataGridViewTextBoxColumn();
                        dgvCell.Name = sDisplay;
                        dgvCell.DataPropertyName = sDisplay;
                        DataGridView.Columns.Add(dgvCell);
                    }
                }
                 DataGridView.DataSource = value;
            }
            get
            {
                return DataGridView.DataSource;
            }
        }

[Description("下拉表格尺寸是否为自动"), Browsable(true), Category("N8")]
        public bool PopupGridAutoSize
        {
            set
            {
                m_blPopupAutoSize = value;
            }
            get
            {
                return m_blPopupAutoSize;
            }
        }
        [Description("分割符号"), Browsable(true), Category("N8")]
        public string SeparatorChar
        {
            set
            {
                m_Separator = value;
            }
            get
            {
                return m_Separator;
            }
        }
        [Browsable(false), Bindable(true)]
        public string Value
        {
            get
            {
                if (Text == String.Empty)
                {
                    m_SelectedIndex = -1;
                }
                if (!String.IsNullOrEmpty(m_sValueMember))
                {
                    if (DataView == null)
                    {
                        return Text;
                    }
                    if (m_SelectedIndex > -1)
                    {
                        object obj = DataView[m_SelectedIndex][m_sValueMember];
                        return obj.ToString();
                    }
                    else
                    {
                        return m_NullValue;
                    }
                }
                else
                {
                    return Text;
                }
            }
            set
            {
                int i = 0;
                if (m_sValueMember == String.Empty)
                {
                    Text = value;
                }
                else
                {
                    Text = "";
                    if (DataView != null)
                    {
                        DataView.RowFilter = "";
                        foreach (DataRowView dataRowView in DataView)
                        {
                            if (dataRowView[m_sValueMember].ToString() == value)
                            {
                                m_SelectedIndex = i;
                                string[] sDisplayList = m_sDisplayMember.Split(',');
                                foreach (string sDisplay in sDisplayList)
                                {
                                    if (DataGridView.Columns.Contains(sDisplay))
                                    {
                                        object obj = DataView[m_SelectedIndex][sDisplay];
                                        Text += obj.ToString() + m_Separator;
                                    }
                                }
                                Text = Text.TrimEnd('|');
                                break;
                            }
                            i++;
                        }
                    }
                }

}
        }
        #endregion
        #region 方法
        #region 绘制DataGridView以及下拉DataGridView
        private void DrawDataGridView()
        {
            DataGridView dataGridView = new DataGridView();
            dataGridView.BackgroundColor = SystemColors.ActiveCaptionText;
            dataGridView.BorderStyle = BorderStyle.None;
            dataGridView.ReadOnly = true;
            dataGridView.AllowUserToAddRows = false;
            dataGridView.RowHeadersVisible = false;
            dataGridView.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
           
            dataGridView.DoubleClick += new EventHandler(dataGridView_DoubleClick);
            dataGridView.KeyDown += new KeyEventHandler(dataGridView_KeyDown);

//设置DataGridView的数据源
            Form frmDataSource = new Form();
            frmDataSource.Controls.Add(dataGridView);
            frmDataSource.SuspendLayout();
            dataGridViewHost = new ToolStripControlHost(dataGridView);
            dataGridViewHost.AutoSize = m_blPopupAutoSize;

TextBox textBox = new TextBox();
            textBox.TextChanged+=new EventHandler(textBox_TextChanged);
            textBox.KeyDown+=new KeyEventHandler(textBox_KeyDown);
            textBoxHost = new ToolStripControlHost(textBox);
            textBoxHost.AutoSize =false ;

dropDown = new ToolStripDropDown();
            dropDown.Width = this.Width;
            dropDown.Items.Add(textBoxHost);
            dropDown.Items.Add(dataGridViewHost);
          
        }
        #endregion
        public string GetDataProperty(string sColumn)
        {
            string sValue = "";
            if (DataView != null)
            {
                if (DataGridView.Columns.Contains(sColumn))
                {
                    sValue = DataView[m_SelectedIndex][sColumn].ToString();
                }
            }
            return sValue;
        }
        public void dataGridView_DoubleClick(object sender, EventArgs e)
        {

PopupGridView(e);
        }
        /// <summary>
        /// 弹出下拉表格并触发选择后事件
        /// </summary>
        /// <param name="e"></param>
        private void PopupGridView(EventArgs e)
        {
            if (DataGridView.SelectedRows.Count > 0)
            {
                DataGridViewRow dgvRow = DataGridView.CurrentRow;
                m_SelectedIndex = DataGridView.CurrentRow.Index;
                if (m_sDisplayMember != String.Empty)
                {
                    Text = "";
                    string[] sDisplayList = m_sDisplayMember.Split(',');
                    foreach (string sDisplay in sDisplayList)
                    {
                        if (DataGridView.Columns.Contains(sDisplay))
                        {
                            Text += dgvRow.Cells[sDisplay].Value.ToString() + m_Separator;
                        }
                    }
                    Text = Text.TrimEnd('|');
                }
                else
                {
                    Text = dgvRow.Cells[0].Value.ToString();
                }
                if (AfterSelector != null)
                {
                    AfterSelector(this,e);
                }
            }
            dropDown.Close();
            m_blDropShow=false;
          
        }
        private DataTable GetDataTableFromDataSource()
        {
            object dataSource = DataGridView.DataSource;
            return GetDataTableFromDataSource(dataSource);
        }
        /// <summary>
        /// 从DataGridView 获取数据表
        /// </summary>
        /// <returns></returns>
        private DataTable GetDataTableFromDataSource(object dataSource)
        {
            if (dataSource is DataTable)
            {
                return (DataTable)dataSource;
            }
            else if (dataSource is DataView)
            {
                return ((DataView)dataSource).Table;
            }
            else if (dataSource is BindingSource)
            {
                object bind = ((BindingSource)dataSource).DataSource;
                if (bind is DataTable)
                {
                    return (DataTable)bind;
                }
                else
                {
                    return ((DataView)bind).Table;
                }
            }
            else
            {
                return null;
            }
        }
        private void ShowDropDown()
        {
            if (dropDown != null)
            {
                if (DataView != null)
                {
                    DataView.RowFilter = "";
                    TextBox.Text = "";
                    textBoxHost.Width = 200;
                    dataGridViewHost.AutoSize = m_blPopupAutoSize;
                    dataGridViewHost.Size = new Size(DropDownWidth - 2, DropDownHeight);
                    dropDown.Show(this, 0, this.Height);
                }
              
            }
        }
        private void dataGridView_KeyDown(object sender,KeyEventArgs e)
        {
            if (e.KeyData == Keys.Enter)
            {
                PopupGridView(e);
            }
        }
        #region 重写方法
    
        private string  GetRowFilterString(string sText)
        {
            string sFilter = "";
            if (m_sDisplayMember == String.Empty || m_sDisplayMember == null)
            {
                m_sDisplayMember = DataView.Table.Columns[0].ColumnName;
            }
            if (m_sKeyWords == String.Empty)
            {
                m_sKeyWords = m_sDisplayMember;
            }
            string[] sColumns = m_sKeyWords.Split(',');
            foreach (string sColumn in sColumns)
            {
                sFilter += sColumn + " like " + "'%" + sText + "%'"+" or ";
            }
            sFilter=sFilter.Trim().TrimEnd("or".ToCharArray());
            return sFilter;
        }
        private void textBox_TextChanged(object sender,System.EventArgs e)
        {
            DataView.RowFilter = GetRowFilterString(TextBox.Text);
        }
        private void textBox_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyData == Keys.Enter)
            {
                PopupGridView(e);
            }
        }
        protected override void OnKeyDown(KeyEventArgs e)
        {
            base.OnKeyDown(e);
            if (e.KeyData == Keys.Enter)
            {
                DataView.RowFilter = GetRowFilterString(Text);
                PopupGridView(null);
            }
        }
        protected override void WndProc(ref Message m)
        {
            if (m.Msg == WM_LBUTTONDBLCLK || m.Msg == WM_LBUTTONDOWN)
            {
                if (m_blDropShow)
                {
                    m_blDropShow = false;
                }
                else
                {
                    m_blDropShow = true;
                }
                if (m_blDropShow)
                {
                    ShowDropDown();
                }
                else
                {
                    dropDown.Close();
                }
                return;
            }
            base.WndProc(ref m);
        }
        protected override void Dispose(bool disposing)
        {
            if (disposing)
            {
                if (dropDown != null)
                {
                    dropDown.Dispose();
                    dropDown = null;
                }
            }
            base.Dispose(disposing);
        }
        #endregion
        #endregion
    }
}

ivanl
关注
在Visual Studio 2005的DataGridView控件中加入ComboBox下拉列表框的实现(C#)
雪尘的专栏
12-31 7362
 　　虽然在Visual Studio中 DataGridView控件的DataGridViewComboBoxColumn可以实现下拉列表框，但这样的列会在整列中都显示下拉列表框，不太美观，而且还要用代码实现数据绑定。本文介绍一种只在当前编辑单元格中显示下拉列表框的方法，供大家参考。　　首先新建一个Windows应用程序，将主窗体重命名为MainForm，在MainForm中加入一个Data
winform中datagridview新增combobox列绑定数据源
kuangshi2008的专栏
11-08 2005
winform我接触很少，最近想做这样一个功能：         给datagridview增加一列（出了数据源以外的列） 解决方法：         1.先给datagridview手动增加一列（右键datagridview）         2.datagridview绑定过DataTable数据源,此时combobox中我数据         3.循环datagridview每一行
DataGridView控件Combox列数据绑定
10-17
代码内包含了DataGrdiView控件如何创建Combox列，并给Combox列绑定数据源，以及数据源后台所对应的值
Winform中DataGridView网格添加ComboBox
最新发布
qq_41184334的博客
08-21 333
3 .编写DataGridView的CurrentCellChanged事件和ComBoBox的SelectedIndexChanged事件。1. 在窗体类中声明一个全局的变量ComBoBox，并在Form的Load事件中设置号ComBoBox的下拉选项。2 .在DataGridView绑定完数据源之后,将ComBoBox添加到DataGridView中。
Combox下拉绑定DataGridView
diemi9921的博客
06-22 397
这个Combox下拉很多人都在用但其中绘制的语句如下： #endregion #region 方法 #region 绘制DataGridView以及下拉DataGridView private void DrawDataGridView() { DataGridView...
DataGridView中的DataGridViewComboBoxColumn使用浅析
weixin_30546933的博客
04-10 775
小项目的感悟学习一下： 窗体的Load事件： private void Form1_Load(object sender, EventArgs e) { DataGridViewTextBoxColumn column = new DataGridViewTextBoxColumn(); column.Name = "ID"; ...
datagridview中使用combox
brian0031的专栏
09-13 753
private void Form1_Load(object sender, EventArgs e) {     sysdt2.Columns.Add("factory", System.Type.GetType("System.String"));     sysdt2
Winfrom中DataGridView的ComboBox功能实现（Gridview下拉框）
热门推荐
尽力而为
08-28 1万+
GirdView的下拉框实现略微繁琐，在此整理     也就是图中的最后一列。并且有显示文本DisplayText 以及实际值 Value 进行一一对应。和
winform Datagridview_combobox
xinfeiniao的专栏
11-27 489
public class DataGridViewComboEditBoxColumn : DataGridViewComboBoxColumn     {         public DataGridViewComboEditBoxColumn()         {             DataGridViewComboEditBoxCell obj = new DataGrid
C#中改变DataGridView控件边框颜色的方法
09-04
在C#编程中，`DataGridView`控件是一个用于显示数据表格的强大工具，广泛应用于各种桌面应用程序。默认情况下，它的边框颜色可能并不符合所有开发者或用户对于界面美观的要求。因此，有时我们需要自定义控件的外观，...
在Winform窗口中为DataGridview单元格添加ComboBox
m_buddy的博客
11-24 1万+
1. 前言 在进行软件开发时遇到需要在DataGridView控件的单元格中添加ComboBox的需求，经过网络博客等方式查找解决办法，最后成功解决，在本文中予以记录。 2. 实现 首先这里需要一个动态的ComboBox private ComboBox Score_ComboBox = new ComboBox(); 在窗体初始中设置它的基本属性和将其添加到DataGridView
c# winform datagridview 中嵌套的combobox实现级联选择
04-20
c# winform datagridview 中嵌套的combobox实现级联选择
datagridview中绑定combox,代码实现
03-08
datagridview中绑定combox,有代码 通过代码实现，向DataGridView中绑定combox.
【C#】完美实现ComBox多列下拉框+自动完成+DataGridView自定义列
06-07
灵活：数据源、下拉框内显示的列、列名、可搜索关键字等可自由定义 方便：可输可选/支持键盘操作/模糊过滤/自动完成匹配 标准：通过继承combobox实现，可单独使用，也可嵌入datagridview使用 水平有限，欢迎大家多提宝贵意见，共同学习 QQ：41357935 本控件以“随风飘散”在 http://www.cnblogs.com/CodeAnyWhere/archive/2007/09/03/880780.html中的示例代码为基础改进而来，在此感谢！.
C# WinForm (DataGridViewComboBoxColumn 绑定)自己写的，最简单实例
04-06
C# WinForm DataGridViewComboBoxColumn 绑定 自己写的，最简单实例
dataGridView动态绑定数据下拉框
11-18
dataGridView读取文件列名和数据库字段名称，文件列名作为原始列（固定的），数据库字段列（动态下拉框）。一个设定关系导入功能
vb.net中datagridview控件列添加DataGridViewComboboxColumn编辑选中方案
11-28
在VB.NET编程环境中，`DataGridView`控件是用于展示数据表格的强大工具，而`ComboBox`控件则提供了下拉选择的功能。将`ComboBox`与`DataGridView`结合使用，可以为表格中的某一列提供下拉选项，使用户在编辑时能够从...
实现datagridview与数据库的绑定 并添加comboxcolumn和checkboxcolumn
09-05
在.NET框架中，`DataGridView`控件是Windows Forms应用程序中常用的数据展示工具，它能够方便地展示和操作数据。在本教程中，我们将探讨如何实现`DataGridView`与数据库的绑定，以及如何在其中添加`ComboBoxColumn`...
c# datagridview中DataGridViewComboBoxColumn用法
gong56的博客
07-18 6191
DataGridViewComboBoxColumn用法
C# WinForm开发中DataGridView控件操作技巧总结
"这篇内容主要介绍了在C# WinForm开发中使用DataGridView控件的各种操作，包括单元格的操作、属性设置等。通过示例代码展示了如何获取当前选中的单元格的值、列索引和行索引，以及如何实现单元格的导航功能。" 在...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值