How to write code to connect crystal report c# windows forms

See more:

C#

CrystalReports

, +

I need code for connect a crystal report to c# windows forms. I've tried many coding but its working on my pc, if i try to run in another pc it shows an error message "Failed to open the connection". I am a student and need to solve this issue to submit my project. Can anyone help me to solve this issue.



this is my coding part :

private void Preview_Click(object sender, EventArgs e)
{
SqlConnection cnn;
string connectionString = null;
string sql = null;

connectionString = @"Data Source=.\SQLEXPRESS;Initial Catalog=trydb_1;Integrated Security=True";
cnn = new SqlConnection(connectionString);
cnn.Open();
sql = "SELECT ID,pay_id,date,custname,description,chqno,duedate,accname,amount FROM payments";
SqlDataAdapter dscmd = new SqlDataAdapter(sql, cnn);
ReportDocument cryRpt = new ReportDocument();
cryRpt.Load(@"D:\Completing\WindowsFormsApplication1\payments11.rpt");
crystalReportViewer1.ReportSource = cryRpt;
crystalReportViewer1.Refresh();
}