I'm loading a dgv with dates from a MySql table. Adding also works fine. No issues there, but when I try to change the date via the datagridview the following exception is thrown:
Quote:
System.FormatException: Invalid cast from 'System.String' to 'MySql.Data.Types.MySqlDateTime'. ---> System.InvalidCastException: Invalid cast from
[code].....
Im having a problem passing a date and time stamp from vb to mysql. My code is as follows:ComboBox1.Text.ToUpper() & "', '" & TextBox1.Text & "', '" & Now() & "'"Where the comboBox populates the first field, the textbox populates the second and in the third I get 0000-00-00 00:00:00. I have formatted the field as date and time - which is what I am after
View 8 RepliesI have a query from within my vb.net code which searchs for a record by date. The date being entered via the code is in format dd/mm/yyyy, i need to search in the database using yyyy/mm/dd? Ideally i thought there may just be a function within MySQL which will convert this. If not in vb.net to convert the string 01/01/2011 to 2011/01/01?
View 1 RepliesI need to check the state of a CheckBox in a DGV which I am attempting to do using the CellValueChanged Event. The problem I have is when the DGV is being loaded, the CellValueChanged Event is being run even though there is no data being loaded.
What can I do to stop this event being run, until the CheckBox value is changed.
The only code I have at present is to check the event is working:
[Code]...
Is there a query that can use to sum up data from date until another date? how to do it in VB.NET.
View 1 RepliesWhat i have going on, is i have a MySQL connector as a resource on my application, and im basically trying to connect to my MySQL server, to either a) register a new account, or b) check that the account exists and they are premium, and login, Now what i have run into problems with is: My MySQL Database Name has a _ in it which VB is not allowing for some strange reason.
The code i am using is below
Imports MySql.Data.MySqlClient
Public Class Form1
Function UpdateRecord(ByVal query As String) As Integer
[CODE]...
How i can allow the _ into the application, because the only databases that don't have a _ in the user or dbname are a) Paid ones which i DO NOT have the money for or self hosted ones, i cannot leave my computer on 24/7
I have been reading up on this, but I can't get it to work for me. I am reading in comma delimited text into a three-column datagridview control. The third column is a combo box which only accepts certian values. If the data being imported into col 3 is not in the combo box list I get an error that tells me to handle the data error event.trying to capture that error and get rid of the default error message box. I am working with a Try/Catch statement, but it doesn't seem do anything.
Do Until fileReader.EndOfStream
stringLine = fileReader.ReadLine()
If Not stringLine.StartsWith("'") And Trim(stringLine) <> "" Then
[code].....
I cannot Unresolve a post.I have a datagridview control with a combo box. The user loads data from a file into the control. If there are errors (the element in the combo box column is not in the combo box list) I would like to:
1. capture the row in which the error occurred, and store it in code/memory
2. change the cell backround to red (this is not that important)
3. continue without a message at the time of the error
4. post a message with all of the errors after the load is complete
I am using the code staight out of the Microsoft example to try to figure how to do this, but it is not posting any messages when I load bad data, so I am not getting any smarter from the example.[code]
I am using VB 2010 Express to create a windows forms application with an unbound DataGridView. The DataGridView has multible columns, two of which are ComboBox Columns. I would like to make the borders of the cells be bold when selected as some type of indication to which cell is the current cell. It is possible that I overlooked something completly but I could not seem to find a property that would allow this to happen.
My solution was to create a custom class which inherits from the appropriate DataGridViewCell type (e.g. DataGridViewTextBoxCell, etc..), in that class I override the Paint sub. There I check the selected property and draw a rectangle using the cell bounds.
This works with every type except the DataGridViewComboBoxCell. On the columns of this type I receive an ArgumentException on the call to the Paint Sub. Even if I just have an empty class that only inherits from the DataGridViewComboBoxCell.
Again, it is quite possible that I have overlooked somthing and am making the a lot more complicated than it needs to be.
Here's the info from my MySQL table.
fnd_date TYPE date
assign_date TYPE date
completion_date TYPE date
[code].....
I have been disturbed for a week now. I have a project in vb.net. And on forms I have two masked text boxes. One is for the user to enter their date of birth and in the second one Iam trying to get the date the record is created. With this one I get the current date from pc and format it to dd/mm/yyyy because I want the user to understand the date. How do I INSERT the user date of birth and the the Now () date which is also in masked text box into a MYSQL database? I know how to insert other text but the date fails to appear in database.
View 2 Replieswhy do i have errors in updating a column using where? this is my code "Update inventory Set isExpired='1' from inventory where expirationDate= '" & DateTimePicker1.Text & "'" my date format is yyy-MM-dd can anyone help me pls?
View 1 RepliesI'm trying to clear a DataTable and repopulate it, and the DataTable is bound to a DataGridView. Here's the code I'm executing:
vb.net
Using reader As MySqlDataReader = myCommand.ExecuteReader
SyncLock tableLock
running.Clear()
[Code]...
If you want to replace this standard messagebox, handle the DataError-expection
When debugging, there is no break in the code. The messagebox just pops up without showing me exaclty where the error is located.
below is the value for my date when it is saved. my problem is when i save the null value ..error says argument prompt cannot be converted to string..
[Code]...
I am trying to save a date to a mysql database and usually the only format permited to be saved in the table is YYYY-MM-DD
On the form the datetime picker is formated like this MM-DD-YYYY
The thing is i am using dataset created by wizard to save the data, what should i do to be able to format this for save and read because it is giving me errors.
i want to insert a string as date format in mysql table using vb.net.my code is given below.but i always get an error .the string is stored in an array.
mycode
------
Dim sdfsa As String = Convert.ToDateTime(newarray(i + 17)).ToShortDateString().ToString("yyyy-MM-dd")
Dim newdate As Date = DateTime.ParseExact(sdfsa, "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture)
datarw("date_of_birth") = newdate
I need this for displaying in my crystal report here's my
cmd.CommandText = "Select * from pos where date= '" & datetimepicker1.text"'"
and nothing displays on my crystal report, I need the right query for that...the field value is DATE...I need the conversion for the 1/11/2001 format from date time picker to 2001-1-11 in DATE field
I had try several type of date format and yet, I stil can't get it right. Below are the coding which had been writen
[Code]....
I have a LAN connection with my project and I need to display a running time and date of with labels anyone have an idea? Is it curdate and curtime?
View 9 RepliesI need this for displaying in my crystal report here's my
cmd.CommandText = "Select * from pos where date= '" & datetimepicker1.text"'"
and nothing displays on my crystal report, I need the right quert for that...
My DATE field always display with time in vb.net is there a select query to format it into yyyy-MM-dd?
View 3 Repliesi want to save the value of date time picker control object to mysql but it kept saying error.the code perfectly works for text box values but it doesn't work for date time picker control.
View 1 RepliesI'm having a problem with a MySQL query for returning the "last visit" field in a table.Originally I had:select fname, lname, last_visit from patient where isactive = 1 and uid = 1Which worked perfectly in MySQL, but as soon as the query is executed by my ASP.NET app, it adds in the time field also to the date area. So 2011-12-12 becomes 12/12/2011 12:00:00 AMI tried this also, with no improvement:
View 2 RepliesWhile I am running the following code
If rdrOnClick.Item("DOB") <> "" Then
dtpDOB.Value = rdrOnClick.Item("DOB"
End If
the error occur
Unable to convert MySQL date/time value to System.DateTime
how the various elements that help you handle errors work together. Have tried several options and can't make head nor tail of it. The underlying table has two columns, an autoincrement integer and a text column with the following settings:
[Code]...
I am using a DataGridView bound to a BindingSource which is itself bound to a List of objects. This all works well until I remove objects from the list. If I am scrolled down to the bottom of the DataGridView and then remove a bunch of items from the list it is bound to it generates a DataError exception because the length changed and the rows I am looking at no longer exist... I changed my code to handle that error, but now instead of popping up a message it SLOWLY erases the data in each of the newly invalid rows at the end of the table (I think each time it does one it generates a new DataError, which is why it is so slow).
How do I prevent this? I want to be able to dynamically (and programmatically) add and remove items from the table without the possibility of this error... I assumed this would be handled automatically as part of the data binding process but I guess not.
anyone knows the query of selecting from monthname and year(September 2011) from mysql database DATE format(yyyy-MM-dd)
View 1 RepliesI need this for displaying in my crystal report here's my code:
Code: cmd.CommandText = "Select * from pos where date= '" & datetimepicker1.text"'" and nothing displays on my crystal report, I need the right query for that...the field value is DATE...I need the conversion for the 1/11/2001 format from date time picker to 2001-1-11 in DATE field
This is my code for displaying data, but there's always the TIME on my date column
[Code]...
I have a datetime picker which format is yyyy-MM(2011-09) and I need to choose all the records of a particular month, I use this like query but doesn't display anything
[Code]...
