cn.Open(); SqlCommand cmd = new SqlCommand("empp", cn); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable ds = new DataTable(); da.Fill(ds); rdoc.Load(Server.MapPath("CrystalReport1.rpt")); rdoc.SetDataSource(ds); rdoc.SetParameterValue("conID", 3); CrystalReportViewer1.ReportSource = rdoc; CrystalReportViewer1.DataBind(); cn.Close();
<pre lang="SQL"> create PROCEDURE empp AS BEGIN SELECT * FROM Players END
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)