Re: How to transfer data without using dataset - C# Discussion Boards

Re: Urgent Mail Sending Problem [modified]

Nagy Vilmos19-Jun-09 3:22

Nagy Vilmos

19-Jun-09 3:22

You thank for help and yet leave the ip address. Interesting.

Panic, Chaos, Destruction.
My work here is done.

musefan19-Jun-09 3:24

musefan

19-Jun-09 3:24

The edit button is commonly overlooked by new CP members Wink | ;)

SEE THIS IS AN EDIT:

Now all he needs to do is edit his OP and remove IP Address: [REMOVED] so no one can see it...

Oops Laugh | :laugh:

Life goes very fast. Tomorrow, today is already yesterday.

modified on Friday, June 19, 2009 9:38 AM

EliottA19-Jun-09 3:38

EliottA

19-Jun-09 3:38

Why make it worse by highlighting the fact he left his mail server IP address, not that it's anything important or useful to the outside world, it can be resolved with a DNS request. But either way, why repeat it and take attention to his error?

Check out the CodeProject forum Guidelines[^]
The original soapbox 1.0 is back![^]

musefan19-Jun-09 3:40

musefan

19-Jun-09 3:40

I'm just playing with him, and if the error was not pointed out then how would he know not to do it in the future?

Life goes very fast. Tomorrow, today is already yesterday.

How to transfer data without using dataset

musefan19-Jun-09 2:39

musefan

19-Jun-09 2:39

dev sheoran wrote:
(It means there is no problem with code)

So why are you posting in a programming forum? Sounds like some setup on your server.

Anyway, thanks for the IP address. I'm sure I could have some fun with that Laugh | :laugh:

Life goes very fast. Tomorrow, today is already yesterday.

Ersan Ercek19-Jun-09 1:53

Ersan Ercek

19-Jun-09 1:53

Hi,

I just started to work for a retail company where I am supposed to handle large databases. I need to transfer data from AS400 to MS Access where I will use for reporting purposes.

When I use dataset I receive memory exception. Is it possible to transfer data directly without using dataset(means without using virtual memory).

Thanks in advance

Not Active19-Jun-09 2:10

Not Active

19-Jun-09 2:10

Why would they want to transfer the data to Access Dead | X|

Do they realize there are reporting solutions that will work without the transfer. Or at least use SQL Server, Express is free and coupled with SSRS it would be better than Access, IMHO

You could do it with a datareader, transfer one record at a time.

only two letters away from being an asset

SilimSayo19-Jun-09 2:16

SilimSayo

19-Jun-09 2:16

Access can be a very good reporting tool but the problem with many Access users is that they tend to want to import the data into access and then report on it. Instead, you should create linked tables in access and then create parameterised queries on which to base the reports. Doing so will ensure that only the data you're reporting on gets copied temporarily into access

Not Active19-Jun-09 2:35

Not Active

19-Jun-09 2:35

Why respond to my answer, respond to the original post D'Oh! | :doh:

only two letters away from being an asset

Ersan Ercek19-Jun-09 4:31

Ersan Ercek

19-Jun-09 4:31

Thank you both,

For sql Server Suggestion; No way, they would not consider purchasing it.

Access, I will create one table that has links to different tables, since the data I am going to use is huge for Access.

Not Active19-Jun-09 5:06

Not Active

19-Jun-09 5:06

SQL Server Express is FREE. Advanced includes SSRS also. You would be setting the company up with better tools and positioning them for better migration. The tools are FREE, only costs a little time to download and install. Rather than having individual copies of Access databases floating around it could be centralized. Better management, more accurate reporting.

IMHO

only two letters away from being an asset

EventLog logging with log4net

Ersan Ercek24-Jun-09 5:37

Ersan Ercek

24-Jun-09 5:37

Thank you again.

I will suggest them.

All the best.

Jammer19-Jun-09 1:08

Jammer

19-Jun-09 1:08

Hi All,

I've been poking around Google / Apache.org trying to get to the bottom of this with no luck. There isn't a lot of info anywhere on configuring log4net using pure C# so I thought I'd try here now.

I can log to the "Application" log with no problems. I can also create "MyLog" event log without problems as well, however, writing to "MyLog" fails to actually write an event log entry. The code I'm using to configure an EventLogAppener is:

public static void ConfigureEventLogAppender(string appName, string logName)
{
PatternLayout layout = GetDefaultLayout();
_eventLogAppender = new EventLogAppender();
_eventLogAppender.ApplicationName = appName;
_eventLogAppender.Layout = layout;
_eventLogAppender.LogName = logName;
_eventLogAppender.Threshold = Level.All;
_eventLogAppender.ActivateOptions();

BasicConfigurator.Configure(_eventLogAppender);
}

Has anyone managed to get this working?

Cheers,

Jammer
My Blog | Article(s)

Check system date when form load

KIDYA19-Jun-09 1:03

KIDYA

19-Jun-09 1:03

Hello Experts!!

i want to check system date and my date so i can avoid date mismatch.
when my date is greater than system date then it must give date mismatch error.
I am using it for checking my project expiry date......if anybody have another way then free to tell me.......
Is anybody have code for it????

Manas Bhardwaj19-Jun-09 1:10

Manas Bhardwaj

19-Jun-09 1:10

DateTime _SystemTime = DateTime.Now;
If(_SystemTime != mytime)
{
    //Do whatever you want
}

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

dan!sh 19-Jun-09 1:14

dan!sh

19-Jun-09 1:14

I assume "my date" is the date of installation. Just comparing the dates is not enough. What if one changes the system date?

जय हिंद

Eddy Vluggen19-Jun-09 1:19

Eddy Vluggen

19-Jun-09 1:19

There's always the NTP[^] protocol to annoy cheaters - but that begs the question what happens to users without an internet connection Smile | :)

I are troll Smile | :)

dan!sh 19-Jun-09 1:28

dan!sh

19-Jun-09 1:28

There are plenty of tools already written by someone somewhere. One can use them. Even MS has Software Licensing and Protection services[^]. There are more places like this[^] and this[^].

जय हिंद

KIDYA19-Jun-09 1:39

KIDYA

19-Jun-09 1:39

ya mydate is my installation date.....so if anyone change system date then that will affect on project.How to handle this?

harold aptroot19-Jun-09 2:45

harold aptroot

19-Jun-09 2:45

Don't bother, are you so greedy that you must even catch the people who go through big trouble to apply workaround that could mess up their system? Almost no one will change their system date, and the people who will aren't about to buy anything anyway. So avoiding wasting time on things like that is a bigger win.

PIEBALDconsult19-Jun-09 6:58

PIEBALDconsult

19-Jun-09 6:58

KIDYA wrote:
my installation date

If you're storing that somewhere I can probably change it, I don't even need to change the system time.