when i run crystal report in dataset exception occur.
FileLoadException was not Handled this error occur .
rpt.SetDataSource(ds); this line exception occur .
bellow is my source code.
so,plz give me solution
private void btn_rpt_Click(object sender, EventArgs e)
{
string str;
crystalReportViewer1.ReportSource = null;
if (txtname.Text == "")
{
MessageBox.Show("Please select name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtname.Focus();
return;
}
if (txtadd.Text == "")
{
MessageBox.Show("Please select address", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtadd.Focus();
return;
}
if (txtpno.Text == "")
{
MessageBox.Show("Please select phone number", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtpno.Focus();
return;
}
if (cmb_wrktyp.Text == "")
{
MessageBox.Show("Please select work type", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
cmb_wrktyp.Focus();
return;
}
try
{
Cursor = Cursors.WaitCursor;
Client rpt = new Client();
//crystalReportViewer1.ReportSource = null;
//rpt.SetDataSource(null);
//The report you created.
//rpt.SetDataSource(ds);
SqlConnection myConnection = new SqlConnection();
//SqlDataAdapter da = new SqlDataAdapter(cmd);
//DataSet myds = new DataSet();
//The DataSet you created.
//con = new SqlConnection(connectionString);
myConnection = Connectionclass.getConnection();
str = "SELECT * FROM ClientsDetails WHERE ClName = '" + txtname.Text + "' and ClAddress ='" + txtadd.Text + "' and ClWorkName ='" + cmb_wrktyp + "' ";
cmd = new SqlCommand(str, myConnection);
myConnection.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
//DataSet myds = new DataSet();
da.Fill(ds, "ClientsDetails");
cmd.ExecuteReader();
//cmd.ExecuteNonQuery();
myConnection.Close();
da.Dispose();
cmd.Dispose();
myConnection.Dispose();
rpt.SetDataSource(ds);
crystalReportViewer1.Visible = true;
//rpt.SetParameterValue("variable2", label2.Text);
crystalReportViewer1.ReportSource = rpt;
rpt.Load(@"C:\proj\Exacavator\Client.rpt");
crystalReportViewer1.Refresh();
rpt.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
con.Close();
}
}