|
Hi everybody,
I am dabbling with Crystal reports at the moment using C# .NET 2005.
Is it possible to specify the database source at runtime?
My program dynamically creates databases at runtime and stores their location in the registry. Being able to change databases at runtime would be of massive use.
Anybody got any ideas?
Thanks
Jonathan Harker
|
|
|
|
|
If the databases have identical schema information it is fairly easy, you can loop through the Database.Tables collection and set the logon information using SetLogonInfo. If the schema is even slightly different it is PITA and I don't have the code in front of me to help.
Need a C# Consultant? I'm available.
Happiness in intelligent people is the rarest thing I know. -- Ernest Hemingway
|
|
|
|
|
Thanks for your quick response.
Unfortunately to complicate matters, the schemas in each table are quite different.
Jonathan Harker
|
|
|
|
|
Good luck! The documentation is sparse and can change between versions of Crystal, it can be done but the effort is not worth it. Instead set your reports to use a dataset data source and then use your application to bring the data together into an identical dataset and you will be able to use many different databases quite easily.
Need a C# Consultant? I'm available.
Happiness in intelligent people is the rarest thing I know. -- Ernest Hemingway
|
|
|
|
|
been experimenting with the code, come up with this so far
<br />
OleDbConnection Connection = new OleDbConnection(@"Provider=Microsoft.JET.OLEDB.4.0;data source=C:\My db.mdb;");<br />
<br />
OleDbDataAdapter adapter = new OleDbDataAdapter();<br />
<br />
DataSet ds = new DataSet();<br />
<br />
adapter.SelectCommand = new OleDbCommand("SELECT CampaignName FROM ACTIVITY", Connection);<br />
<br />
adapter.Fill(ds, "ACTIVITY");<br />
<br />
ReportDocument rd = new ReportDocument();<br />
rd.SetDataSource(ds);<br />
<br />
crystalReportViewer1.ReportSource = rd;<br />
throwing the following exception:
Invalid report file path
not exactly sure what im doing here. please advise.
Jonathan Harker
|
|
|
|
|
When you initially create the report and specify the database through the CR wizard select a file based copy of your dataset. Then at runtime use the SetDataSource method then immediately afterwards call the Refresh report method.
Need a C# Consultant? I'm available.
Happiness in intelligent people is the rarest thing I know. -- Ernest Hemingway
|
|
|
|
|
I have two projects that are within the same solutions. Both windows application projects.
I reference the .exe file inside my main project and now I want the referenced project to use the main projects app.config file. How can I do this?
Inside the second project (the one being referenced) I put inside it's app.config: <appsettings file="mainApp.exe.config">
I then compiled and copied the second projects compiled config file to the main projects directory, so that I can include it in the clickonce manifest.
I run the clickonce to install but when app runs it doesnt seem like it is seeing the main apps config file.
Any help would be appreciated.
Steve Welborn
Software Engineer
Inrange Consulting
|
|
|
|
|
I can't compile this code in visual studio I get an error.
Could somebody help me.
class Recurse
{
public void foo(int f)
{
Console.WriteLine("Handed "+f);
if (f < 0)
return;
if ( f % 2 == 0)
this.foo(f - 5);
else
this.foo(f + 1);
}
}
class What_Does_This_Code_Print
{
public void RunExercise()
{
Recurse recurser = new Recurse();
recurser.foo(10);
}
}
|
|
|
|
|
1) Place your code around code and pre tags so it looks nicer.
2) What error did you get?
3) Does it specify a line number?
Windows Calculator told me I will die at 28. 
|
|
|
|
|
4) When is your homework due?
|
|
|
|
|
Alex501,
When you make a post, make the subject of use not "i need help", we know that already. Also, post the error you get.
Regards,
Gareth.
|
|
|
|
|
Your code is fine. Perhaps you forget to include the System namespace?
Need a C# Consultant? I'm available.
Happiness in intelligent people is the rarest thing I know. -- Ernest Hemingway
|
|
|
|
|
Alex501 wrote: I need help with C#
Don't we all?!? That's why we're here 
Dave
|
|
|
|
|
sounds like a homework question to me.
Steve Welborn
Software Engineer
Inrange Consulting
|
|
|
|
|
Probably not as his code compiles fine
Dave
|
|
|
|
|
you sure? Tried concatenating a string and an int recently?
|
|
|
|
|
J4amieC wrote: Tried concatenating a string and an int recently?
Yes, when testing his code - I wouldn't have done it, but when writing to the console it compiles and works. Try the code below!
static void Main()
{
int i = 5;
string s = "Test";
Console.WriteLine(s + i);
Console.ReadKey();
}
Dave
|
|
|
|
|
Hi Alex501
can you tell me here error message also.
thanks
|
|
|
|
|
I've got a small C# .NET application that manages users and logons for my company's website (for use by the customer service department). Now, I need to extend this program to be able to point to the production or test databases (for Q.A. testers). My problem is that it is built on a pretty hefty set of DLLs (that serve as the Data Access layer for this and several other related projects) that pull connection string from the .config file.
This is probably bad design, but I couldn't figure out how else to do it. Anyway, now I'm desperately searching for some way to deploy the project with two EXEs and two app.config files.
ClickOnce can allow me to deploy multiple executables, but that (as far as I can tell) requires a second VS project and so i would need to maintain the exact same code in two different spots instead of one (YUCK!). Unfortunately I don't know anything about MSI installers to know if they can help me.
Any pointers would be appreciated (about how to fix my design, certainly, but more so how to get past this last hurdle... as a rewrite of my DAL would take far more time than I have). Thanks in advance.
KBTibbs
|
|
|
|
|
KBTibbs,
Why not just have a flag in your config file that says which connection string to get? I dont understand why you'd need another app just because you want to add another connection string to the config file.
Regards,
Gareth.
|
|
|
|
|
I can add as many connection strings as I want, naturally... but the DLL's don't know the context of their operation, so to access those additional connection strings every method would need to be passed either the connection string name, or some known value so it could choose the appropriate connection string. An overhaul of that much code would take more time than I have.
It was bad design, I get that... but often times as requirements grow we have to deal with poor decisions we're stuck with, yes?
|
|
|
|
|
I'm not sure about what you're trying to achieve here but how about creating a post-build or pre-build batch script which modifies the connection strings for you? Thus creating one install for production and one for test? After all ClickOnce doesn't package the files in anyway, just changes the extensions.
|
|
|
|
|
What I'm trying to achieve is two links under the application's Start Menu entry. One link opens the program connecting to the production database, the other link to the test database.
If there were some way I could do this with a single executable, I'd love to hear how.
But as I see it, two executables (of non-duplicated code) with two app.config files is the only way to do it.
|
|
|
|
|
Personally I use NSIS for writing installers but then you'd have the hassle of automatic updates etc. Perhaps WIX would be able to perform the updates? Not sure. I'll see what I can remember, there are some articles here which provide auto-update functionality for your program.
|
|
|
|
|
Automatic updates shouldn't be a problem... I don't foresee more development on this project, but even if there is, the old fashioned installation roll out is certainly acceptable (this is only for in-house use, and we're a pretty small shop).
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
