创建DataAdapter对象填充数据

        //selectCMD.CommandType = CommandType.StoredProcedure;

        //   创建DataAdapter对象填充数据  
        DataSet ds = new DataSet();
        SqlDataAdapter adapter = new SqlDataAdapter(selectCMD);
        adapter.Fill(ds);

        //   将返回的数据和DataGrid绑定显示
        //int num = ds.Tables[0].Columns.Count;
        //sheet.ColumnCount = num + 10;
        //for (int i = 0; i < num; i++)
        //{
        //    int j = i + 6;
        //    this.FpSpread1.ActiveSheetView.Columns[j].DataField = ds.Tables[0].Columns[i].ColumnName;

        //}

        //this.FpSpread1.ActiveSheetView.Columns[2].DataField = ds.Tables[0].Columns[3].ColumnName;
        //FpSpread1.ActiveSheetView.DataMember = "Prj_RootInfo";