Crystal report deployment connect to the mdf file

See more:

C#3.0

C#

CrystalReports

Hi All,

I have copied .mdf and .ldf files of database in bin/debug folder of my application and used the connection string as follows

Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\MyDatabase.mdf;Integrated Security=True;User Instance=True
where MyDatabase=database name
application runs fine but i am getting new error while running and after creating set up file.I copied .mdf file and .ldf file in set up project and also in bin/release folder and then total application runs fine but now i am getting error in crystal report asking for user name and passwords.

Please suggest me for the same.

Thanks in Advance.

My code is:

public void Refreshreport()
{
   //I've added the report file (BalanceCrystalReport.rpt)to my project, 
   //and create an instance of the file. 
   var report = new BalanceCrystalReport();

   foreach (ReportDocument doc in report.Subreports)
   {
           foreach (Table table in doc.Database.Tables)
                table.ApplyLogOnInfo(MyTableLogOnInfo);

           doc.SetDatabaseLogon("", "",".\\SQLEXPRESS", "MyDatabase");
   }
   crystalReportViewer.ReportSource = report;
}

public virtual TableLogOnInfo MyTableLogOnInfo
{
  get
  {
      if(myTableLogOnInfo == null)
      {
          myTableLogOnInfo = new TableLogOnInfo();

          myTableLogOnInfo.ConnectionInfo.ServerName = ".\\SQLEXPRESS";
          myTableLogOnInfo.ConnectionInfo.DatabaseName = "MyDatabase";
          myTableLogOnInfo.ConnectionInfo.UserID = "";
          myTableLogOnInfo.ConnectionInfo.Password = "";
          myTableLogOnInfo.ConnectionInfo.IntegratedSecurity = true;
      }
      return myTableLogOnInfo;
}