|
Somebody might know the answer to your problem instantly, but for the rest of us, could you post the section of code where the error occurs so that we can suggest alternative strategies.
[Edit]
Just found this!
Take a look at this[^], the relevant part is a fair way down so you'll probably be better off doing a search for mysqldatetime
[/Edit]
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.”
modified on Monday, August 24, 2009 8:49 AM
|
|
|
|
|
|
I have NO code in my application to handle the input of the date,
just the necessary to create the datasource for the datagridview.
I use a CalendarColumn to pick a date in the column...
When I pick a value for the cell, and I "get out" of the cell, a exception is thrown, and a dialog with the error is displayed:
"Invalid cast from System.String to MySql.Data.Types.MySqlDateTime".
The call Stack in the message says that the error is thrown in the method PushFormattedValue,
that I suppose that cannot be overloaded (or whatever...)
PS: Sorry for my english
|
|
|
|
|
ok, never mind...
i think i just solved my problem with this code:
If e.DesiredType.Equals(GetType(MySql.Data.Types.MySqlDateTime)) Then
If String.IsNullOrEmpty(e.Value) Then
e.Value = DBNull.Value
Else
Try
e.Value = New MySql.Data.Types.MySqlDateTime(DateTime.Parse(e.Value))
Catch
e.Value = DBNull.Value
End Try
End If
e.ParsingApplied = True
End If
in the method
Private Sub DataGridCusto_CellParsing(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellParsingEventArgs) Handles DataGridCusto.CellParsing
thanks
|
|
|
|
|
Best Of Regards,
SOFTDEV
Sad like books with torn pages, sad like unfinished stories ...
|
|
|
|
|
how to know a button from a other application is Enable for me press it automatic ?
|
|
|
|
|
Any attempt to do this will be buggy and error prone, but I'm sure there is a windows API for getting a window state. A button is a window
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
If both apps are .NET then you could try using reflection. Not going to be easy.
Steve Jowett
-------------------------
Real programmers don't comment their code. If it was hard to write, it should be hard to read.
|
|
|
|
|
hi again,
i have program in vb.net 2005 and i will generate a report in crystal report 10 which is already a package in visual studio 2005. i have a sort of problem in report footer.
why is it i can't view any data from report footer? i drag the field from database field in field explorer. but when i drag it to page header section or detail section data is there. is it possible to have data in report footer or not? because in msaccess report, i dont have the problem in viewing the data in report footer, it goes well.
C# コードMicrosoft End User
2000-2008
「「「「「「「「「「「「「「「「「「「「「「「「「「「「
The best things in life are free
」」」」」」」」」」」」」」」」」」」」」」」」」」」」
|
|
|
|
|
Follow the below steps, atleast will get a solution.
1. Open your crystal reports, from the tool bar -> crystal report ->Insert ->summary
Then From Top Select Your -> field from datatable
2. Calculate this summry as -> Mode
3. Don't change-> Grand Total ( Report Footer )
Now, when you click 'OK' you acn find that field will be in your "report footer" save and run the report, you will get your expectation.
|
|
|
|
|
Hello All,
I am trying to create Image at runtime(Like : Mspaint) using text Picture Line,Rectangle,Ovel . but i have generate some problem in Picturebox.
When i m Draging control over Picturebox then try to print or copy it. At this time Control does not display.
If you can think then I Can.
|
|
|
|
|
Your issue is that you are clueless. Nothing that you're doing stands any chance of working. Did you consider trying to do some research instead of just inventing a theory and going with it ?
Your form has a method which will paint it to an image. A picture box is for people who can't program to show images on their form, that is all. If you want to draw an image, you need the Graphics class. MSDN has all the details
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Got my 5!
|
|
|
|
|
and mine
Panic, Chaos, Destruction.
My work here is done.
|
|
|
|
|
Hi,
here are two bits of information for you:
1.
there are several relevant articles here on CodeProject (e.g. search for Paint.NET)
2.
I have a standard reply for such questions, here it goes (example code is C#, VB.NET would be similar):
there are several steps to correctly draw something; it does not matter how complex the paint job is: from a single line, to a complex drawing, or a real work of art.
To make sure it all becomes visible on the screen and gets repainted automatically when moving, resizing, minimizing/maximizing/restoring or uncovering your Form, one should follow these steps:
1.
decide upon what object you want to draw; it normally is a Control (e.g. a Panel) or a Form itself. I prefer to add a Panel to a Form, then draw on the Panel. And I do not like PictureBoxes, they are pretty useless.
2.
create some variables (Rectangle, struct, class, whatever) that hold the parameters of your drawing. For a rectangle that could be top and left coordinate, and width+height, or just a Rectangle. etc. For a complex drawing, it could be a List of objects that derive of a common type, each having its own PaintMe() method.
3.
create a Paint handler (either add your own paint handler to the Paint event, or override the OnPaint method) for that Panel, and do all your drawing in there, using the Graphics object inside the PaintEventArgs, and your variables. Do not call CreateGraphics!
4.
if and when you want to change things, modify the variables and call Panel.Invalidate() or one of its overloads (for selective invalidation).
5.
If you want to animate things, perform the move (step 4) inside the Tick handler of a Windows.Forms.Timer which ticks on the GUI thread, so you are allowed to call Invalidate() from there too.
BTW: if you need to create some objects (Fonts, Pens, Brushes, ...) either keep them
alive in class members (hence create them only once); or create them inside the Paint
handler and don't forget to call Dispose() on them.
C# example:
private Panel panel;
private bool paintRectFlag=true;
private Rectangle rect=new Rectangle(20, 20, 300, 200);
private Pen rectPen=Pens.Black;
public Form1() {
InitializeComponents();
panel=new Panel();
panel.Bounds=new Rectangle(…);
panel.Paint+=panelPaintHandler;
Controls.Add(panel);
}
protected void panelPaintHandler(object sender, PaintEventArgs e) {
Graphics g=e.Graphics;
if (paintRectFlag) g.DrawRectangle(rectPen, rect);
}
protected void buttonClickHandler(object sender, EventArgs e) {
paintRectFlag=!paintRectFlag;
panel.Invalidate();
}
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
hi,
i have lot of doubt in crystal report.
i have taken printout in 10*12 size paper.
how we can mention paper size in pragmatically ??
another one doubt i have taken printout for billing purpose.if we are going to take morethan one page, total amount is printing every page.
i dont need to print total amount in every page only last page.
plz help me very urgent
Yours,
KaNNaN
-----------------------------------------------------------------
"Success is When Ur Signature Becomes An Autograph"
Mail To : foreverkans@gmail.com
modified on Monday, August 24, 2009 3:06 AM
|
|
|
|
|
Hi,
I like to change the Startmode of a service in a Windows Forms application using Visual basic.
I tried the following code:
I do not get a error, but the StartMode does not change.
Try
Dim class1 As ManagementClass = New ManagementClass("Win32_Service")
For Each ob As ManagementObject In class1.GetInstances
If ob.GetPropertyValue("Caption").ToString = Me.cbservices.SelectedItem.ToString Then
If ob.GetPropertyValue("StartMode") = "Disabled" Then
ob.SetPropertyValue("StartMode", Me.cbStartMode.Text)
Exit Sub
End If
End If
Next
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try
Does anybody have an idea?
Thanks in advance for your help!!!!!
Dennis
|
|
|
|
|
Hi,
when getting info from WMI one tends to call ToString to show it;
in VB.NET this isn't even necessary, it will happen implicitly.
When setting info through WMI the type must be correct, StartMode isn't a string, it is a ServiceStartMode value.
Hence:
1. add a reference to System.ServiceProcess
2. do something like (not tested):
ServiceStartMode mode=ServiceStartMode.Parse(Me.cbStartMode.Text)
ob.SetPropertyValue("StartMode", mode)
alternatively add real ServiceStartMode values to the combobox, that would avoid the parsing.
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
Thanks.
I will try today and let you know the result.
Dennis
|
|
|
|
|
Thanks,
It workes like a charm.
Dennis
|
|
|
|
|
I am using VB6 Sp6 and Crystal Reports 8 in my application ,sql server 2000 in the backend. I am having a problem that if i execute a report i am having problem in the output once in a week but most of the time i am not getting any problems.If i again close and open the report output is correct.I am executing a view from my front end . if i check with query in the view, data is coming fine. In application, data are grouped together by using a Account Number in crystal reports.i am uanble to find any problem can you advice me on this. I need your help.
|
|
|
|
|
Why are you still using VB6 ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Just go to your crystal report report and to file menu there will be a check box that Save Data with report just remove check , problem will be solved
Best Of Regards,
SOFTDEV
Sad like books with torn pages, sad like unfinished stories ...
|
|
|
|
|
I’m working on a project that saves records to a datatable/dataset. I then serialize the dataset to save it, and deserialize to show the records in a datagridview, and I add more records, serialize, deserialize etc etc. – I’m using binary formatting. I added the dataset/datatable from the toolbox and selected “untyped” for the dataset.
I want to print out this table and other text.
Do I need to draw a report using graphics on to a page and then programmatically add the data from the deserialized file, or is there a better way to design and add data to a report? I’ve looked at crystal reports and report viewer and I cannot see how to programmatically add data using them – they both talk about connecting to a SQL or ADO database which mine isn’t.
Any help and/or any tutorials about this would be appreciated.
Regards,
Steve
Thanks for your help and advice!
Steve
|
|
|
|
|
First thing is to go get a hammer, now bash your left foot with it, the pain you feel is nothing to what you will feel if you decide to use Crystal Reports. There are a number of threads here discussing reporting tools, none recommend CR.
As you are not even using a database I assume your data requirements are minimal (serializing datasets will very quickly become useless if you have any real volume of data) so depending on the VS version there are report projects/forms you can add. Also there are grid printing articles on CP I believe .
Never underestimate the power of human stupidity
RAH
|
|
|
|
|