protected void Button1_Click(object sender, EventArgs e) { SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["DbConnection"].ConnectionString); ReportDocument test = new ReportDocument(); cn.Open(); SqlCommand cmd = new SqlCommand("SELECT_DATA", cn); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable ds = new DataTable(); cmd.Parameters.Add(new SqlParameter("@INPUT", TextBox1.Text)); da.Fill(ds); test.Load(Server.MapPath("EOR.rpt")); test.SetDataSource(ds); test.SetParameterValue("input", TextBox1.Text); CrystalReportViewer1.ReportSource = test; CrystalReportViewer1.DataBind(); cn.Close(); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)