C# App - Changing Database location on runtime

[joey0714]

I have a Crystal Report that I need to change the database location during runtime. Does anyone know how to do this? I have tried different ways and they all have errors. Here is a copy of my code:

ConnectionInfo crConnectionInfo = new ConnectionInfo();
Tables crTables;
Table crTable;
TableLogOnInfo crTableLogOnInfo;

crConnectionInfo.ServerName = "ServeName";
crConnectionInfo.DatabaseName = "DatabaseName";
crConnectionInfo.UserID = "UserID";
crConnectionInfo.Password = "Password";

for (int i = 0; i < crTables.Count; i++)
{
crTable = crTables [i];
crTableLogOnInfo = crTable.LogOnInfo;
crTableLogOnInfo.ConnectionInfo = crConnectionInfo;
crTable.ApplyLogOnInfo(crTableLogOnInfo);

crTable.Location = "DatabaseName.xml" + crTable.Name;
}

[r035198x]

I have a Crystal Report that I need to change the database location during runtime. Does anyone know how to do this? I have tried different ways and they all have errors. Here is a copy of my code:

ConnectionInfo crConnectionInfo = new ConnectionInfo();
Tables crTables;
Table crTable;
TableLogOnInfo crTableLogOnInfo;

crConnectionInfo.ServerName = "ServeName";
crConnectionInfo.DatabaseName = "DatabaseName";
crConnectionInfo.UserID = "UserID";
crConnectionInfo.Password = "Password";

for (int i = 0; i < crTables.Count; i++)
{
crTable = crTables [i];
crTableLogOnInfo = crTable.LogOnInfo;
crTableLogOnInfo.ConnectionInfo = crConnectionInfo;
crTable.ApplyLogOnInfo(crTableLogOnInfo);

crTable.Location = "DatabaseName.xml" + crTable.Name;
}

When do you want to change the database location? Do you mean that you have two different databases and you want to switch from accessing one to accessing the other during runtime? Why not create a new connection then with connection settings for the second database?