Crystal Report printing using button by where clause.

Bhavesh Vankar

in my practicle i want to print selected record by id or gr name but its not wokring report showing all records not seletcted where is mistakes kindly suggest me right code.

protected void btnPrint_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(@"Connection string");
con.Open();
SqlCommand cmd = new SqlCommand("Select * from student_details Where grno Like'" + TextBox1.Text + "' or name like'"+ studentname +"%'",con);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
sda.Fill(ds);
ReportDocument crReport = new ReportDocument();
crReport.Load(Server.MapPath("~/StudentsRecord.rpt"));
crReport.SetDataSource(ds.Tables["student_details"]);
CrystalReportViewer1.ReportSource = crReport;
crReport.ExportToHttpResponse(ExportFormatType.PortableDocFormat,Response, false, "Student Records");
con.Close();
}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta5y ago
Can you share what's not working?

Have you checked in SQL with your query you are using, is it giving you a filtered result, share some screenshot of your issue.

Edit:
Here is an example showing working with CR
https://www.c-sharpcorner.com/UploadFile/009464/how-to-use-crystal-report-in-Asp-Net-using-C-Sharp/
+1
Bhavesh Vankar5y ago
its not working can you explain me with demo code.
+1
Amit Gupta5y ago
You didn't set the table name and uses with the table name, either add the table name or remove it from the crReport
...
DataSet ds = new DataSet();
       sda.Fill(ds,"student_details");
  ...
+1