问题描述
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
解决方案
推荐阅读