Click here to Skip to main content
16,006,382 members

Comments by Member 10995532 (Top 1 by date)

Member 10995532 19-Aug-14 2:33am View    
Object reference not set to an instance of an object.
error is occuring when displaying crystal reoprt in asp.net
I wrote this below code
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["officeConnectionString"].ConnectionString);
SqlCommand cmd = new SqlCommand("SELECT * from course where Cousenm='" +TextBox1.Text+ "'", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet1 ds = new DataSet1();
da.Fill(ds);
con.Open();
cmd.ExecuteNonQuery();
con.Close();

ReportDocument ReportDoc = new ReportDocument();
ReportDoc.Load(Server.MapPath("CrystalReport.rpt"));
ReportDoc.SetDatabaseLogon(@"USER-PC\SQLEXPRESS", "office");
ReportDoc.SetDataSource(ds);
CrystalReportViewer1.ReportSource = ReportDoc;
ReportDoc.Close();
ReportDoc.Dispose();


please help me