I'm trying to do some validation testing in VB.NET. If Entity.WeekEndDate.ToString = String.Empty Then ErrorList.Add(New cValidationError("id", "Incorrect Week End Date"))
Where WeekEndDate is of type Date. When I originally build the object, how can I insert a value into WeekEndDate that will generate an empty string(ie. "") when converted from a Date to a String?
Title pretty much says it all. How do I format the date of a dateandtimepicker to insert it into the SQL date datatype?
View 20 RepliesI'm sure this is simple to do but I'm struggling to get this work, I've tried using convert.tostring, decimal.tostring, ctype(object, type) and cstr(object) but without success. I guess I'm trying to change the decial object to a string object and then assign it a value of empty string but always get type mismatch error.[code]
View 4 RepliesI am storing a value (represented as a string originally) like this -2345678901234.12345678912 - in a double variable. After storing, it is represented in an exponential format (with an e). How do i convert this exponential representation to the original(string) representation?
[Code]...
I'm trying to convert a large array to a string, and then back into the array again after sending it over a network connection. No problems with that, but to keep my string as small as possible, I want to convert each array element into a single byte. I know that each element is going to contain a number no bigger than 100, so there will be no problems keeping them all 1 byte long. Problem is, I can't find the correct conversion commands. I think I should use 'Chr' to convert them into a string, but I can't work out how to convert that back into a number at the other end.
View 3 RepliesI've got the following simple code to convert Bytes to a Hex string :-
Code:
Shared Function BytesToHex(ByVal bytes() As Byte) As String
If bytes Is Nothing Then Return ""
Dim S As String = BitConverter.ToString(bytes)
[Code].....
The HexToBytes routine obviously can take a lot longer to complete than the BytesToHex routine and is noticeably slower when dealing with a lot of data. As I'm converting a lot of hex strings back to bytes, I wondered if there was a more efficient way of doing it without looping through the whole string as I am doing?
I have a database that is giving me mac addresses as strings. What I need to do is to convert this string to a decimal value, increase it by 1 and convert it back to it's hexadecimal value. I'm familiar with c# but I have to do this in vbscript.
View 3 RepliesWorking on a personal project.Originally had the file loaded had the program read a number and had trouble converting that number of total seconds into a TimeSpan.Finally got it working with a simple code, after COUNTLESS tried of different code.[code]Now I'm stuck converting that Timespan (in the DD:HH:MM:SS format) back to a integer of total seconds.Tried a bunch of codes I could think of but it was time that I had a fresh idea from other people.
View 13 RepliesI am looking for something that will convert a byte array to a string and back, anything in-build that does it as this method would:
To string:
vb
Dim b = ByteArrSerialize(Obj, Compress, EncryptKey)
Dim sb As New System.Text.StringBuilder
For Each item In b
sb.Append(Chr(item))
Next
To byte:
vb
Dim b(0 To Len(TheString) - 1) As Byte
Dim bCount As Long = 0
For Each item In TheString
b(bCount) = Asc(item)
bCount += 1
Next
I have the following function,
Dim results() As Object = Me.Invoke("webdirect", New Object() {Company, LocationCode, CustomerNumber, OrderNumber, OrderRef, OrderDate, WebLines})
o_Company = CType(results(1),System.Nullable(Of Integer))
o_LocationCode = CType(results(2),String)
o_CustomerNumber = CType(results(3),String)
[Code] .....
So the return type of this function is a string, but I would like to get it back to its original form so I can access the individual sections i.e. o_LocationCode,o_CustomerNumber, etc how can I do that ?
Entire functions looks like this
Public Function webdirect(<System.Xml.Serialization.XmlElementAttribute(IsNullable:=true)> ByVal Company As System.Nullable(Of Integer), <System.Xml.Serialization.XmlElementAttribute(IsNullable:=true)> ByVal LocationCode As String, <System.Xml.Serialization.XmlElementAttribute(IsNullable:=true)> ByVal CustomerNumber As String,
[Code] .....
Called like this
Dim returnArray As String
returnArray = client.webdirect(10, "123", "123", "123", "147", "2011-11-1", webLinesArray, 10, "", "", "", "", "", webRespArray)
No errors on run time but the string seems to be just blank, thats why i was wondering how I convert the string back to the array so I can access the individual elements.
I'm using date in the format dd-mm-yyyy and I need to convert a string inthis format to a date type.My string is "18-01-2010" but when I do the conversion using dim TargetDate as date=CDate(TgDstr).where TgDstr is "18-01-2010", the resutant TargetDate, as note in the debugger window, is #1/18/2010# rather than #18/1/2010# which I expected.What change in code should I made to get the desired result?
(P.s. I've checked the current culture with the following line of code:
Dim str As String = CultureInfo.CurrentCulture.Name and get the result 'zh-HK'... and the date-time format I find in the control panel is also in dd-mm-yy format)
Can someone please tell me how I would convert a string of "Thu Dec 13 10:00:06 2007" to an actual date?
View 6 RepliesThe user will select an entry in a gridview, which then redirects them to a form that is populated with the data from the selected row (thus making the gridview editable in a more user friendly way). Null values are accepted by the DB and I would like to show null date values as blank (or " ") in the corresponding text boxes. Instead I get the error:
Conversion from type 'DBNull' to type 'Date' is not valid.
Here is my code:
'preceded by connection code
Dim sqlcmd As String = "SELECT * from Master WHERE RecNum = @recnum"
'Dim sqlCmd As New OleDb.OleDbCommand("SELECT * from Master WHERE RecNum = @recnum", connection)
Dim FileCommand3 As New OleDb.OleDbCommand(sqlcmd, connection)
[code]....
I have been unable to correctly convert a string to date. The string is read from a text file and placed into a string, below is a snippet of how the text file is read until the date is field is read:
Dim varOrderNo As String
Dim varDate As String
Static Dim currentrow(20) As String
[Code] .....
I have then tried loads of different ways to convert it to a Date so when I then write it to a SQL Database it enters as a date. The string read from the text file is in the format of 13122011. If I don't try to change it to a Date before writing to SQL it doesn't recognise it as a date and sets the field to 01/01/1900. I have tried and searched loads online and everything i try should work but doesn't.
Dim varDateConvert As Date
varDateConvert = CDate(varDate)
varDateConvert = Convert.ToDateTime(varDate)
varDateConvert = DateTime.Parse(varDate)
All of the above cause my program to drop out / crash at the point of the converting.
I have also tried to format the string to insert the '/' before converting:
txtDate.Text = varDate.Substring(0, 2) & "/" & varDate.Substring(2, 2) & "/" & varDate.Substring(4, 4)
varDateConvert = DateTime.Parse(txtDate.Text, Globalization.CultureInfo.CreateSpecificCulture("en-GB"))
The result for the above is:
From File: 13122011
Substring: 13/12/2011
Convert: 12/13/2011 - Crashes here
I use following codes to to convert string to date. In messagebox it displays correct date with format but in textbox it displays only #12:00:00 AM #. How to send date to textbox1 from variable mydate.
Dim mydate As Date
Dim dateString = "31/12/2009"
Dim formats As String() = {"dd/MM/yyyy", "dd/MM/yyyy"}
Dim dateObject As DateTime = DateTime.ParseExact(dateString, formats, System.Globalization.CultureInfo.InvariantCulture, Globalization.DateTimeStyles.NoCurrentDateDefault)
MessageBox.Show(dateObject.ToString("dd/MM/yyyy"))
Me.TextBox1.Text = mydate
I have this example and it gives me exception "Conversion from string x to dateTime is invalid"
here is my method to validate Datetime. Example Date string : "27/03/1985"
Public Function validateDateColumn(ByRef FieldName As String) As Boolean
[Code]...
I am pulling two fields and putting them together with a "-". When I export to excel it seems to think that the string is a date and converts it from 11-11 to 11-Nov. I can't seem to figure out how to fix this.I am exporting a gridview into excel. This asp.net using .net 3.5 and vb.net within VS 2008.
Response.Clear()
Response.Buffer = True
'grab filename from filename box
[code].....
my goal is to
1.Take an file(exe,dll,etc)
2.Convert it into hex
3.place that hex values in a stack
4.Execute the values inside the stack to its original form(i.e. take the elements out of stack and then convert it to a compile format)
Imports System.IO
Sub Main()
Dim fileName As String = "ABC.exe"
[code]....
when running my program I get the following error:Conversion failed when converting date and/or time from character string. After playing a round with breakpoints I discovered the error to appear during:
sqlText = "INSERT INTO dbo.OrderDetails (OrderID, ProductID, Qty) VALUES ('" & _
orderID & "','" & prodID & "','" & prodqty & "')"
ExecuteSQL(sqlText)
[code].....
When using INSERT INTO statement to SQL 2008 R2 to a column with data type as date and the data I am taking from a DateTimePicker control with date format as short. When my system date format short set to dd/MMM/yyyy the INSERT INTO statement is working perfectly but when the system date format short set to dd/MM/yyyy I am getting the above error.I tried by changing the control format to custom and dd/MMM/yyyy but still the same error is coming.I am using VB2010 and SQLExpress 2008 R2 SP1?
View 2 Repliescmd.CommandText = "INSERT INTO Dropping (form_num, filing_date, approval_date, status) VALUES ('" + fnum + "', '" + deyt + "', '" + nulll + "', '" + stat + "')"
here is an sql query statement i run in vb.net. i keep getting the error of "Conversion failed when converting date and/or time from character string." whenever i try to execute this. the datatype of filing_date and approvale_date is "text" but the deyt variable is originally Date, converted to string: (Date.Today).ToString, like so. nulll is simply a variable with vbNullChar as its value.
I used to query:
Dim a As String
a = "INSERT INTO tblVisitor(Name, Sex, TimeIn, EnterDate)
VALUES('"& txtName.Text &"', '"& cboSex.Text &"', '"& Now() &"', '"& DateTime.Parse(cboEnterDate.Text) &"')"
[code]....
Which cboEnterDate is my DateTime Picker. Then I got the message:Conversion failed when converting date time from character string.
I Have this date "27/03/1985" and because it starts with days i can't convert it to datetime.
View 2 RepliesThe error is: Conversion failed when converting date and/or time from character string.Basically I'm trying to make it so that when someone clicks a location in a list box it increments the correct field in a Stats table by 1 to say that they clicked the location. I've been trying to solve this for a while now and can't get anywhere. My date is in date format, and so is the Date field in my Stats table. My code can be seen below.
Dim Current As String
Dim Check As String
Dim objCmd2 As Object
[code]....
The issue comes in with the second SQL statement I think. I don't understand why adding a date into a date field would be an issue, I've tried adding it as a string which didn't work.
Dim i as integer
For i = 0 to 365
sqlinsert.InsertCommand="insert into cashdate (date) values (getdate()+'" & i & "')"[code]....
getdate is a function in the database that returns the datetime of now i have an error that says conversion failed when converting date or time from character string .what to do now ??
This must've have been asked before but I couldn't locate it. In a mixed code project (VB and C#) we were debugging some old Visual Basic code where a statement as follows could be found:
If Request.Params("xxx") <> "" Then
'do something
I considered this a bug as Request.Params could be null, in which case the statement would've become false which wasn't the idea. So I thought. I just found out, -- probably for the tenth time and I will keep forgetting -- that the following two statements are not equal, while Nothing in VB should be equal to null in C# (thought I):
if(String.Empty == null) // always false
If String.Empty = Nothing Then ' always true
Should I dismiss this as a typical Microsoft backward compatibility effort, or should I consider this a huge error in the VB.NET compiler? Does anybody know the Microsoftean opinion on this oddity?
I have a array of strings and I am looping through them, but the string might be empty so I am trying this:
[Code]...
how I can ensure that conversion of a date to a string and a string to a date will give me the same date format.
For example:
Code:
Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
Dim d As Date = Date.Now
[code].....
I'm actually only interested in the date part as the label text shows so f is more than I want.But also, the day and month are reversed.
Now I am trying to go backward and convert the mdb file to a txt or csv. Is it possible to simply reverse the code so to speak and use it that way? below is the code that I am using to convert from txt to csv. I reverse the code to produce the next result but am getting error message; "Syntax error in INSERT INTO statement".
[Code]...
I have string that contains "1.3" and I am checking with Date.TryParse method. It automatically converting into "1/3/2010". How to handle this?
View 1 Replies