GridView和DataGrid等轉水晶報表

protected void BtnToReport_Click(object sender, EventArgs e)

        {

            if (IsNullorEmpty(this.txtKey.Text.Trim()))

            {

                this.MsgForm("料號不能位空！請輸入料號進行列印！");

                return;

            }

            MyRpt.Init();

            DataSet ds_Main = BindData(this.txtKey.Text);//綁定GridView

            MyRpt.ReportID = "0001";

            MyRpt.ReportTitle = "料號倉庫查詢";

            MyRpt.ReportName = "wms_houselist_byitem.rpt";

            MyRpt.ReportDataSetMain = ds_Main;

            SC.MySqlBase.ReSetConnectionString();

            this.OpenPreview();

        }

private DataSet BindData(string keyword)

        {

                SqlParameter[] parm = new SqlParameter[1];

                parm[0] = new SqlParameter("@item", keyword);

                DataSet ds = MySqlBase.GetVarsAsDataSet("wms_warehouse_Byitem_qry", parm);

                this.GridView1.DataSource = ds;

                this.GridView1.DataBind();

                return ds;     

        }