Hi all,
This is urgrnt. I have created a crystal report when its running it doesn't appear i didn't get any errors even
This is the code of web config and my web form
Please can you say what is the mistake
Web Config
Web form Button Click
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString);
protected void Page_Load(object sender, EventArgs e)
{
lbl_CName.Text = Session["C_EmailAddress"] as String;
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
con.Open();
string sqlq = "SELECT * FROM Consultant_tb where C_EmailAddress='" + lbl_CName.Text + "'";
SqlDataAdapter myDA = new SqlDataAdapter(sqlq, con);
DataSet1 DS = new DataSet1();
myDA.Fill(DS, "Consultant_tb");
CrystalReport1 rpt = new CrystalReport1();
rpt.SetDataSource(DS);
CrystalReportViewer1.Visible = true;
CrystalReportViewer1.ReportSource = rpt;
CrystalReportViewer1.RefreshReport();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
con.Close();
}
Nilesh PatilPosted Dec 5, 2017, 3:39 AM
Kasuni AbegunawardanaPosted Dec 5, 2017, 4:33 AM
Kasuni AbegunawardanaPosted Dec 5, 2017, 3:15 AM
Nilesh PatilPosted Dec 5, 2017, 2:57 AM
Kasuni AbegunawardanaPosted Dec 5, 2017, 2:44 AM
Nilesh PatilPosted Dec 5, 2017, 2:23 AM