If the SQL database has a password, the dialog box will pop up.

Hello, if the SQL database has a password, the dialog box will pop up. You can use the code to dynamically set the data source for the crystal report and use the following code to try it.
// Bind report data
Private void bindcrystalreports ()
{
String path1 = server. mappath ("~ \ Report \\");
String path2 = path1 + "reporder. rpt ";
ReportDocument repdoc = new reportdocument ();
Repdoc. Load (path2 );
Setdblogonforreport (repdoc); // set the data logon information
Crorder. reportsource = repdoc;
String selectionformula = "{htorder. htid} =" + txthtid. Text. Trim (); // sets the report data filtering formula.
Repdoc. datadefinition. recordselectionformula = selectformula;
Crorder. databind ();
}
// Set logon information
Private void setdblogonforreport (reportdocument)
{
Try
{
Connectioninfo = new connectioninfo ();
ConnectionInfo. ServerName = ConfigurationManager. etettings ["ServerName"];
ConnectionInfo. DatabaseName = ConfigurationManager. etettings ["DatabaseName"];
ConnectionInfo. UserID = ConfigurationManager. etettings ["UserID"];
ConnectionInfo. Password = ConfigurationManager. etettings ["Password"];
Tables tables = reportDocument. Database. Tables;
Foreach (CrystalDecisions. CrystalReports. Engine. Table table in tables)
{
TableLogOnInfo tableLogonInfo = table. LogOnInfo;
TableLogonInfo. ConnectionInfo = connectionInfo;
Table. ApplyLogOnInfo (tableLogonInfo );
}
}
Catch
{
LblNote. Text = "<script> alert ('the database logon information is incorrect! '); </Script> ";
}
}