public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CRPNhanVien rpt = new CRPNhanVien();
rpt.Site = this.Site;
return(rpt);
}
private void TKDS_NV_Load(object sender, EventArgs e)
{
CryReport.CRPNhanVien cr = new CryReport.CRPNhanVien();
SqlConnection myConnection = new SqlConnection(@"Server = BADUY\SQLEXPRESS;database=banhang; user id = sa;password = 123456");
String sql = "Select * from NhanVien where MaNV = 1";
//String sql = "Select * from NhanVien";
DataSet Dataset1 = new DataSet();
SqlDataAdapter myDataAdapter = new SqlDataAdapter(sql, myConnection);
myDataAdapter.Fill(Dataset1, "NhanVien");
cr.SetDataSource(Dataset1.Tables["NhanVien"]);
crystalReportViewer1.ReportSource = cr;
crystalReportViewer1.Refresh();
crystalReportViewer1.Show();
}
