ASP.NET中应用XML技术实现Web报表打印

                   {

                       //分页打印

                       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]  下一页

Copyright ＠ 2007-2012 敏韬网(敏而好学，文韬武略--MinTao.Net)（学习笔记） Inc All Rights Reserved.
闵涛 E_mail:admin@mintao.net(欢迎提供学习资源)

鄂公网安备 42011102001154号

站长：MinTao ICP备案号：鄂ICP备11006601号-18