C # winform: ComboBox

 

Public static void SetComboList (ComboBox cboSource, string sSQL, string sWindowTxt, string sFirstItem = "", 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] =-1;

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;

}

 

1. Example of initializing the data source in the drop-down box:

 

String sSql = "select id, value from tgExpenditureItem ";

Common. SetComboList (cboOutputItem, sSql, this. Text );

 

Or

 

DataTable dtSource = new DataTable ();

DtSource. Columns. Add ("id ");

DtSource. Columns. Add ("value ");

DtSource. Rows. Add (1, "aa ");

DtSource. Rows. Add (2, "bb ");

DtSource. Rows. Add (3, "cc ");

 

Common. SetComboList (cboOutputItem, "", this. Text, "(all)", dtSource );

 

2. The value can be

 

CboOutputItem. SelectedIndex

CboOutputItem. SelectedItem. ToString ()

CboOutputItem. SelectedValue

 

3. For the SqlLiteHelper class, see:

 

Class for SqlLiteHelper. cs for sqlite Database: http://www.bkjia.com/kf/201111/111180.html

 

From the column keenweiwei