WPF中使用DataGridView创建报表控件

转载

mob604756ef7d06 2011-11-24 11:39:00

文章标签 xml sql microsoft 数据控件 文章分类 C/C++ 后端开发

　　WPF中使用DataGridView创建报表控件

　　直入主题。报表数据是只作显示用的，直接用DataTable比生成ORM集合快，并且高灵活性。以后要修改报表，只要简单修改一下数据库中的视图。

　　但是WPF中的DataGrid对于数据稍多时，就会很慢。600行的数据显示要半分钟。通过断点查看，发现其实是DataTable绑定到DataGrid时耗时，数据返回到DataTable是很快的。看来要用以前的DataGridView了。用System.Windows.Forms.DataGridView修改后性能大大提高。600行的数据五，六秒。

　　报表控件的XAML

　　报表控件的C#(ReportControl.xaml.cs)

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;
using System.Data;
using System.Windows.Forms;

namespace WpfApplication1

{

    /// <summary>
    /// BaseReport.xaml 的交互逻辑
    /// </summary>
    public partial class ReportControl : System.Windows.Controls.UserControl

    {

        private System.Windows.Forms.DataGridView listDataGrid;

        public string ViewName { get; set; }
        public string ViewOrder { get; set; }
        public string SearchFieldName { get; set; }
        public string SearchFieldTitle { get; set; }

        public ReportControl()
        {
            InitializeComponent();
            listDataGrid = windowsFormsHost1.Child as System.Windows.Forms.DataGridView;

               this.SearchFieldTitle = "";
            this.DataContext = this;
        }


        private void Button_Click(object sender, RoutedEventArgs e)
        {
            string queryStr = "SELECT  * FROM [@TableName] Where @SearchFieldName like '%@SearchFieldValue%'  ORDER BY @ViewOrder";
            queryStr = queryStr.Replace("@TableName", ViewName);
            queryStr = queryStr.Replace("@ViewOrder", ViewOrder);
            queryStr = queryStr.Replace("@SearchFieldName", SearchFieldName);
            queryStr = queryStr.Replace("@SearchFieldValue", searchText.Text.Trim());
            listDataGrid.DataSource = DB.GetDataTable(queryStr);
        }
    }
}

DB辅助类

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;
namespace WpfApplication1
{
    public class DB
    {
        private static  string connectionStr = "";

        public static void InitConnectionStr(string conStr)
        {
            connectionStr = conStr;
        }

        public static SqlConnection  GetNewConnection()
        {
            return new SqlConnection(connectionStr);
        }

        public static DataTable GetDataTable(string selectCmdStr)
        {
            DataTable dt = new DataTable();
           SqlDataAdapter adapter=null;
            SqlConnection conn=null;
            try
            {
                conn=GetNewConnection();
                conn.Open();
                adapter = new SqlDataAdapter(selectCmdStr, conn);
                adapter.Fill(dt);
            }
            catch
            {
            }
            finally
            {
                if (conn != null)
                {
                    conn.Close();
                    conn.Dispose();
                }

                if (adapter != null)
                {
                    adapter.Dispose();
                }
            }

               return dt;

        }

    }

}

　　调用

　　1。初始化连接字符串。

　　DB.InitConnectionStr(@"Data Source=PC2011012718UQF\SQLEXPRESS;Initial Catalog=Northwind;Persist Security Info=True;User ID=dbReader;Password=888888");

　　2。在要用的XAML中使用ReportControl

        <my:ReportControl x:Name="reportControl1"
                          ViewName="Alphabetical list of products" ViewOrder="ProductID"
                          SearchFieldName="ProductName" SearchFieldTitle="Product Name:" />

    </Grid>
</Window>