Mask Edit Box

[Chill3002]

I have a few Mask Edit Boxes in my program with a mask if ##/##/####. I had the column that the msktxtb was binding to set to nvarchar data type but kept receiving error:

String was not recognized as a valid datetime. Couldn't store < / /> in Column. Column is not DateTime data type.

I change the appropriate columns data types to datetime datatypes and now I am receiving this error:

The conversion of a char data type to a datetime data type resulted in an out of range datetime value.


Also my msktxtb do not recongize a single digit date for the day.

Example:

If I input 11/09/2012 into the msktxtb when the cursor moves from the msktxtb date shows as 11/92/012


How do I get the msktxt to recongize the date as 11/09/2012? What is the appropriate data type for ##/##/####?

[detlion1643]

Am I the only one who hasn't heard of a mask edit box? Are you talking about a textbox with masked input? A textbox with restricted input to only the ##/##/#### format? What's the column you speak of, part of a datagridview, sql, access?

[Chill3002]

In the toolbox in vs 2005 its called MaskedTextbox. Yes a textbox restricted to format ##/##/####. Sql Server and the column is also in the datagridview.

[detlion1643]

There is just a 'date' datatype in sql (not sure of datagridview). I've never worked with a masked textbox, so I'm not sure what's going on there. What's the code like where you take your masked textbox text and insert it into sql/datagridview. Maybe something is happening there we can fix?

Edit: Are you converting your textbox text into a valid date/datetime before using it?

[Chill3002]

Heres my code for inserting into SQL

u.ExecuteSQL(SqlConn, "INSERT INTO tblRepair (CustomerID, TrackNo, PONo, POLine, SupplierInDate, QtyRecieved, EstRepairPrice, ScheduledShipDate, RescheduledShipDate, PartDescript, PartNo, NewPartNo, TotalScrap, NewSerialNo, SerialNo, ScrapReason, Status, Comments, HAType, QtyShipped, QtyShipScrap, QtyShipReplace, SupplierOutDate, ShipperOut, ABW, FlightNo, DeliveryNo, InvoiceNo, InvoiceDate, InvoiceDueDate, InvoiceAmt) Values ('" & Me.txtbCustID.Text & "', '" & Me.txtbTrackNo.Text & "', '" & Me.txtbPONo.Text & "', '" & Me.txtbPOItem.Text & "', '" & Me.mskSupInDate.Text & "', '" & Me.txtbQtyRec.Text & "', '" & Me.txtbRepairPrice.Text & "', '" & Me.mskSchedShipDate.Text & "', '" & Me.mskReschedShipDate.Text & "', '" & Me.txtbPartDes.Text & "', '" & Me.txtbPartNo.Text & "', '" & Me.txtbNewPartNo.Text & "', '" & Me.txtbTotalScrap.Text & "', '" & Me.txtbNewSerial.Text & "', '" & Me.txtbSerialNo.Text & "', '" & Me.txtbScrapReason.Text & "', '" & Me.txtbStatus.Text & "', '" & Me.txtbComments.Text & "', '" & Me.txtbHAType.Text & "', '" & Me.txtbQtyShipped.Text & "', '" & Me.txtbQtyScrapShip.Text & "', '" & Me.txtbQtyReplacedShip.Text & "', '" & Me.mskSupOutDate.Text & "', '" & Me.txtbShipperOut.Text & "', '" & Me.txtbAWB.Text & "', '" & Me.txtbFlightNo.Text & "', '" & Me.txtbDeliveryNo.Text & "', '" & Me.txtbInvoiceNo.Text & "', '" & Me.mskInvoiceDate.Text & "', '" & Me.mskInvoiceDueDate.Text & "', '" & Me.txtbInvoiceAmt.Text & "')")

I dont have any code in place for converting my text into valid datetime before using it, thats why I orginally had my columns set to nvarchar data type.

[dunfiddlin]

The correct mask is 00/00/0000 (known as ShortDate) but note that this is still a string value. To make a Date variable you will need to use one of the Date.Parse methods.

[Chill3002]

Would I put the Date.Parse method in the click event of the msktxtb or some where else?

[detlion1643]

I believe before entering into sql. In your query you should be able to use Date.Parse(Me.mskSupOutDate.Text). I think that's the right textbox...