水晶报表以编程方式绑定数据表或数据库 [英] Crystal report binding datatable or database programmatically

问题描述

void BindCrystal()
        {
            string query = "select * from executive.employesallary";
            DataTable dt;
            dt = sampurnit.DataTable(query);

            SAMARPANN.Admin.CrystalReport1 crypt = new CrystalReport1();
            crypt.SetDataSource(dt);


            ReportDocument cryRpt = new ReportDocument();
            cryRpt.Load(@"D:\Samarpann_mannu\SAMARPANN\SAMARPANN\Admin\CrystalReport1.rpt");
            crystalReportViewer1.ReportSource = crypt;
            crystalReportViewer1.Refresh();

        } 

通过类文件进行连接...
名为sampurnit.cs

Connection is done through a class file ...
named sampurnit.cs

public static DataTable DataTable(string query)
       {
               if (cn.State != ConnectionState.Open)
               {
                   cn.Open();
               }
               SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(query,cn);
               DataTable dt = new DataTable();
               da.Fill(dt);
               return dt;

       }

推荐答案

从这里开始:愚蠢的Crystal Reports指南，第一部分-Winforms [ ^ ]

CodeProject本身上有很多关于Crystal报表的文章.

Start from here: Idiot''s Guide to Crystal Reports, Part I - Winforms[^]

There are quite a few articles on crystal reports here at CodeProject itself. Please use the CPsearch if needed.

我认为这不是问题(您在错误的位置发布)，实际上您应该将其发布为 ^ ]或博客 [

I think it''s not a question(you posted in a wrong place), actually you should have posted this as a Tip/Trick[^] or Blog[^] in CP.

这篇关于水晶报表以编程方式绑定数据表或数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！