Display related records from database using CrystalReportViewer by giving values in textbox.

</html>

WebForm1.aspx.cs code

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

using CrystalDecisions.CrystalReports.Engine;

namespace ReportViewer

{

public partial class WebForm1 : System.Web.UI.Page

{

string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

SqlDataAdapter sqlda = new SqlDataAdapter();

SqlCommand com = new SqlCommand();

DataTable dt;

DataSet1 ds = new DataSet1();

ReportDocument rptDoc = new ReportDocument();

protected void btn_display_Click(object sender, EventArgs e)

{

SqlConnection conn = new SqlConnection(connStr);

dt = new DataTable();

dt.TableName = "Crystal Report Example";

com.Connection = conn;

com.CommandText = "Select * from product where ProductName='" + TextBox1.Text + "'";

sqlda = new SqlDataAdapter(com);

sqlda.Fill(dt);

ds.Tables[0].Merge(dt);

rptDoc.Load(Server.MapPath("CrystalReport1.rpt"));

rptDoc.SetDataSource(ds);

CrystalReportViewer1.ReportSource = rptDoc;

}

}

}