I have a txtEmail textbox
In this textbox i will get mail id s like [url]... when i press Treeview node
if treeview node.tag doesn't has email ids i will display only semicolon
so in some conditions i got values like[url]...
and also i need to remove mail ids when i un check treeview.
newUserCommand.CommandText = "INSERT INTO users(username, password, security) VALUES('" & newUserNameBox.Text & "';'" & newPassWordBox.Text & "';" & newUserSecurityBox.Text & ";'"
I cannot find where the syntax error is but vstudio tells me the error is in a unclosed quotation after ;
In VB6, there was a function that moves the print position along to the next tabstop, like so:
[Code]...
I have a csv file from which i am getting the data into a table. Example: "ABC",1,"Apple" The requirement is that the strings will be inside the quotas " " and integer will be without quotes. The above line will split into three columns. i am using stream reader class to split the line into columns using line.split(','). It was working fine unfortunately i got a record in a file where there is a comma in between the string quotes like these "ABC,DEF,ghi",2,"Orange". So instead of 3 columns now they are acting as five columns and all the conversion are failing. writing the script in C# which will replace the comma between the quotas into semicolon and don't touch the comma in between the columns.
View 2 RepliesI have written a VBA (Excel macro) to open a workbook, and save it as a semicolon .CSV file, and then close it self. Excel on the server at work has a nasty tendency to start in safe mode (or at least ask if it should start in safe mode), making my Open-And-Shut macro fail. Now I've rewritten the program into VB.NET code (vs2008), but it creates a true .CSV (comma separated value), and I need semicolon. The excel file contains "last name, first name" making comma separation useless. Also making it impossible to substitute "," with ";" [Code]
View 3 RepliesI am trying to add a text file with SemiColon Delimiters to DatagridView, i did few codings but getting a error as "
"At least one of the DataGridView control's columns has no cell template"
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
OpenFileDialog1.ShowDialog()
[Code]....
I use the following code to add a record but get the error:"Missing semicolon ( at end of SQL statement. " I removed the semicolon, placed it before the SELECT but it seems to continuously cause problems.
Quote:
Public Sub AddAccountRecord(ByVal name As String, ByVal type As String, ByVal user As String, ByVal balance As String)
Dim strSQL As String
Dim objConnection As New OleDbConnection(strConnection)
Dim objCommand As New OleDbCommand(strSQL, objConnection)
[code]....
I am using VB .Net to loop through a regex Match and generate a sql statement. I'm creating the sql like this
sql = "Insert Into Agencies (Address) Values"
While MatchObj.Success
sql = sql & "(""" & MatchObj.Groups(1).Value & """), "
[code].....
I'm trying to get a ComboBox to remove the 6th string in the ComboBox or an index of (5) but it doesn't remove it here is the function I am using:
if ComboBox1.items.count = 6 then
ComboBox1.Items.RemoveAt(5)
End If
What I am trying to do is allow the user to enter a list of authors in a textbox separated by semi colons. After each author is entered, followed by a semicolon, I would like the autocomplete to work on the next name and so on (e.g., Smith, John; Eastwood, Clint...). I can get the autocomplete to work in a textbox with one name, but cannot seem to figure out how to get it to work on a list of names in a text box.
View 8 RepliesIs there a way to open a semicolon delimited text file to a datagrid in vb.net??
View 4 RepliesI have ran into an issue where I need to save some Excel data to a semicolon delimited file. (Why is an issue unto itself) And I can not find a way to do this using VB. In excel I can use Import Semicolon delimited files but I can not find a way to save them. Is there a VB constant or method I can use to save semicolon delimited files without having to write my own save procedure to format the data? such as the xlCSV, xlDIF, xlTextMSDos formats. I would think that since it can import this format that it should be able to save it.
View 6 RepliesI'm trying to make the autocomplete work on a list of items entered into a textbox separated by semicolons. I have a list of authors the user can choose from and it autocompletes as they type the name no problem, but what I'd like to do is after the user types a name followed by a semicolon, the autocomplete works on the next name and so on.e.g., Smith, John; Eastwood, Clint?
View 1 RepliesI made a simple gui whit vb 2005
[Code]...
The following code:
If checkboxList.Items(i).Selected Then
.Fields("DESC1").Value += checkboxList.Items(i).Text + ", "
End If
should produce output such as "A, B, C,(space)", which will then be bound to a dynamically created GridView. I would like to remove the last two-char string, that is ",(space)". How can I do this?
how do I remove a certain part of a string, but I don't know what it will be, I only know that it will start with: [Code]
View 4 Repliesi have the folowing problem: i made a combobox on my form and in order to add items to it i use a normal textbox and a string in application settings, the textbox add's the item in both the combobox( with this code ComboBox1.Items.Add(TextBox1.Text) ) and the string in application settings with the folowing code:
[Code]....
I have a string which contains words with parentheses. I need to remove the whole word from the string.
For example: for the input, "car wheels_(four) klaxon" the result should be, "car klaxon".
I have a string like this sravani/, asdfff/, lsdsf/. I want to remove last character '/' in the above string...which function can I use?
View 4 RepliesHow can you remove number from a sting. The numbers could be anywhere in the sting and they could be any combination of numbers but would be together in the string. Ie abcdefg321hijk....
View 4 RepliesI am trying to remove a last character of a string. This last char. is a newline (system.environment.newline)
I have tried some things but I can not remove it.
Example:
myString.Remove(sFP.Length - 1)
Example 2:
myString= Replace(myString, Environment.NewLine, "", myString.Length - 1)
How I can do it?
How can I remove all of the text to the right of the second to last / in a string.
Before = ftp://sylenttechnologies.com/text/test/another test/
After = ftp://sylenttechnologies.com/text/test/
I have a textbox showing -450 as output but I want it displays out put as 450 by removing - from 450 ....
View 1 RepliesI have one data like 123, 456, 789, now I want to remove the last , how to do that
View 7 RepliesI have calulator while pressing the calculator buttons that corrsponding caption will display in text box
ex:(12 + 2+ (text1) - sum1+[Ref1]/[ref2])
1. how to remove [i have button for remove] string upto previous oprator
2. ex now if i cliked the remove button ex :(12 + 2+ (text1) - sum1+[Ref1]/ should be like this
3. again i clicked it should be like this ex :(12 + 2+ (text1) - sum1+
I have one data like 123, 456, 789, now I want to remove the last , how to do that?
View 2 RepliesHow can I remove a certain string in a sentence ?
"10. testing"
how can I remove "10." using regex
I have this string:
Dim stringToCleanUp As String = "bon;jour"
Dim characterToRemove As String = ";"
I want a function who removes the ';' character like this:
Function RemoveCharacter(ByVal stringToCleanUp, ByVal characterToRemove)
...
End Function
What would be the function ?
ANSWER:
Dim cleanString As String = Replace(stringToCleanUp, characterToRemove, "")
This should be simple but apparently it's not. I have a text file, 694 bytes. At byte 500 there's a null in the file. I've tried reading it as text and binary and I end up with a string, 694 bytes long. But anyting I do with this string fails because it appears to stop at character 500. I can do a ? asc(mystring.substring(549,1)) and I get 9 (tab). Print character 550 and I get 0. Print character 551 and I get 32 (space). How do I get rid of this null?
View 5 RepliesI have a string which look like this
dim abc as string
abc = "example=1234"
I would like to remove everything before "=" and "=" so that i would only get "1234". How can i do this.