在Sql中将Crystal报表与视图相连 [英] Connect Crystal report with view in Sql

问题描述

亲爱的朋友



我在sql中创建了一个视图，现在我想在c＃GUI窗口应用程序中的crystal report中显示Join值。请帮帮我



谢谢

Dear Friends

I have create one view in sql and now I want to show that Join value in crystal report in c# GUI window application. please help me

Thanks

推荐答案

第1步：在项目中创建水晶报告。

第2步：为View编写选择查询。

step 1: Create crystal report in your project.
step 2: Write select query for View.

public DataTable selectallrecord()
       {   DataSet DS = new DataSet();
           string USER = "";
           USER = "SELECT * FROM StudentInfo";
           SqlDataAdapter DA = new SqlDataAdapter(USER, cn);
           DA.Fill(DS);
           DataTable DT = DS.Tables[0];
           return DT;

       }

步骤3：在按钮上单击事件绑定水晶报告。

step 3: On Button click event bind with crystal report.

private void button1_Click(object sender, EventArgs e)
       {
           DataTable dt = new DataTable();
           dt = selectallrecord();
           CrystalReport1 cr1 = new CrystalReport1();
           cr1.SetDataSource(dt);
           crystalReportViewer1.ReportSource = cr1;
       }

这篇关于在Sql中将Crystal报表与视图相连的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！