首页 > 解决方案 > 我想以 Crystal 视图 C# 窗口形式显示数据库中的行

问题描述

private void AllMemberReportForm_Load(object sender, EventArgs e)
{
     ReportDocument crypt = new ReportDocument();

     string AppPath = Application.StartupPath;
     string ReportPath = @"AllMemberReport.rpt";
     string ReportFullPath = Path.Combine(AppPath, ReportPath);

     MessageBox.Show(ReportFullPath);

     SqlConnection connection = new SqlConnection("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\\GymDatabase.mdf;Integrated Security=True;Connect Timeout=30");
     connection.Open();

     SqlDataAdapter dadptr = new SqlDataAdapter("select * from Member", connection); // Specifying SQL statement and Database connection  

     DataSet dset = new DataSet(); // creating instance of DataSet  
     dadptr.Fill(dset); // Filling DataSet  

     crypt.Load(ReportFullPath);
     crypt.SetDataSource(dset);

     crystalReportViewer1.ReportSource = crypt;

     connection.Close();
}

标签: c#visual-studiowinformscrystal-reports

解决方案


推荐阅读