I used to take a string from a text box in vb.net and pass it to a sql query to update or insert in a database.I faced a problem when the set of characters in the text box contain " ' " (single quote), it throws a error "unclosed quotation mark".
View 3 Replies
[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 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 RepliesHow it's possible to add/update a date(or other string) to the database when a user connects? i use in this
MySqlConnection = New MySqlConnection
MySqlConnection.ConnectionString = "server=***; Port=***; user id =***; password=***; database=***"
[Code].....
I've been working with the substring command and after coding up all the things I needed it to do, I saw a post on here where the "For Each" statement was used basically to do the same thing.Lets say we just want to take a string apart one character at a time and add each character to a label. Which would be more efficient?I made a cheap example to show ...
Code:
ABinary = "0110 1100 0001 1011"
For x = 0 To Len(ABinary) - 1
[code].....
I have a problem with the code below as a SQL command string. Note: Using .Net Framework 4.0 in Visual Studio 10 Professional. Database is a Microsoft Access file. The idea is that this SQL command string will update a password within my database. Also note that I have tried the string below with and without the ";" at the end and it does not work either way. The problem is most likely extremely obvious, but I can't seem to find it. I have commented below the code what each part of the String is.
"UPDATE Users SET Password='" & tbx1.Text & "' WHERE Username = '" & sUsername & "';"
' Users is my Table name within the Database.
' Password is the field that I want to edit within the Users table.
' tbx1.Text is where the password is stored within a text box.
' Username is the field which I would like to compare with sUsername which is a variable within the code.
Solution was square brackets, Command string now looks like this:
"UPDATE Users SET [Password]='" & tbx1.Text & "' WHERE [Username]= '" & sUsername & "'"
I doing some maintenance work on a vb .net web app and receive a system.formatexception input string was not in a correct format error after I update a row from a GridView control. The database update returns fine and I've stepped through the code and it never throws an error but when execution finishes and returns to the browser I get the following. I turned on the feature to break when an exception occurs but it never does break. Any suggestions? [Code]
View 2 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)
Does VB have an equivalent to the @ symbol in C# to quickly and efficiently escape a SQL command line string?
View 1 RepliesI am fresher in vb.net but I have experience in vb 6.0. But I want to connect database in sql server through sql connection. In that case how to create connection with window or sqlserver authintication mode and how to add or update new record in data base in batch transaction. Please help me with sample code.
So that I can understand eassily.
update statement, i am trying to update a row within a access 2007 database here is my code.
[Code]...
I am using vb.net with access database. I am using sql. How can i update database with the value 40'6"(Feet and inches values)
View 5 RepliesI want split a gridview row on an html tag. How can i do this preferably in C#??.row.cells[1].Text.Split("htmltag")
View 7 RepliesWhat is wrong with this code. It does not update the access database and no error.
Dim conn As New OleDbConnection
Dim sqlQRY As String = "SELECT * FROM StdMaster WHERE StuNo = " & txtStudentNo.Text & " ORDER BY StuNo"
[CODE]...
Using VB.Net & SQL Server 2005[code]...
I want to take a first character from the string (s)
i tried to read html contents by striping html tags in a string.when i try to print that string i got - character. how to remove this character?
View 2 RepliesHow do I add a space between every character in a string of text?For example:Change abcdefg"
To "a b c d e f g"I have two text boxes on my form, one for input, the other for output of the re-formatted string.
I would like to know how i can count the character from a string.dim mystring as string = "myfilename_employee--2010-11-23-45-00--empid200"i need to see if this string have "--" two if it is less or more than two i need to alert to the user.
View 2 RepliesI have been making a VB app that adds two text boxes together. This all adds up fine but I was wondering if there was any code to be able to turn the answer into a value such as 10.54 instead of 10.54653
View 14 RepliesI have been making a VB app that adds two text boxes together. This all adds up fine but I was wondering if there was any code to be able to turn the answer into a value such as 10.54 instead of 10.54653Basically turning the answer into a money value?
View 13 Repliesi want to compare each character is string with the pattern and if any character matches it should give error.. eg, i have "ABCDEF" as patern to matched with.
and "OULJYSA" to be macthed with the patern, as u see A is common, so in that case it should display msgbox("match found") is there any way to do it? i did it in php using regex and preg_match()
I want to get the character count of a string so I can do:
If charactercount(newbutton.text)>27 Then
'also shorten/cut the string
shortenedstring & "..."
End If
I have the command "UPDATE TYPES SET ,Name = 'john"'I would like to remove the first comma from the string(Before Name) or i would like to replace only that comma( the first one) by a space (" ")
View 3 RepliesI have an array like this:
Dim t1 as string=Textbox1.Text
Dim invalid as string()={";",".","""," ","'"}
I want to check that if a character in my array is in the text box then a message appear.
How do I find last but one character in a vbstring
for e.g. In the string V1245-12V0 I want to return V
I how do I find the last but one character in a string in VB.net.for e.g. I have a string Dim strTicket as string="56789-091F0"I want the value "F"
View 5 Repliesi need to generate the 200 character as a string at random and search for the fifth and the third vowel. this is what i have done so far but im only getting one character at random!! [code]
View 7 RepliesI have a text box but all I want to be able to be inserted is numbers [code]...
View 7 Replies
