Click here to Skip to main content
11,802,442 members (70,740 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: C# CrystalReports
I create a crystal report, which show data from two tables(MSAccess)....
When i run the form in my PC its good and show the records.. when i run it on other PC the Database Login dialog box appear.Its want LoginID and password but I don't give any password in the database... If I click finish button it shows Logon failed. Please Try again.
My C# code is -:
OleDbConnection con=new OleDbConnection("Provider=Microsoft.jet.oledb.4.0; data source="+Application.StartupPath+@"\DataInfo1.mdb;");           
           OleDbDataAdapter da=new OleDbDataAdapter("SELECT * FROM salesitemdetails WHERE bill_no in(SELECT bill_no FROM salesdetails WHERE custid in( SELECT custid FROM custdetails where custarea='"+ this.textBox1.Text.Trim() +"' order by custid))",con);
           DataSet ds = new DataSet();
           CrystalReport1 cr = new CrystalReport1();
           cr.SetDatabaseLogon("Admin", "");
            this.crystalReportViewer1.ReportSource = new CrystalReport1();

How to fix it ??

Every Help will be Appreciate....
Posted 3-Mar-13 0:30am

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

You can refer to this URL:
Sample code

Please use this connection string: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=;
Jayanta Chatterjee at 5-Mar-13 21:57pm
Sir,I want it in winform not ASP.NET..
jerrykid at 9-May-13 4:14am
Maybe the connection is missing, I updated the connection string, pls try it.
Jayanta Chatterjee at 9-May-13 9:04am
I try it but it doesn't worked ....
thanks for reply, I solved it with dataSet control....

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 445
1 KrunalRohit 366
2 F-ES Sitecore 295
3 Afzaal Ahmad Zeeshan 230
4 CPallini 230
0 OriginalGriff 2,950
1 Maciej Los 1,910
2 KrunalRohit 1,862
3 CPallini 1,645
4 Richard MacCutchan 1,157

Advertise | Privacy | Mobile
Web04 | 2.8.151002.1 | Last Updated 9 May 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100