Update in access database

Question

Hi,

I am trying to update a column with the access databse it has been 2 hours now with no result I am writing different update queries and either I am getting syntax error in the update statement or they are updating my column but adding 0 in the place of the older value although that I am specifying a value, what's the problem how can I update a value with the access database using C#?

thanks.

Answer 1

@Sundar

 

If client donot want to view any console window to be viewed on the screen then you can go for windows form.

 

Because whenever a console application ran, it shows a black window which might distract the client.

 

For this, change your project output to 'Windows Application' instead of console application.

 

This will let it run on background (without UI).

 

Good Luck! 

Answer 2

Without console App or windows app, the system has to do automatically. I will set the time. Each day by that time, the mail should passed

Answer 3

Elaborate your word 'Machine learning' in this case.

Answer 4

Is there any possibility of implementing Machine Learning ? For this ?

Answer 5

Thank you salman

Answer 6

Here Console will never popup each time. It will run everything in background. This is the best way and as per my understanding there is no other way.

thanks. 

Answer 7

My question is, is there any other way ??? The console should not pop up for each time.

Answer 8

Already You Created Console app right. So just create a Schedular and which will run in background.

thanks. 

Answer 9

Actually I am using task Scheduler for this. I need a better way if any ??. Because, clients does not want to view the console popup at each interval of time. The operatoin should be done automaically in back end 

Answer 10

You can either use Task Scheduler and set your interval or create a windows service.

 

I recommend to use Task Scheduler for this