通用选择窗体

    public partial class SelectForm : Form
    {
        public string ReturnStr = "", ColumnValue = "", sql = "";
        int ColumnIndex;
        DataTable dt = null;
        /// 

        /// 
        /// 
        /// sql语句
        /// 返回值的列名
        public SelectForm(string sql, string ColumnValue)
        {
            this.ColumnValue = ColumnValue;
            this.sql = sql;
            InitializeComponent();
        }
        /// 

        /// 页面LOAD事件
        /// 
        /// 
        /// 
        private void SelectForm_Load(object sender, EventArgs e)
        {
            dataGrid.CellDoubleClick += dataGrid_CellDoubleClick;//单元格Cell双击事件
            DataBind();
        }
        /// 

        /// 数据绑定
        /// 
        private void DataBind()
        {
            dt = GetDataTable();//根据sql语句绑定数据库
            ColumnIndex = dt.Columns.IndexOf(ColumnValue);
            dataGrid.DataSource = dt;
        }
        /// 

        /// 根据sql语句，返回datatable
        /// 
        /// 
        private DataTable GetDataTable()
        {
            SqlConnectionStringBuilder sb = new SqlConnectionStringBuilder();
            sb.DataSource = "liurt-pc";
            sb.InitialCatalog = "mydb";
            sb.UserID = "sa";
            sb.Password = "qaz123";
            using (SqlConnection con = new SqlConnection(sb.ToString()))
            {
                SqlDataAdapter da = new SqlDataAdapter(sql, con);
                DataTable dt = new DataTable();
                da.Fill(dt);
                return dt;
            }
        }



        private void dataGrid_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.RowIndex > -1)
            {
                ReturnStr = dataGrid.Rows[e.RowIndex].Cells[ColumnIndex].Value.ToString();
                this.Close();
            }
        }

        private void txtValue_TextChanged(object sender, EventArgs e)
        {
            DataRow[] drs = dt.Select(ColumnValue + " like ‘%" + txtValue.Text + "%‘");
            if (drs.Length == 0)
            {
                dataGrid.DataSource = null;
            }
            else
            {
                dataGrid.DataSource = drs.CopyToDataTable();
            }
        }

        private void dataGrid_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
        {
            if (e.RowIndex % 2 != 0)
            { e.CellStyle.BackColor = Color.GreenYellow; } 
            else 
            { e.CellStyle.BackColor = Color.MintCream; }
        }

    }