private void button1_Click(object sender, EventArgs e) { CrystalReport5 cr = new CrystalReport5(); cr.SetParameterValue("total", appointment); SqlConnection conn = new SqlConnection(); conn = DBConnection.getConnection(); string nic = textBox1.Text; conn.Open(); string sql = "select * from treat3 where nic='" + nic + "'"; DataSet ds = new DataSet(); SqlDataAdapter adapter = new SqlDataAdapter(sql, conn); adapter.Fill(ds, "treat3"); DataTable dt = ds.Tables["treat3"]; cr.SetDataSource(ds.Tables["treat3"]); crystalReportViewer1.ReportSource = cr; crystalReportViewer1.Refresh(); conn.Close(); }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { CrystalReport5 rpt = new CrystalReport5(); rpt.Site = this.Site; return(rpt); }