|
Why would they want to transfer the data to Access 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
|
|
|
|
|
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
|
|
|
|
|
Why respond to my answer, respond to the original post
only two letters away from being an asset
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
Thank you again.
I will suggest them.
All the best.
|
|
|
|
|
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,
|
|
|
|
|
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????
|
|
|
|
|
DateTime _SystemTime = DateTime.Now;
If(_SystemTime != mytime)
{
}
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.
|
|
|
|
|
I assume "my date" is the date of installation. Just comparing the dates is not enough. What if one changes the system date?
जय हिंद
|
|
|
|
|
There's always the NTP[^] protocol to annoy cheaters - but that begs the question what happens to users without an internet connection
I are troll
|
|
|
|
|
|
ya mydate is my installation date.....so if anyone change system date then that will affect on project.How to handle this?
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
Do you really want to do that? My reaction to things like that is always to delete all traces of the program and warn my friends not to use it unless they can find a patch for it.
|
|
|
|
|
Hello Experts!!
When i am displaying datagridview,it displayed same records 2 times.I am using dataset to display records.i dont knw why it happens??
Help me!!!
|
|
|
|
|
Well, what have you done ? Have you verified the record does not appear twice in the dataset ? It's either in the data twice, or you've done something weird when you styled the control. Without any code, and a list of things you have tried, it's hard to help.
Christian Graus
Driven to the arms of OSX by Vista.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
|
|
|
|
|
all the records are displaying twice or any specific record is displaying....
If all the records are displaying then the problem is in your database...
check the where condition in the database....
Padmanabhan
|
|
|
|
|
Try clearing dataset.
CC26
|
|
|
|
|
Hi all,
I have a class that performs some actions and calculations. Lets call it: class Calc
I also have a win form class called: class winForm
I want to set a label Text property on the win form from the Calc class.
How can I do this?
Many thanks in advance
Kind regards,
The only programmers that are better C# programmers, are those who look like this -> |
Programm3r
My Blog: ^_^
|
|
|
|
|
The calc class needs a referene to the form, or, better yet, a delegate needs to be hooked up between the two classes, so that calc can fire an event inside the form.
Christian Graus
Driven to the arms of OSX by Vista.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
|
|
|
|
|
Christian Graus wrote: a delegate needs to be hooked up between the two classes,
A delegate just to set label text?
जय हिंद
|
|
|
|
|
A delegate is the only clean way to have communication between classes. Better that, a designated event, than passing reference to forms around and exposing text properties on labels.
Christian Graus
Driven to the arms of OSX by Vista.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
|
|
|
|
|
In this scenario, if Calc has only one instance thoughout and if that gets created in the form itself, then
a) would databinding the label text be enough?
b) still stick to delegates?
जय हिंद
|
|
|
|