public static void SetComboList(ComboBox cboSource, string sSQL,string sWindowTxt,string sFirstItem="",int iFirstItemValue=-1,DataTable dtSource=null)
{
string sError = string.Empty;
DataTable dt=null;
if (!string.IsNullOrEmpty(sSQL))
{
dt = SqlLiteHelper.GetDataTable(out sError, sSQL);
if (!string.IsNullOrEmpty(sError))
Common.DisplayMsg(sWindowTxt, sError);
}
else if (dtSource != null)
{
dt = dtSource.Copy();
}
if (!string.IsNullOrEmpty(sFirstItem))
{
DataRow dr = dt.NewRow();
dr[0] = iFirstItemValue;
dr[1] = sFirstItem;
dt.Rows.InsertAt(dr, 0);
}
//cboSource.Items.Clear();
cboSource.DataSource = dt;
cboSource.ValueMember = dt.Columns[0].ColumnName;
cboSource.DisplayMember = dt.Columns[1].ColumnName;
cboSource.DropDownStyle = ComboBoxStyle.DropDownList;
}
调用方法:
private void InitOutputType()
{
string sSql = "select * from tgExpenditureItem";
Common.SetComboList(cboOutputItem, sSql, this.Text);
}