I have a project where I need to requery the datatable that an ultracombo uses for its datasource.  When the datatable is requeried the columns change also, don't know if this makes a difference or not. After the datatable is requeried the form is pretty much dead (except for the ultracombo control).  I can click on the other controls I have on the form and nothing happens.  The code I use to do the requery follows:

 private void LoadSearchCombo(string f1, string where)

        {

            if (f1 == "Last Name")

            {

                sql = "SELECT RecordID,LastName,FirstName,StudentID FROM StudentData " + where + " ORDER BY LastName,FirstName ";

            }

            else if (f1 == "StudentID")

            {

                sql = "SELECT RecordID,StudentID,LastName,FirstName FROM StudentData " + where + " ORDER BY LastName,FirstName ";

            }

            else if (f1 == "Barcode")

            {

                sql = "SELECT RecordID,Barcode,LastName,FirstName,StudentID FROM StudentData " + where + " ORDER BY LastName,FirstName ";

            }

            dbCmd.CommandText = sql;

            dbCmd.Connection = dbConn;

            dbAdp = new OleDbDataAdapter(sql, dbConn);                   

            if (dtSearch != null)

            {                

                dtSearch.Dispose();

            }

            dtSearch = new DataTable();

            dbAdp.Fill(dtSearch);            

            if (!bstartup)

            {

                ucSearch.DataSource = null;

                ucSearch.Refresh();

                ucSearch.DataBind();

            }

            if (f1 == "Last Name")

            {

                ucSearch.DisplayMember = "LastName";

            }

            else

            {

                ucSearch.DisplayMember = f1;

            }

            ucSearch.ValueMember = "RecordID";

            ucSearch.DataSource = dtSearch;

            ucSearch.DataBind();

            ucSearch.Refresh();                                         

            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow row in ucSearch.Rows)

            {

                ucSearch.SelectedRow = row;

                break;

            }

        }

I have tried numerous combinations of DataBind() and Refresh(), but none have worked so far.

Any help would be appreciated.

Thanks,