crystalreportviwer

Question

i want to get data from two tables for designing a crystal report...i made a sp by using inner join.but but i don't know how to write code in crystal report viewer page load....means not getting parameters in control...in c# sql 2005

Ravi Kumar · Answer

hi try the fallowing DataTable dt = new DataTable(); ReportDocument MedicalReport = new ReportDocument(); SqlDataAdapter da1 = new SqlDataAdapter(ProcedureName con); da1.SelectCommand.CommandType = CommandType.StoredProcedure; da1.SelectCommand.Parameters.AddWithValue(@SiteId ddlSite.SelectedValue); dt.Clear(); da1.Fill(dt); if (dt.Rows.Count > 0) { MedicalReport.Load(Server.MapPath(ReportName)); MedicalReport.SetDataSource(dt); CrystalReportViewer1.ReportSource = MedicalReport; CrystalReportViewer1.DataBind(); }