I have a string arranged in a way that would match the format yyyy-dd-MM HH:mm:ss
It might look like this 2010-20-12 13:30:00 I need to insert this into a smalldatetime column in SQL Server. The format of the column is yyyy-MM-dd HH:mm:ss I need the string to look like this 2010-12-20 13:30:00 or else SQL Server will get the month and day confused.
I am posting this here because the sql query seems to be fine, it is the VB code that is the issue. I am new to VB and I have a subroutine that imports a value for the strating and ending time of a report. The error I am getting is: Conversion failed when converting the varchar value 'Aug 20 2009 12:00PM' to data type int. Here is the code for both VB and SQL:
[Code]...
The code:
strSql = "insert into table2 (transactiondate) values ('" & transactiondate & "')"
seems to be giving me the runtime error:
[code].....
i want to pass this parameter to my sql command
[Code]...
I have a smalldatetime column in SQL that can have a null value, but when I try to insert a null value using SqlTypes.SqlDateTime.Null and LINQtoSQL it puts in 1/1/1900 instead of NULL.
What is the best method to insert a null, or am I doing it at the moment. If I am using the correct method at the moment, what should be done to prevent the 1/1/1900 being displayed on my fields in a WPF application.
I'd like to convert a string which contains a decimal number into string that contains the binary value, the octal and the hexadecimal value of that decimal number.Afterwards I also like to convert a string containing a binary, octal and hexd. number into a decimal string.Basically I'm looking for the functions:
dec2bin
dec2oct
dec2hex
bin2dec
oct2dec
hex2dec
I'd not prefer to rewrite a function, I'm sure the framework must have these functions already.
Whats the best way to convert a list(of string) to a string with the values seperated by ,
View 3 RepliesIs there any way to convert null terminated string to normal string.I mean I can easily make a program to find the location of vbnull but there has to be a built in function for that.
View 1 RepliesI need to convert a string array into a very long string with following requirement:
can not using any character escaping can not using XML can not using single character as separator (e.g. comma or space as separator)
how can i convert these datatypes: date to string and integer to string.Because it must be in a string datatype when I display it in a datetimepicker and textbox.
View 3 Replieshow I can convert an RTF String to a regulat text string. The rtf string has tons of formatting info, but all I need is the text in the string.
View 5 RepliesCurrently, I'm using the following code to pull info from the management class.
[code]...
I'm also pulling info from the bios, disk drives, video, etc. What I've noticed, is although it runs fine on my pc, it may error out on some pcs since it is hardware dependent.I'm having trouble implementing a check to find if it exists before I convert to a string and add it to my overall string.
I'm working on a mass text replacer program because I'm sick of all the 10-day trial ones out there that aren't very good.The entire program is basically finished (All easy stuff), but now I need to code the actual replace/delete stuff, which I'm stuck on because apparently the way I originally intended to do it is not possible.
The way it works is you load a text file (.txt, .cfg, .ini, .doc, etc.) which opens a StreamReader which writes all the data into a listbox. Then you pick whether you want to replace or delete a string. If you select replace, then you enter the string to search for and in another textbox you enter the string to replace it with.
The way I originally intended to do this was like this:
If o1.Text = "Replace" Then 'The option
Replace(txtfile, str1, a1) 'txtfile is the data, str1 is the string to find and a1 is the replacement
End If
The problem is, I believe this method requires txtfile, str1 and a1 to be strings, but they're all 1-dimensional string arrays, which cannot be converted to strings, or at least I don't know how to convert them.
A friend told me one way I could do this is to open both a StreamReader and StreamWriter and do the replace/delete line by line as they are entered into the memory and write them to a temporary file which is then copied over the original. I can do this kind of, but I still don't know the proper way of doing the actual replace code because the string to find and the string to replace with are still 1-dimensional string arrays rather than strings.
Dim namelist As List(Of String) = New List(Of String)
namelist.Add("Hi")
namelist.Add("Hello")
[code].....
I have the following code...
Const ToAddress As String = username.Text & "url..."
which sets to ToAddress to be used in on my Net.Mail.MailMessage that is to be created with the following constructor
Dim mm As New Net.Mail.MailMessage(username.Text, ToAddress)
which takes in a string and a constant string. But I get an error here[url]...
I have a function that takes string array as input..I have a string to process from that function..
Dim str As String = "this is a string"
func(// How to pass str ?)
Public Function func(ByVal arr() As String)
[code]....
I have also tried :
func(str.ToArray) // Give error since it converts str to char array instead of String array.
To be able to sort a dictionary by value I'm using this code:
Dim idCurrentJobs As IDictionary(Of String, Int32) = New Dictionary(Of String, Int32)
'The string in the dictionary represents a jobname and the integer is a counter for how many jobs im currently are running in the application'
idCurrentJobs.Add("JobName1", 2)
[code]....
Value of type 'System.Func(Of String, String)' cannot be converted to 'System.Converter(Of String, String)
Why? They are both effectively a function pointer (or delegate?) to a function that accept a string and return a string.
I have 1 string of 12 numbers separated by a ',' "11.11,22.22,33.33" etc coming in my serial port. One number has so far been 5339, but now its changed to 533d, which causes problems, for reasons I am still trying to work out.
The top numbers are all real numbers ie 0.000 or 00.00 or 000.0, whereas the bottom 3 numbers are Hex FFFFF but just happen to show decimal numbers by 'good luck'.[code]....
How to convert a string to required xml format in c#.net[code]...
View 1 RepliesI have a CSV file which contains the following string:[code]I split the strings into an array using the following:[code]That seems to work, but now how do I convert the Hex strings to numbers when the string is in the format shown above?
View 3 Repliesthis is the hex value of a arabic text "d98ad8a8d8b3d8a8d8b3d8a8" how can i convert it to string
View 3 RepliesVisual Basic 2010.
Dim selection As String = ListBox1.SelectedItem
Dim url As String = Split(selection, " - ")
Form1.WebBrowser1.Navigate(url(1))
I want to convert the URI (Value of type '1-dimensional array of string' cannot be converted to 'string') to a string. How would I do so?
(The selection variable is something like "Title - URL")
here is my code
Dim oWeb As New System.Net.WebClient()
oWeb.Headers.Add("Content-Type", "application/x-www-form-urlencoded")
Dim bytArguments As Byte() = System.Text.Encoding.ASCII.GetBytes("username=username&password=password")
[code]....
m attempting to get the cookies saved then use it for another post data i want to do, but I keep getting logged off in like 1 second.The error is Argument 'Prompt' cannot be converted to type 'String'.for the message box.
I want to convert a md5 value to string but i do not know how can do i know how to convert a string value like "msdn" to a md5 value "8eedb43a46f91747432c28b51f6046"
usin this code
[Code]...
How do I convert from a string to an integer? Here's what I tried:
Price = CInt(Int(txtPrice.Text))
I took out the Int and I still got an exception.
Is it possible to convert a string of text from a textbox into Octal numbers? If so, how to convert octal to text and text to octal.
Edit: Oh, now I understand how it works. I thought that hex and octal were 2 different things but really it's 2 different bases. Sorry for the second post
I have a textbox field called ClientsBalance.
This balance can is usually in money order with a set amount. The client is also allowed to pay by Debit Cards.
Here goes:
Dim paymentType As TextBox
otherPyment As String = "Debit Card"
If paymentType.Text <> "1250" Then
[Code].....
I have a Session variable in which i have stored one date '22/7/2009'.Now i want to convert value in session to datetime. I tried folowing code:
Session("AppointmentDate") = Request.QueryString("ADate")
Dim s as datetime=Convert.ToDateTime(Session("AppointmentDate"))
But error is showing as 'string is not recognized as a valid datetime'. convert value in Session to date?
In my project i want to search a word in 10 different music sites and return all the links on the site, the problem is that i can't convert a string to a htmldocument.[code]
View 1 Replies