Just now I learned that, ADO.Net expressions do not support the "BETWEEN" keyword (it's showing an error as : Expression contains unsupported operator"BETWEEN").......so I just break it up into clauses with an "AND" as
"ADM_DATE > StartDate AND ADM_DATE < EndDate"
And when I'm using the above lines, its showing up the database connection popup, where it asks for Server Name, Database Type, LoginId, Password etc. That means that its still looking for the Crystal Reports datasource as DataSet's Table.
My previously working Crystal Reports datasource expression was like this :
It's been a while since I last used Crystal but if I remember correctly, try also to use SetDatabaseLogon method and after setting databases and datasources, use VerifyDatabase-method. This way you have full control over datasources and their logon information and you can catch any possible problems while executing VerifyDatabase.
I have an application which transfers file from one location to another specified by the path given by the user.Right now it overwrites the file if the same path and file name is given. But I want it to version the file and store it instead of overwriting it to have all the versions of the file transferred. I want to know the best way to do it in C#.
I would believe that this is purely a naming issue. For example keep all the files but vary the name like ..ver1, ...ver2 etc or place the older files in a different directory and separate different versions in history directory with a different name.
File system doesn't typically allow several files with the same name so this cannot be overridden using c#
Let's take an example. If your destination directory is named DirA and it already contains a file named AnyFile.txt. When you transfer a newer version of this file (for example by greater timestamp), what would you like the directory to contain?