C#

arkiboys wrote:

Note that I get the Same error when connecting to the sqlexpress instance using sql server management studio

Dewald wrote:

please let me know so I can start doing it differently

// Connected Environment
  SqlCommand cmd = new SqlCommand("Query",connetion);
  SqlDataReader dr = cmd.ExecuteReader();
  while (dr.Read())
          {
           comboBox1.Items.Add(dr[index].ToString());
          }

// Disconnected Environment
 SqlCommand cmd = new SqlCommand("Query",connetion);
    SqlDataAdapter da = new SqlDataAdapter(cmd);
    DataSet ds = new DataSet();
    da.Fill(ds,tablename);
    DataTable dt = ds.Tables[tablename];
    DataRow dr;
    int x = 0;
    while (x != dt.Rows.Count)
       {
         dr = dt.Rows[x];
         comboBox1.Items.Add(dr[index].ToString());//index may be 0,1 etc based on your condition
              x++;
       }

Dewald wrote:

Can anyone tell me of a way to make sure that the ComboBox is bound to the DB before I try to change the SelectedValue explicitly?

Dewald wrote:

At any rate, I can run through the SqlDataReader and add the entries one by one, that way I know when I've added all of them. I just don't like that approach all that much as it seems a bit brute.

try
{
    conn.Open();
    string sql = @"select Titles, TitleID from tblXXXXXXXX";
    OleDbDataAdapter adapter = new OleDbDataAdapter(sql, conn);
    OleDbCommandBuilder cmdb = new OleDbCommandBuilder(adapter);
    DataTable dt = new DataTable();
    adapter.Fill(dt);
    comboBox1.DataSource = dt;
    comboBox1.DisplayMember = "Titles";
    comboBox1.ValueMember = "Titles";
    this.BindingContext[dt, "Titles"].Position = 0;
}

John Simmons / outlaw programmer wrote:

Of course, you're assuming I wanted to avoid being rude, or that I wasn't matter-of-factly posing a reasonable question