I would like to query a string that only reads a last character.
sqlstmt = "select * from table where Area like'%A'"
Dim cmd4 As New SqlCommand(sqlstmt, con2)
da = New SqlDataAdapter(cmd4)
ds = New DataSet
[code].....
I have the above codes but i've got '-1' if nothing to read..
I am trying to do a SQL query that checks for the presence or absence of a character's occurance in a field / column as a condition to retrieve the row. In this case I only need to test for existance of the specified character and in a similar query to test for the non existence. Not where it is or how many, just is it there or is it notI am using VB express.net 2008 and it uses, I think, MS SQL Server 2008.Using VB's instr() I can tell straight away if a string does or doesn't contain a character, but I would like to know this before I retrieve the row.
using the
WHERE .... and [mytable.myfield] LIKE 'Q'
or
WHERE .... and [mytable.myfield] NOT LIKE 'Q'
produces a result, but not a correct result. It does something but I can not say that it is working even part way.CHARINDEX gets an undefined function error MATCHES also gets an undefined function error?CONTAINS looks like it should work but I am still getting sytax errors with it, so I don't know how to use that predicate yet.
I have a hardware which sends out packets containing 17 bytes to the comport in bursts of 3. the little test VB that I have written receives and displays the bytes in a line of 17 bytes long and works fine until it gets to around 170th packet, then it starts to mix up (looks like shifting the data left) the bytes shift mostly by one digit sometimes by two. then it will continue to give almost a packet correct and a packet shifted for about 50 packets. Then it will correct itself for a long while, but then the speed at which it receives drops. All the packets are sent 3 times, and before things go wrong (within the first 170 packets) the packet counter shows that it receives 3 packet each time but after the problem it goes to 2 packet per burst and then to one.
If i close my VB monitoring program say at packet 165 and immediately open it again, it wont go wrong for another 170 packets, this points the finger at VB. I have check my hardware, there is no problem with that.The program reads port - waits for 17 bytes - once 17 has been received it will go and buffer the packet in an array. In fact they are 2 arrays but printing fro either results in the same problem.I have tried whatever i could think of but to no avail, i am wondering if some kind of house keeping needs to be done to clear something... I am sorry the program is a bit messy but I have been making many changes to find out what the problem is - my code below:[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 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 RepliesThe code below reads each line from a file and if the conditions become true it adds the contents of the file from the particular line and after into a string collection (i.e. the All contents). This is what at least what the code should do as the current one only adds the line that it encounters into the string collection.
View 5 RepliesI am working on a project that involes reading an Excel file, picking through it, then creating a flat CSV file. One of the the data elements I am picking up is a 9 character string that may be numeric, or contain one or more alpha chatacters. Excel has a nasty habit of converting long numerics to scientific notaion. I can overcome this by converting the "general" string to "TEXT".
However, there is one instance where I can not get the function to work...the string is "90333E108" ( the CUSIP for USU). Regardless, the text string is saved properly into the CSV file. When opened in a text editor, it reads correctly.
When opened with Excel, it is in scientific notation. Changing the field to "text" from "scientific" still displays "9.03E+112".
how to create an csv file that Excel will open and read correctly?
You can test this by creating an Excel workbook, format all cells as TEXT and add the following data:
90333E108
123
2
[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 am trying to update someonelse code, the attached code reads from a unicode txt files and compares a string of "Department_Name |Division_Name|Position_Name|Job_Name" with a db field called "ident_org" in org tbl. Since it is a bad design, I need the code to check a combination of ""Department_Code|Division_Name|Job_Code" against db and get the value of uid_org (unique key). Then if key exists then update that specific row(s) else insert the combination of "Department_Name|Division_Name|Position_Name|Job_Name" into db.[code]....
View 3 RepliesI have a string like "Hello'World" and a Data Table with some records in it. One of those records is "Hello'World".he problem is, when I do a .Select in the Data Table, it only tries to search for the "Hello" part and throws an error on "World" because it interprets the ' (single. cuote) like the closing cuote on sql.DataTable.select("text = 'Hello'World'")I have gone through msdn doc, and it says I can escape some characters with [] brackets or f.slashes , but I just can't figure out: .select("text = 'Hello[']world'")
View 1 RepliesI have a problem with unicode character, as i create a database in SQL Server 2005. I want to query from a table that criteria fields are contain unicode character i.e NVARCHAR.
e.g: SELECT * FROM tblMyTable WHERE MyField='ភាសាខ្មែរ'. But when i did like this all rows that contain Unicode Character always display. it doesn't fit to my criteria
I 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 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 RepliesUsing VB.Net & SQL Server 2005[code]...
I want to take a first character from the string (s)
i'm currently making an app that needs to run a query between two dates. this app will run automatically, so i need to put the dates as today and yesterday, essentially.
[Code]...
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