public void FillListbox(ListBox lBox, string Qry) { try { DataTable dt = GetDatatable(Qry); lBox.Items.Clear(); if (dt.Rows.Count > 0) { lBox.DataSource = dt; lBox.DataTextField = dt.Columns[1].ToString(); lBox.DataValueField = dt.Columns[0].ToString(); lBox.DataBind(); lBox.SelectedIndex = 0; } }catch (Exception ex) { throw ex; } }