I want to write a code
Dim comm_update As New OleDbCommand("update item set status = "On Loan" where itemid=@itemid")
I know I cannot write "On Loan" as above, but I don't know what's the right way. status is an attribute in my access table.The SQL should update the status to string "On Loan"
For displaying the character & in a button as text, i am using &&
I would like to display the string % in another one button but the &% does not work.
So how can i display the char %
By using this btn5.Text = "%" the percentage symbol is not displayed at all!
If I needed to escape a double quote character within a string literal I'd use two consecutive double quotes as follows:
Dim name = "Chuck ""Iceman"" Liddell"
However, it doesn't seem like consecutive # works the same way. The compiler is expecting a compiler directive to follow the # character, even when its enclosed in double quotes. How can tell the compiler that I want a # character in my string?
EDIT: as a few of the answers below point out, # is not a reserved character. I closed my solution in Visual Studio and re-opened it and no longer got the compiler squiggles warning me.
I am trying to replace an & in the name of a service in an xml document.
The & is causing an error. Is there anyway i can write some piece of code which will escape "&" as " & a m p ;"?
Here is my code snippet:
Public Function convert(ByVal robert As String)
Try
robert = Replace(robert, "U", "A")
[code].....
earlier with my program question and found out that """" is how you make " become another variable in the function:Robert = Replace(Robert.ToLower, """", "A")So now I am also trying to work with other keys like the semi-colon. I put it in the function like this:Robert = Replace(Robert.ToLower, "char(59)", "B")I also tried to insert ; in place of char(59) with in front of it as an escape key, none of this worked. It still just gives me a ; when I type
View 2 RepliesDoes VB have an equivalent to the @ symbol in C# to quickly and efficiently escape a SQL command line string?
View 1 RepliesI want to do the equivalent of the following VB in c#
Function([class]) "hello"
This would be the same as this in c#
class=>"hello"
The problem is that the word class is a key word in the language. But I want to use it as a variable name. In the VB example you can use the [] brackets to 'escape' that key word and allow it to be used as a variable name.
How do I write an expression to calculate all characters of each row by my own defined value to each character = all the A and B and C and etc. will be as 2 and all I and J and whatever ... will be 1 so I need an end result of the total.
View 3 RepliesI am working on a sub that essentially needs to open a text file, and replace all instances of a certain character with a unicode character. I'm trying to do this by reading the original text file byte by byte, converting it to a character, and then either adding that character to a memory stream or writing the unicode character to the memory stream. Then I'm saving the memory stream to the original file.
[Code]...
[Code]...
For each character of this string I want a new character out of the string and then remove the character from the list of characters that still maybe used for other characters. It may not get the same character, you could basically just call this encryption, but it's not what I am making. I don't want to waste my time doing this one hour while VB can do this for me in <1 second.
I am writing a hangman type game and I am displaying the word to the user in a label as all *'s, but I cannot figure out how to have just one of the *'s changed in the label to the correct letter when the user inputs the correct letter into the text box and clicks the check letter button.Everything else in the program works perfectly, except for this part.[code]When I use the .Replace it changes all of the *'s to the correct selected letter.
View 2 RepliesbuildLetter.Append("</head>").AppendLine();
buildLetter.Append("").AppendLine();
buildLetter.Append("<style type="text/css">").AppendLine();
Assume the above contents resides in a file. I want to write a snippet that removes any line which has empty string "" and put escape character before the middle quotations. The final output would be:
buildLetter.Append("</head>").AppendLine();
buildLetter.Append("<style type="text/css">").AppendLine();
The outer " .... " is not considered special chars. The special chars may be single quotation or double quotation. I could run it via find and replace feature of Visual Studio. However, in my case I want it to be written in c# or VB.NET
I need to convert this string to the proper form in my vb,net code
if (c == '"') {
s.Append('"');
} else if (c == '\') {
s.Append('\');
} else if (c == '/') {
[Code]...
I'm trying to track down the cause of an annoying interface bug in an app that was ecently upgraded from VS2003 to VS2008 (the bug did not exist pre-migration).What happens is this :1) User clicks in textbox containing a date.2) User clears date3) User tries to move to another field, but can't. No error messages appear - it's as if the validation failed.Further info :1) The textbox's Text property is bound to a dataview which uses a datatable as its source. The bound field is a nullable datetime field with no constraints or default.2) The Validating event fires and the CancelEventArgs property is not set to Cancel. The Validated, LostFocus and Leave events all fire as well, going LostFocus > Leave > Validating3) I can't see any code changes relating to the control or the datasource with a couple of exceptions. The first is that this :
Me.txtRangeEnd.DataBindings.Add(New System.Windows.Forms.Binding("Text", Me.dvClientNos, "RangeEnd"))
has now changed to this :
[code].....
I have a couple of strings (in Ms-Word) which I copy and paste into variables in visual studo. Ms-Word uses high ansi characters for double quotes ("x"). I need the same in my app too. There seems to be no easy way to do this.
1. Visual Studio converts them to simple double quotes ("x") if I let it format the line automatically (auto-indent/auto-format).
2. If I turn autoformatting off and put those characters, I can see the correct characters in the code in Visual Studio editor. But when program is run the behave same as the simple double quotes. They are treated as simple double quotes and converts to simple double quotes in the output.
The only way I could find out is to use Chr() etc. functions to concatenate the character codes at appropriate places. But that's tedious on large strings. I want something to escape these characters appropriately (just like we can put two double quotes to escape the simple double quote character). [code]
1. What is the correct way to escape these characters? I don't need string concatenation; I need it in one string (like x="abc").
2. Are there any other characters also which visual studio messes up?
I am using VB2010. I am trying to use the escape key to close the application I have made. While the webbrowser is selected the shortcut doesn't work.
So far I have used the following code:
Private Sub Form1_KeyDown(ByVal sender As Form, ByVal e As System.Windows.Forms.KeyEventArgs) Handles MyBase.KeyDown
If e.KeyCode = Keys.Escape Then
[Code].....
[code]How do I do this in VB, while having a root namespace in the application, is this possible?
View 4 Repliesthe coding is to 'Get input string and put its character into List, and replace the character with other.'but having problem putting each character into List and also replacing it,[code]
View 2 RepliesI want to read a text file(.txt) character by character into a database.There are 28 characters on each line and I want to read the first 16 into a column in a database and the rest in another column in the database.
View 7 RepliesIn my VB.NET application I compare words that are recorded using IPA, many of which have many diacritic marks. In one of the comparisons, I compare the words character by character. But when I iterate over the characters, the diacritic marks come out as separate characters (as I would expect since this is unicode)However, a u character is different than a u plus an accent for the purposes of this program and needs to be distinguished.
View 1 RepliesHow do I escape form data in VB.net? I have various lines like this[code]...
View 6 RepliesI'm trying to execute an sql statement in vb.net to an Access database, I am escaping the reserverd word using square brackets []. This has worked in all my SELECT statements within the program.
The reserved word is level
But the SQL statement below fails saying
Syntax error in INSERT INTO statement.
If I directly copy the statement and execute this in Access it works fine
datalayer.getDataTable(String.Format("INSERT INTO users (username, password, [level]) VALUES ({0}, {1}, {2})", username, password, level))
The above statement works if I remove [level] and replace this with another column name.
How to exit a form using escape button in vb.net 2005. I need to show a msg box with yes or no conditions only.... Now I am using this code for exit a form..
If e.KeyCode = Keys.Escape Then
Application.ExitThread()
End If
all i have the following code <%= Replace(FindAndReplace(objDR.Item("LENTAB_NAME") ),"'","'") %> in this we are replacing the ' character with ', which is working fine. but when i tried to enter values like '"" then it is giving scripting error as
[Code]...
I am facing an issue with my code the thing is i want to escape { in the string.format function Of course one way to escape it is to use {{ (2 curly braces)Is there any other way possible to escape without using the double curly braces.
View 4 RepliesI see that print methods have changed in for vb.net 2010. I have looked up and down the internet and have found many examples for earlier versions of vb, but these can not be used in 2010.
I can not use graphics.drawstring / printdocument method because I need to send escape sequences.
I use ASP.net VB.net to write a XML file. In one of the element which is called "Description" i have to add a "<![CData[Class : <b>Class Name</b><br>Price: 100,000.00]]>".
[Code]...
While searching on how to escape a single quote in String.Format, I found the answer at SO: Escaping single quote in String.Format(). It seems to be different for VB though. I tested it, and indeed C# needs
string s = DateTime.Now.ToString("MMM d \'yy 'at' H:mmm");
while VB needs
Dim s As String = Now.ToString("MMM d 'yy 'at' H:mmm")
Why does C# need a double backslash, and VB a single backslash? This might be a bit of a silly question to C# users, but while I can read C#, I'm not used to writing it.
Is there a way to escape all metacharacters in a string with the exception of "*"?
View 1 Replies