public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
rptnhanvien1990 rpt = new rptnhanvien1990();
rpt.Site = this.Site;
return(rpt);
}
private void crystalReportViewer1_Load(object sender, EventArgs e)
{
string constr = ConfigurationManager.ConnectionStrings["quanlythuvien"].ConnectionString;
using (SqlConnection cnn = new SqlConnection(constr))
{
SqlCommand cmd = cnn.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "pr_NhanVien1990";
//cmd.Parameters.AddWithValue("@nam", Convert.ToInt32(mtxt_nam.Text.ToString()));
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
rptnhanvien1990 rp = new rptnhanvien1990();
rp.SetDataSource(dt);
crystalReportViewer1.ReportSource = rp;
}
}
