Yakup BG

Yakup BG

  • NA
  • 68
  • 36.4k

Crystal Report problem using with dataset

Jul 2 2012 7:20 AM
I use VS.net 2010 and I want to  report with dataset?

Hi.. I use VS.net 2010 and I want to  report with dataset but following error message
breaking program. How do I resolve this?


file:///C:\Program Files\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\dotnet1\crdb_adoplus.dll'
 int firma_ID;

This my code
----
  CrystalReport2 sayfa = new CrystalReport2();
 
  sorgu = "select firma_ID from firma where firma_adi='" +comboBox1 .Text  + "'";
  cmd = new OleDbCommand(sorgu, baglan());

  dr = cmd.ExecuteReader(CommandBehavior.Default);
  dr.Read();
 
  firma_ID = Convert .ToInt32 ( dr[0]);

  //MessageBox.Show(firma_ID.ToString());

  // kemirgen sorgu
  sorgu ="select * from kemirgen where firma_ID="+firma_ID+ "  ";

  //MessageBox.Show(sorgu = "select * from kemirgen where firma_ID=" + firma_ID + " ");

  cmd2 = new OleDbCommand(sorgu, baglan());
  cmd2.ExecuteNonQuery();

 
  adptr = new OleDbDataAdapter(sorgu,baglan () );
 
  ds_rapor = new DataSet();
 
  adptr.Fill(ds_rapor,"kemirgen" );
 
  sayfa.SetDataSource(ds_rapor );

  crystalReportViewer1.ReportSource = sayfa;


Answers (1)