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?
I need to save font selected by user by Ctrl+MouseWheel in Winforms RichTextBox.
I tried override below but this does not remember font: in this method Font.Size property
seems to be always *initial* Font size when RichTextBox is created, *not* the font size set by ctrl+mouse wheel.
How to find the font size set by Ctrl+Mouse wheel ?
class MyRichTextBox : RichTextBox
protected override void OnMouseWheel(MouseEventArgs e)
Settings.Default.TextBoxFont = new SerializableFont(Font);
Hi at all,
i use a Dataview to show the Data from a xml File. I have the following code to read the xml file:
this.dataGridView1.DataMember = "Document"; // Document =Tag in the xml file
custDV = dsAuthors.Tables.DefaultView; // custDV = Dataview
this.dataGridView1.DataSource = custDV; // Display the data from the view
if i use the rowfilter i see not the rows thye have empty cells.
Dataview.Rowfilter = "City = 'Berlin'";
does anybody know how can i avoid this effect. Or how can i avoid to set empty cells in dataview?