Raysoft.Framework.BindingUtility.ComboBoxHelper

来源：互联网发布：名侦探柯南黑衣人知乎编辑：程序博客网时间：2024/06/04 22:39

ComboBoxHelperusing System;using System.Collections.Generic;using System.Text;using System.Windows.Forms;using Raysoft.DBUtility;using System.Data;namespace Raysoft.Framework.BindingUtility{    public partial class ComboBoxHelper    {        /// <summary>        /// 绑定下拉列表        /// </summary>        /// <param name="sqlText">传入的SQL语句</param>        /// <param name="conn">数据库连接旁字串</param>        public void  BindingComboBox(ComboBox cb,string sqlText,string Disp , string Val)        {            try            {                cb.DataSource = SqlHelper.ExecuteDataSet(sqlText, null).Tables[0];//返数据表                cb.DisplayMember = Disp;                cb.ValueMember = Val;            }            catch (Exception tv_ex)            {                MessageBox.Show(tv_ex.Message);            }        }    }}

0 0