Raysoft.Framework.BindingUtility.ComboBoxHelper

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

    }
}