Can someone give me a reference in using ASCII in VB2010. Is this code correct? "txtText.text = txtText.text & txtNewText & chr(13)".Im trying to accomplish here is, I have two text box. Once I entered a text in txtNewText the text is added in the other text box (txtText.text) without deleting the previous text. But i want the new text to be at the next line. That is why I use the "chr(13)" code.
View 5 RepliesI am using Microsoft.VisualBasic.Fileio.TextFieldParser to parse a CSV file that was created with Excel 2003. The parser is working great with the exception that it is converting extended ascii values to question marks! So if the file content was:
± 3
The TextFieldParser is returning
? 3
I have tried all of the encodings in the System.Text.Encoding package with no luck. I thought I had it with UTF7 but it was dropping other characters like replacing the + sign with a space.
I'm working on decoding a NMEA sentence that is a compressed 8-bit string. I'm having a very hard time of wrapping my head around the bit manipulation needed to convert this string. If someone could get me started with this it would be great.
Here is the incomming string:
!AIVDM,1,1,,A,14eG;o@034o8sd<L9i:a;WF>062D,0*7D
and here is the expected output:
[code]...
ASCII -> Hex would give
55 -> 35 35
Hex -> ASCII would give
U -> 55
how I should approach this?
Is there a way I can determine if a file is an ascii type vs a binary type without making a list of file extensions to check against?
View 3 RepliesThis time I've to work with a file which inside is like this:url...I'd like to edit the highlighted part of text: "CustAssetSeen-803981731[NUL][STX][NUL][NUL][NUL]1"If the file was a normal text file I wouldn't have any problems, but I don't know how to work with this kind of file.
View 14 RepliesI have a code for converting characters to it's ASCII-value. I want to display this in a textBox, but when I stuff it into a ForLoop VB says that the Index is outside the bounds of the array... if I take the L-1 (see code below) I miss the first character...
Private Sub btnRecieve_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs
) Handles btnRecieve.Click
[code].....
I would like to pass a whitespace character by using the System.Text.Encoding.ASCII.GetBytes(" "), and System.Text.Encoding.Unicode.GetBytes(" ") , where " " is the whitespace Character required. What do I need to type (" ") to get a whitespace character passed.?
View 6 RepliesSo I have an ASP.Net (vb.net) application. It has a textbox and the user is pasting text from Microsoft Word into it. So things like the long dash (charcode 150) are coming through as input. Other examples would be the smart quotes or accented characters. In my app I'm encoding them in xml and passing that to the database as an xml parameter to a sql stored procedure. It gets inserted in the database just as the user entered it.
The problem is the app that reads this data doesn't like these characters. So I need to translate them into the lower ascii (7bit I think) character set. How do I do that? How do I determine what encoding they are in so I can do something like the following. And would just requesting the ASCII equivalent translate them intelligently or do I have to write some code for that?
Also maybe it might be easier to solve this problem in the web page to begin with. When you copy the selection of characters from Word it puts several formats in the clipboard. The straight text one is the one I want. Is there a way to have the html textbox get that text when the user pastes into it? Do I have to set the encoding of the web page somehow?
[Code]...
What is the syntax for != in .net?
eg
if text1.text != "Test" then
Msgbox "Not Test"
end if
With Parallels and WinXP installed, I thought I'd put VisualStudio back on my computer and tinker around a bit, but it's been a while and I'm a bit rusty with it. Can someone refer me to a quick and easy guide to VBasic syntax?
View 2 Repliesthis is the first time I'm using this... -_-I'm getting syntax error near where. What's wrong with my code?
Public Sub updateSupplier(ByVal supplier_code As String, ByVal supplier_name As String, ByVal supplier_address As String, ByVal con As SqlConnection)
Try
VS 2008 Remember Textbox Text when Form reopens
So I'm trying to create a login which connects to a database which I've already created on db4free.net and already installed the connector. But as soon as i run it I have an error saying
'You have an error in your SQL syntax; check the manual that corresponds to your MySql Server version for the right syntax to use near '& Password WHERE Username = 'alan' AND 'Password = 'duong" at line 1
Imports System.Data.SqlClient
Imports MySql.Data.MySqlClient
Public Class LoginForm1
Dim MySqlConnection As MySqlConnection
Private Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK.Click
[Code] .....
I have the following
Private Sub RichTextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RichTextBox1.TextChanged
Dim words As List(Of String) = New List(Of String)(New String() {"select", "insert", "delete", "truncate", _
"from", "where", "into", "inner", "update", "outer", "on", "is", "declare", "set", "use", "values", "as", _
[code]....
The only problem is that if I type one of the key words, the word highlights, but if i type a word with one of the key words within it, part of it gets highlights as well.Example:
drop
dropped
I have a program which runs with access database, I created a connection via code which I placed in a module. Now, I have this line of codes save a new record [code]But if I clicked the save button, I got an error, I used try catch and got the Syntax error in INSERT INTO statement. I am sure that my database is properly connected. Hope someone helps me figure out what is wrong. By the way, I have a combo box and date & time picker, did I do it correct? I mean in my values code above, I used, cbSex.Text and dtpBday.Text. I found out that if I delete almost all those values and keep only student number, the data saves.
View 3 RepliesThe goal is to check for invalid data (no data/negative numbers/letters where numbers should be), it does produce a message if the data entered is invalid, but I can't figure out why it STILL displays the results. Results should only be displayed if all data is valid.
View 6 RepliesNext question.Does VB 2010 express support the my.computer etc. syntax? If so what do I have to do to use it? It appears to offer a pretty easy way to use FTP.
View 4 Repliesrs = conn.Execute("INSERT INTO scrape (scrapeddata) VALUES ('" & regexholder &" ' ")
Syntax error in INSERT INTO statement.
I want to use a progressbar while loading, which means I need to COUNT.
vb.net
Dim mysqlCount As New MySqlCommand("SELECT COUNT (*) FROM tableName AS tableCount", mysqlConn)
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*) FROM tableName AS tableCount' at line 1
I really don't understand why this occurs. The connection works fine btw. So no issue(s) there.
I am working on an app where a user can do various calculations for a number of different tasks, each task has its own unique Item ID.The calculations are done in dgv's and all calculations get captured in the one datatable.I wanted to filter the datatable based on multiple criteria, if possible, and bind it to the dgv so that the user is only working on the calculations pertaining to that particular task.From what I have read, a bindingsource would allow me to filter my data in this way.In the code below, I have binding source that I am trying to filter and then present that filtered view in a datagridview.I keep getting a syntax error at the bindingsource.filter line that says Syntax error: Missing operand after 'ID' operator.It's the first time I have tried this and I don't know what is causing it
View 1 Repliestrying to writ stored proceduer in vb.net but did not accept save it ,, it gave me msgbox error :Incorrect syntax near the keyword 'AS'.ALTER PROCEDURE dbo.StoredProcedure2
@para1 varchar(5),
AS
INSERT INTO Table1
SELECT test1, test2 From Table2
WHERE test3 = @para1
RETURN
In the following two code snippets, the code does the same thing, when I tested this.
Dim test As New Class1 Dim test As New Class1() Do the parantheses make a difference in some way? Is there an explanation of this in the msdn library?
I keep getting this error "Syntax error in INSERT INTO statement." on this line "da.Update(ds, "Llenar")" when i try to update a microsoft access 2003 database with this app. I was using this tutorial
[Code]...
HTML
Private Sub DadosN�oReconciliadosToolStripMenuItem_Click(sender As System.Object, e As System.EventArgs) Handles DadosN�oReconciliadosToolStripMenuItem.Click
[code].....
When I try to add an Update query, then open the Query Builder, I get an error saying: Error in table name or view name in UPDATE clause. Unable to parse query text. The only code that is in the Query Builder is UPDATE How would I fix this? If this is needed, the table name is Authentication, column names are AuthKeys, and Available.
View 2 RepliesVS 2010 [RESOLVED] UPDATE table SET( syntax error
View 3 RepliesI am having an issue trying to figure this out. I am writing a script editor that uses tabs (a tab control) and I want to implement syntax highlighting. My issue is that every sample I can find on syntax highlighting uses
Private Sub RichTextBox_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RichTextBox1.TextChanged
I am trying to do an insert into an Access 2007 DB but keep getting a syntax error even thougt I can get the generated query and run it in Access and successfully add to the table.
Code....
Private
Sub
ButCommit_Click(ByVal
[code]....
Been reluctant to drop this on anyone as I wanted to resolve it myself but alas it has got the better of me. I am trying to do an insert into an Access 2007 DB but keep getting a syntax error even thougt I can get the generated query and run it in Access and successfully add to the table.
PrivateSub ButCommit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButCommit.Click
con.Open()
[Code]......
I keep getting this error "Syntax error in INSERT INTO statement." on this line "da.Update(ds, "Llenar")" when i try to update a microsoft access 2003 database with this app.
Code:
1.Imports System.Data
2.Public Class A�adir
3.Dim coneccion As New OleDb.OleDbConnection
[code]....