/// <summary>
/// ComboBox或DataGridViewComboBoxColumn绑定到数据源
/// </summary>
/// <param name="obj">要绑定数据源的控件</param>
/// <param name="strValueColumn">ValueMember属性要绑定的列名称</param>
/// <param name="strTextColumn">DisplayMember属性要绑定的列名称</param>
/// <param name="strSql">SQL查询语句</param>
/// <param name="strTable">数据表的名称</param>
public void BindComboBox(Object obj, string strValueColumn, string strTextColumn, string strSql, string strTable) //Component —替换—> Object
{
try
{
string strType = obj.GetType().ToString();
strType = strType.Substring(strType.LastIndexOf(".") + 1);
//判断控件的类型
switch (strType)
{
case "ComboBox":
ComboBox cbx = (ComboBox)obj;
cbx.BeginUpdate();
cbx.DataSource = db.GetDataSet(strSql, strTable).Tables[strTable];
cbx.DisplayMember = strTextColumn;
cbx.ValueMember = strValueColumn;
cbx.EndUpdate();
break;
case "DataGridViewComboBoxColumn":
DataGridViewComboBoxColumn dgvcbx = (DataGridViewComboBoxColumn)obj;
dgvcbx.DataSource = db.GetDataSet(strSql, strTable).Tables[strTable];
dgvcbx.DisplayMember = strTextColumn;
dgvcbx.ValueMember = strValueColumn;
break;
default:
break;
}
}
catch (Exception e)
{
throw e;
}
}