Building a dynamic query and binding to DataGridView

  protected override void RunQuery()
    {
      long OldPONo = 0;
      string RecordCountLimit = string.Empty;
      
      if ( !( UserData.HasPermission( BPSPerm.BPS_Perm_UnLimitedDataSetSize ) ) )
        RecordCountLimit = " Top 1000 ";

      query = "select " + RecordCountLimit + " swo.*, ";
      query = query + " est_time_hr + (est_time_min / 60.0) as est_time, ";
      query = query + " m.machine_name from slitter_wo swo ";
      query = query + " left outer join slitter_machine m on swo.machine_no = m.machine_no ";

      if ( RAll.Checked )
      {
        query = query + " where swo.status <> 98776 ";
        if ( RCOne.Checked )
          query = query + " and swo.from_name like '" + EditCustName.Text + "%'";
        if ( !( COpen.Checked ) )
          query = query + " and swo.status <> " + BPSConst.WX_SWOStatus_Open;
        if ( !( CPr.Checked ) )
          query = query + " and swo.status <> " + BPSConst.WX_SWOStatus_Printed;
        if ( !( CComplete.Checked ) )
          query = query + " and swo.status <> " + BPSConst.WX_SWOStatus_Complete;
        if ( !( CInv.Checked ) )
          query = query + " and swo.status <> " + BPSConst.WX_SWOStatus_Invoiced;

        query = query + " and swo.date_entry >= '" + dateSelectionFrame1.GetDateStart() + "' ";
        query = query + " and swo.date_entry <= '" + dateSelectionFrame1.GetDateEnd() + "' ";

        if ( RMOnly.Checked )
          query = query + " and machine_name = " + cbMachine.Text;
      }
      else
        query = query + " where swo.swo_no = " + EditOne.Text;

      query = query + " order by swo.date_entry desc";

      DataSet ds = new DataSet();
      DataTable table = new DataTable("slitter_wo");
      ds.Tables.Add( table );
      SqlDataAdapter da = new SqlDataAdapter( query, BPSConst.ConnStringTest );
      da.Fill( ds );
      BindingSource bs = new BindingSource();
      bs.DataMember = "slitter_wo";
      bs.DataSource = ds;

      GridWO.DataSource = bs;
      
      SetRecordCount();

      PanelTop1000Only.Visible =((GridWOView.RowCount >= 1000) &&
                                 (RecordCountLimit != string.Empty));
      
      this.qMachineTA.Fill( this.sCDataSet.qMachine );

      FillWOInputGrid();
    }