4,818
社区成员
发帖
与我相关
我的任务
分享using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.IO;
namespace Report
{
public partial class ReportForm : Form
{
string conString = string.Empty;
FileStream fs = new FileStream(@"C:\ConnectString.txt",FileMode.Open,FileAccess.Read,FileShare.None);
StreamReader sr = new StreamReader(fs);
conString = sr.ReadLine();
SqlConnection conn = new SqlConnection(conString);
DataSet1 myData = new DataSet1();
SqlDataAdapter da;
public ReportForm()
{
InitializeComponent();
}
private void showReport()
{
da = new SqlDataAdapter("SELECT * FROM ReportTab", conn);
da.Fill(myData, "ReportTab");
//创建报表
CrystalReport1 cr = new CrystalReport1();
//设置报表的数据源
cr.SetDataSource(myData);
//设置报表视图的报表源
crystalReportViewer1.ReportSource = cr;
}
private void ReportForm_Load(object sender, EventArgs e)
{
//
showReport();
}
}
}