Re: string is not recognized - C# Discussion Boards

PIEBALDconsult23-Sep-09 12:23

23-Sep-09 12:23

In the format for a DateTime, the '/' doesn't mean '/', it means to use the date separator that's set in the operating system, which could be '-' (as it is on my system) or even '.'.

ISO 8601 specifies the use of '-'.

Control panel | Regional and Language Options | Regional Options | Customize | Date | Date separator

Re: string is not recognized

Ashfield23-Sep-09 8:56

Ashfield

23-Sep-09 8:56

You have alread had the correct answers, about using quotes or better still parameterised query, but you will not always get tomorrow - you add 1 to the day part only. What happens on the last day of the month (or year) - 31st December 2009 will become 1st December 2009 using your code.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Re: string is not recognized

DaveyM6923-Sep-09 9:07

DaveyM69

23-Sep-09 9:07

He's using the AddDays method so that's taken care of by the framework - so long as he doesn't try to add to DateTime.MaxValue he'll be OK.

Dave

Generic BackgroundWorker - My latest article!
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Why are you using VB6? Do you hate yourself? (Christian Graus)

Re: string is not recognized

PIEBALDconsult23-Sep-09 12:12

PIEBALDconsult

23-Sep-09 12:12

Only for the day; not for the month and year.

Re: string is not recognized

Luc Pattyn23-Sep-09 13:14

Luc Pattyn

23-Sep-09 13:14

right now DateTime.Now.AddDays(365+30+1).ToString() returns 25-Oct-2010 1:11:42 on my system.

Luc Pattyn

Local announcement (Antwerp region): Lange Wapper? Neen!

Re: string is not recognized

PIEBALDconsult23-Sep-09 17:55

PIEBALDconsult

23-Sep-09 17:55

The OP added a day when accessing the day, but not when accessing the month and year.

Re: string is not recognized

Luc Pattyn24-Sep-09 0:27

Luc Pattyn

24-Sep-09 0:27

You're right of course.
And he shouldn't use multiple DateTime.Now calls anyway, it may fail around midnight.

Smile | :)

Luc Pattyn

Local announcement (Antwerp region): Lange Wapper? Neen!

Re: string is not recognized

Ashfield23-Sep-09 21:04

Ashfield

23-Sep-09 21:04

But he is only adding to the day variable:

// assume today is 30 Sep 2009 (30/09/2009)
string day = (DateTime.Now.AddDays(1).Day.ToString());    // day = 1        
string month = (DateTime.Now.Month.ToString());           // month = 9 
string year = (DateTime.Now.Year.ToString());             // year = 2009
string date_nextDay = month + '/' + day + '/' + year;    // gives 9/1/2009

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Re: string is not recognized

DaveyM6924-Sep-09 0:00

DaveyM69

24-Sep-09 0:00

Ah... I saw the AddDays method and assumed that he would be using the returned DateTime instance so didn't look any more at the code.
Using three DateTime instances to create the string representations of a date's constituent parts is a WTF that I wasn't expecting!

Dave

Generic BackgroundWorker - My latest article!
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Why are you using VB6? Do you hate yourself? (Christian Graus)

Re: string is not recognized

Luc Pattyn24-Sep-09 0:29

Luc Pattyn

24-Sep-09 0:29

DaveyM69 wrote:
DateTime instances

WTF!

Luc Pattyn

Local announcement (Antwerp region): Lange Wapper? Neen!

Re: string is not recognized

Ashfield24-Sep-09 1:23

Ashfield

24-Sep-09 1:23

DaveyM69 wrote:
I saw the AddDays method and assumed that he would be using the returned DateTime instance

So did I the first time I read it - just because thats the simple way to get it right Smile | :)

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Re: string is not recognized

Rabia_Arif24-Sep-09 5:19

Rabia_Arif

24-Sep-09 5:19

Oh thankyou all 4 sharing your ideas.My problem is solved Smile | :)

thanks a lot

FileSystemWatcher and Window Service.

Escocia23-Sep-09 6:43

Escocia

23-Sep-09 6:43

First, sorry my poor English.

goal: Modify and print an excel file that is being stored in a directory that is being observed.

Trouble: File Sharing.

Explain:

I have created a Windows service.This service contain a FileSystemWatcher Object who has got an "Created" delegate.

Code Constructor Service

Fsw = new FileSystemWatcher();
          
            Fsw.Path = "c:\\DirListen";
            Fsw.Filter = "*.xls";
            Fsw.Created +=new FileSystemEventHandler(Fsw_Changed);

When the user save an excel file in "c:\\DirListen" the delegate is raised up and then I must modify the excel file and then print. The problem is that this file is being used by the SSOO (i Think) and I can't use it. I always get errors due to that delegate is raised up before the file has finished to save. I do not want to use timer objects, but with this problem... Please, any suggestion or solution?

Code Delegate

void  Fsw_Changed(object sender, FileSystemEventArgs e)
{
    try
    {
        Excel.Application oXL;
        Excel._Workbook oWB;
        Excel._Worksheet oSheet;
        oXL = new Excel.Application();
        oWB = oXL.Workbooks.Open(e.FullPath, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
        object opc = Type.Missing;
        oSheet = (Excel._Worksheet)oWB.Sheets.get_Item(2);
        oSheet.Activate();
        oSheet.Cells[1, 1] = "change";
        oSheet.Cells[2, 4] = "another change";
        oXL.Visible = true;
      	oSheet.PrintOut(1, 2, 1, false, "printer", true, false, Type.Missing);
        FileStream fs2 = null;
        StreamWriter sw2 = null;
       oWB.Close(false, e.FullPath, Type.Missing);
       
        oXL.Quit();
        foreach (Process p in Process.GetProcessesByName("EXCEL"))
        {
            p.Kill();
        }
    }
    catch (Exception ex)
    {
        FileStream fs = null;
        StreamWriter sw = null;
            fs = new FileStream("c:\\error.log", FileMode.CreateNew, FileAccess.Write);
            sw = new StreamWriter(fs);
            sw.WriteLine(ex.ToString());
    }
}

Many Many Thanks. Smile | :)

