public static bool PopulateCombo(ComboBox Combo, string ConnectionString, string TableName, string TextField, string ValueField, string DefaultValue)
        {
            Combo.DataSource = null;
            SqlConnection  myConnection = new SqlConnection (ConnectionString);

            string Query = "select * from " + TableName;
            Query = Query + " order by " + ValueField ;

            SqlDataAdapter myAdapter = new SqlDataAdapter (Query, myConnection);
            DataSet ds = new DataSet();
            myAdapter.Fill(ds, TableName);
            DataTable Dt = ds.Tables[TableName];

            if (Dt.Rows.Count == 0)
             {
                return false;
             }
            else
            {
              Combo.DataSource = Dt;
              Combo.DisplayMember = TextField;
              Combo.ValueMember = ValueField;
              Combo.SelectedValue = DefaultValue;

              return true;

            }

        }