public void fnLoadListbox(ListBox cboGrid, string strQuery)
{
try
{
string s = ClsConnect.conSql.State.ToString();
if (s == "Open")
{
ClsConnect.conSql.Close();
}
ClsConnect.conSql.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
//cmd = ClsConnect.conSql.CreateCommand();
cmd.CommandText = strQuery;
dcId = new DataColumn("idField", typeof(int));
dcName = new DataColumn("nameField", typeof(string));
dt = new DataTable();
dt.Columns.Add(dcId);
dt.Columns.Add(dcName);
dr = cmd.ExecuteReader();
while (dr.Read())
{
DataRow rowData = dt.NewRow();
rowData["idField"] = dr[0];
rowData["nameField"] = dr[1];
dt.Rows.Add(rowData);
}
dr.Close();
cboGrid.DataSource = dt;
cboGrid.ValueMember = "idField";
cboGrid.DisplayMember = "nameField";
cboGrid.BringToFront();
cboGrid.Visible = true;
}
catch (Exception e)
{
MessageBox.Show(e.Message);
return;
}
finally
{
ClsConnect.conSql.Close();
}