regards

Re: FileSystemWatcher and Window Service.

0x3c023-Sep-09 6:55

0x3c0

23-Sep-09 6:55

If I understand you correctly, you want to check if a file is in use. AFAIK, the .Net framework doesn't contain a class to do this. What about trying to open a file for exclusive read access, and catching the exception if it fails though?

File.Open(Path, FileMode.Open, FileAccess.ReadWrite, FileShare.None)

Source: here[^]

OSDev

Re: FileSystemWatcher and Window Service.

Luc Pattyn23-Sep-09 8:25

Luc Pattyn

23-Sep-09 8:25

Hi,

yes FileSystemWatcher events fire when something changes about a file, which does not mean the file is ready for consumption. When you write a large file, you would get a Created event, and several Changed events. There is no event telling you the file operations have finished.

This basically means you need a delay; I would opt for a Created event handler with a retry loop containing a delay (say Thread.Sleep(100)) and your file operation; the retry loop should try say 10 times, then give up.

Smile | :)

Luc Pattyn

Local announcement (Antwerp region): Lange Wapper? Neen!

Re: FileSystemWatcher and Window Service.

Escocia24-Sep-09 0:59

Escocia

24-Sep-09 0:59

Many thanks,

end, It works. I have two possibilities.

1º Adding a Timer Object with an Elapsed delegated: When the delegate "change" that belongs to the FileSystemWatcher object is raised up, then I add the "e.fullname" to a global ListArray of String and reset the timer. Then when the timer is elapsed I consult the ListArray Object and work with entries (Names of Excel files). No problems about File Shared. Then do a clean ListArray object. I have not chosen this option. Not optimal.

2º Using an Thread.Sleep (xxx). Much faster and easier. I did not think about it. Many Thanks Luc Pattyn. I have chosen this option.

Thanks and regards

Re: FileSystemWatcher and Window Service.

Luc Pattyn24-Sep-09 1:11

Luc Pattyn

24-Sep-09 1:11

you're welcome.

Smile | :)

Luc Pattyn

Local announcement (Antwerp region): Lange Wapper? Neen!

Data from Scanner to Database

Dambod23-Sep-09 6:40

Dambod

23-Sep-09 6:40

Hi there,
I am working on projects which requires scanning data from scanner, format data,store selected data from scanned one to database. Any one with idea?

thanks

Re: Data from Scanner to Database

Manas Bhardwaj23-Sep-09 6:51

Manas Bhardwaj

23-Sep-09 6:51

Dambod wrote:
Any one with idea?

What is the problem then?

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.

Re: Data from Scanner to Database

Dambod23-Sep-09 6:57

Dambod

23-Sep-09 6:57

Hi there,
I am working on projects which requires scanning data from scanner, format data,store selected data from scanned one to database. Any one with idea? I am looking for idea on how to read data from scanned one

Re: Data from Scanner to Database

Dave Kreskowiak23-Sep-09 9:31

Dave Kreskowiak

23-Sep-09 9:31

Repeating the same useless statement does not change the fact the you've asked a VERY general question that isn't really answerable. Without further detail, like what you mean by "data" and how this data is supposed to be formatted, it's pretty impossible to answer your question.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Re: Data from Scanner to Database

Henry Minute23-Sep-09 6:58

Henry Minute

23-Sep-09 6:58

Start by investigating the software that came with the scanner. Some of it can output into various formats e.g. Word, Excel etc. although I do not, personally, know of one that can do any DB formats.

If that is no joy then there are several 'form-reading' applications. Just google on open source form reader.

That should get you started. Smile | :)

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

Re: Data from Scanner to Database

Dambod23-Sep-09 7:17

Dambod

23-Sep-09 7:17

is that possible to
1. read data scanned based on some criteria,
2. put those data that meets the criteria to database?
3. if so, please some hint
thank u so much

Re: Data from Scanner to Database

Henry Minute23-Sep-09 8:31

Henry Minute

23-Sep-09 8:31

As I said in my previous post, there is software (known as OCR software) that can scan data into, for example, Excel. If you can get the data into Excel, then it is relatively easy to filter it from there into a database. AFAIK you cannot scan selectively, it's either all or nothing.

As I also said there is a class of application that deals with producing forms that are filled in and then scanned. I believe these applications can use a database.

I gave you a search term for Google, and I suggest that you use that search term, read through the hits that you get until you find something that sounds likely and proceed from there.

There are enough hints in my two posts to give you a start. Try them out.

Re: Data from Scanner to Database

cmk23-Sep-09 8:29

cmk

23-Sep-09 8:29

You could buy something like TeleForm[^].

You create a template form that has alignment markers on it.
The software looks for the markers in the scanned image and uses them to locate the input fields specified when the template was created.

...cmk

The idea that I can be presented with a problem, set out to logically solve it with the tools at hand, and wind up with a program that could not be legally used because someone else followed the same logical steps some years ago and filed for a patent on it is horrifying.
- John Carmack

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.