using
System;
using
System.Collections.Generic;
using
System.ComponentModel;
using
System.Data;
using
System.Drawing;
using
System.Text;
using
System.Windows.Forms;
using
System.Data.SqlClient;
namespace
测试FastReport
{
public
partial
class
Form1 : Form
{
private
DataSet data;
public
Form1()
{
InitializeComponent();
}
private
void
button1_Click(
object
sender, EventArgs e)
{
string
conStr =
"Server='127.0.0.1';Initial catalog=WaiMaoJinKou;UID='sa';PWD='12345';Max Pool Size=512;"
;
try
{
SqlConnection con =
new
SqlConnection(conStr);
con.Open();
SqlCommand sqlcmd =
new
SqlCommand();
sqlcmd.Connection = con;
sqlcmd.CommandText =
@"SELECT * FROM [Event] "
;
SqlDataAdapter sda =
new
SqlDataAdapter(sqlcmd);
data =
new
DataSet();
sda.Fill(data);
con.Close();
sda.Dispose();
}
catch
(Exception err)
{
MessageBox.Show(err.StackTrace);
}
try
{
FastReport.Report report =
new
FastReport.Report();
string
filename =
@"D:\qualityEvent.frx"
;
report.Load(filename);
report.RegisterData(data);
report.GetDataSource(data.Tables[0].TableName).Enabled =
true
;
report.Show();
}
catch
(Exception err)
{
MessageBox.Show(err.Message);
}
}
}
}