{

                       //分页打印

                       dg.AllowPaging = true;

                       dg.PagerStyle.Mode = PagerMode.NumericPages;

                       dg.PagerStyle.PageButtonCount = 10;

                       dg.PageSize = Convert.ToInt32(dtReport.Rows[i]["PageSize"].ToString());

                   }

                   DataSet ds = new DataSet();

                   //从Report.xml读取数据源信息

                   if(dtReport.Rows[i]["SQLdataConnection"].ToString() != String.Empty)

                   {

                       //数据提供者为SQL Server

                       SqlConnection Conn = new SqlConnection(dtReport.Rows[i]["SQLdataConnection"].ToString());

                       SqlDataAdapter myDataAdapt = new SqlDataAdapter(dtReport.Rows[i]["Sql"].ToString(),Conn);

                       myDataAdapt.Fill(ds,dtReport.Rows[i]["TableName"].ToString());

                   }

                   else if(dtReport.Rows[i]["OleDbConnection"].ToString() != String.Empty)

                   {

                       //数据提供者为OLE DB

                       OleDbConnection Conn = new OleDbConnection(dtReport.Rows[i]["OleDbConnection"].ToString());

                       OleDbDataAdapter myDataAdapt = new OleDbDataAdapter(dtReport.Rows[i]["Sql"].ToString(),Conn);

                       myDataAdapt.Fill(ds,dtReport.Rows[i]["TableName"].ToString());

上一页  [1] [2] [3] [4]  下一页