|
Me again...I forgot to mention that I can connect to the database from source code with this connection string:
ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+AppPath+"; Jet OLEDB:Database Password=abc";
Is this a bug in .NET IDE?
Regards
|
|
|
|
|
Hi!
What's the value of AppPath? This should be the full path to the mdb-file, but if it's really only your application's path that'll be a problem...
Regards,
mav
|
|
|
|
|
Hi,
Yes, it is the full path to .mdb file.
I dont have any problems connecting to the database from source code (this works OK)...the problem is I can't do it from the designer (when you set the properties of the connection string of a OleDbConnection and when you press the "Test Connection" button).
Thanks
|
|
|
|
|
Hi all,
I was wondering if anyone could help me out in writing a gui in C#.
I just want to pop up a "Hello world" with a button and when I click on that button, there should come another pop up window "You are welcome to Csharp".
PLease help.
I appreciate that.
Thanks
Preeti9
|
|
|
|
|
MessageBox.Show("Hello world");
MessageBox.Show("Welcome to C#");
Of course, you need to import the System.Windows dll and be using System.Windows.Forms.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Many Many Thanks, I really appreciate that. So, its the same syntax that we use in C++.
Thanks
Preeti9
|
|
|
|
|
No, in C++, they are global API calls, MessageBox or AfxMessageBox. Here, there is nothing global, so everything that would be global is now a static method on a class. MessageBox is a class, and it has one static method, called Show.
But yeah, the net result is the same
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
ok....I got it.Thanks
So, we don't declare anything globally but we use a static method on a class....
Thanks again
Preeti9
|
|
|
|
|
Preeti9 wrote: So, we don't declare anything globally but we use a static method on a class....
Yes, we CAN'T declare true globals, because C++ allows OO, C# enforces it. So, a static member is the obvious way around that.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Thanks..Appreciate your help
Preeti9
|
|
|
|
|
Hi ,
Any reply is appriated.
Thanks.
|
|
|
|
|
I have been offered a job writing an image viewer for a web app. Now, I'm not sure yet, but I suspect they will want to be able to click a link in their web app, and have an image viewer come up on the client. Can I do this in C# ( set it up so that when I click a link, my app gets installed if need be, and then run using the image from the web, even though it's not associated with this image type ) ?
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Hi,
I am writting an application in C#.NET.This application will run daily once.
The application has to fetch the data from DB2. The volume may be 15 million records(each record will be having 120 fields). I will be processing that data and the resultent data will be sent to DB2(diff table). Will ".Net"(dataset) can handle that much volume of data?
Suppose the data is in some flat file(in some machine) is file handling functions are best way to use.
Please Suggest the best possible solution.
-- modified at 18:02 Thursday 20th October, 2005
|
|
|
|
|
The best possible solution, assuming you catch batch the data, is to use the ADO.NET stuff that's designed to talk to databases. Flat files on the machine are a terrible idea.
If it was me, I'd write the code to create a similar dataset, and stuff it with 20 million dummy records, to see what it does. However, if it was me, I'd never grab that many records anyhow, I'd make all operations on the data happen in the database, and my app would never retrieve more data than it needed to display on one page.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
HI Christian Graus,
Thanks for the info,
Here I had to get all that data. I am not displaying any data in my application(just for testing i am using datagrids)..I just have to process it and put the resultent data in DB2.
Thanks and Regards,
Subbu
|
|
|
|
|
Why do you need to process it all at once ? What's the process, that you can't do it within the database ?
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
dvsr wrote: Please Suggest the best possible solution.
15 million records might be a lot of records to process at once, its hard to tell without seeing the overall picture(there might be other compelling solutions). Even before looking for specific tech to use, see if you can do the processing in piecemeal and save the result and use it to work with the next batch. Though I think the previous suggestion of doing the processing on the DB side might be an issue if other apps are using it at the same time.
Quran
Translation
Intro
Discover
|
|
|
|
|
It's best to leave the processing in the database itself. Retrieving/Sending 30M records (you have to put them back ater the processing, correct?) will (usually) needlessly beat the crap out of the network your SQL server is attached to.
Part of the job of a developer is to evaluate your processes and code and consider their impact on the resources around them. What is this servers SQL load? What about it's NIC? What is the impact of adding 30M transactions to those loads? (I mean either from your processing application or from doing it inside the SQL database!) Will your retrieval, processing, and upload spike the use of these resources so bad that normal traffic is negatively impacted? How long will this processing take using each method? ...?, ...?, ...?, ...?
The .NET Framework dataset object can handle as much data as you can fit in memory. Millions of records is not out of the question. The real question is if it's practical. Only you can say.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
HI Dave,
Thanks for ur suggesition.
My Applications is something related to Airlines business. We expect atleast 15M records per day .... We r doing some statistical analysis on that data and the resultent set will be very small which we r going to send back to DB2.
BTW ..we r using DB2. ANyway I can rise the issues and discuss this suggesitions in my team meeting.
Thanks alot.
Subbu
|
|
|
|
|
How much data is it? If each field contain an average of 10 bytes, it comes to about 16 GB. Plus some overhead. I doubt that you have a machine with that amount of RAM...
Do you really need all the data at once in memory to process it?
If you need all the data at once, you probably have to copy the data into a temporary table, process it there, then read the result from it.
---
b { font-weight: normal; }
|
|
|
|
|
Hi All
I want write some method in c# with default parameters.
I try to do it like i did in C++ but the compiler does not let me.
How can i do it ?
Thanks .
|
|
|
|
|
Nope, VB.NET has this, and C# doesn't. Funny enough, I raised this at the MVP summit to the guys who design the language, and didn't get a flood of support.
The only way to do this is to write two methods, one that takes the extra parameter and one that does not. Make sure they both call the same underlying function.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Do it with overload method is not smart way.
The default parameters is the best way to do it.
|
|
|
|
|
yanshof wrote: The default parameters is the best way to do it.
I agree - if C# supported default parameters, it would indeed be the best way to do it.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
IS there is some way OR some mail that we [the develop user] can write [by mail] to microsoft ?
|
|
|
|