I want to do in vb.net what I would have done in SQL with the CHARINDEX command. That is, I want to interrogate a string and ask, 'Does this string contain a hyphen? If so, whereabouts in the string is it?' I tried Googling this but as with a lot of things in vb.net, there's always a million different answers given with each response seemingly trying to overcomplicate the issue and out-code the previous one. Hence my confusion.
View 5 Replies
I can't figure out the syntax for searching an array of stored words for a string matching an input string. I understand the pseudocode of it, but I'm tripping up over what variables I need to put where, and how they should be formatted. More than happy to provide more details should anyone request them.
[Code]...
I am developing a payroll system which will obtain the attendance of all the employees in the company through a swipe card machine. how to interrogate the swipe card machine with the pc.
View 4 RepliesI want to create a MsgBox function using the buttons Ok and Cancel.I know how to do it but what syntax do I use when the input is Cancel to go back to the program?
View 3 RepliesDim listbox1 As New ListBox
listbox1.Items.Add("<br/>")
Dim int As Integer = 0
Dim line As String = RichTextBox1.GetLineFromCharIndex(RichTextBox1.SelectionStart)
For Each item In listbox1.Items
[Code] .....
My coding selects an item from the list box and tries to color the words in the currently selected line, however, it often colors characters that come after the instance. Why is this happening?
I'm making a part of my program that takes three inputs from the user and adds them then divides that number by three (the average of the three numbers). [code]...
View 7 RepliesIm working on a program and I get this "Value of type '1-dimensional array of String' cannot be converted to 'String'." heres the code that gets this error:
[Code]...
the following code shows invalid qualifier when executed
Dim strs As String
Dim insStr As String
Dim strRes As String
strs = "This is VB.NET Test"
insStr = "Insert"
strRes = strs.Insert(insStr)
I wonder if there is a Type that converts a string to a VB syntax to be read by the compiler.
for example:
Dim command1, command2, command3 As what??!
Dim drv as DataSet.Datarow
drv = CType(BindingSource.Current, DataRowView).Row
[Code]....
Code in VB.NET
[Code]...
works very well. So seems some consistency miss of the string constant behavior.
2) Have a look on the COMMENTS (in the attached picture). The words "custom", "string" and "error" are highlighted, however they are in the comments, so should be green, not blue.
Why this? What workaround? EDIT: Declared as "bug" in Microsoft Connect (even if is not more that a syntactic "miss")... EDIT 2: As remarked Hans Passant, standard string methods, like "cucu".Trim() does not work either.
I am trying an encrypting exercise which takes the txtmessage and encrypts it in characterarray.IStartAt is the starting point and by taking one character at a time from txtmessage I need to insert it in characterarry allowing a gap in between which is IUseGap. KeyGap and Keyfirst will be the next two characters after txtmessage and when insert have no gap in between.I think the logic I done is good however, I get syntax errors on the red lines.[code]
View 11 RepliesI need to interpolate a string containing a file name into this statement...
fileReader = My.Computer.FileSystem.ReadAllText("C:myfile.txt")
I get a syntax error while trying to update a datatable using this syntax string:"SELECT * FROM ClientContacts WHERE MembershipID = '" & stringVariable & "' "
View 6 Repliesthis code will not pass the query string to default3.aspx on Image Button [code]
View 1 RepliesI have the following code:
Imports System.Data.SqlClient
Public Class Main
Protected WithEvents DataGridView1 As DataGridView
[code]....
When I debug this, I put the line break on that line and look at the Table Value, which shows 0, but I know that there is data for that time frame.
VB syntax functions for string operations
View 2 RepliesThe intent of the code is to open an xls file -minimize it , search for keywords . there are columns like test case name ,priority(simple ,medium and high) with associated keywords.If keywords are found, it shld save the test case name - Priority in a text box. When i run this code i am getting err in
[Code]....
i am using DateTimePicker control....my code is TextBox2.text=DateTimePicker1.Text.......while changing it correctly dispaly the selected date in textbox......the problem is i want to store the date in my database of field datetime type........when i click the add button it shows "Syntax Error Converting DateTime from String"
View 1 RepliesIn a SQL UPDATE statement, how to i "set" a field to empty? (because it was occupied before). i get a syntax error (missing operator) that points to my sql string this is the update command i am using but its not working.
[Code]...
Getting this error when updating a row via a gridview with a sqldatasource in Vb.net/SQL Server 2000. No matter what input (1/1/2010, blank, etc) I give it I can't seem to get it right.
Code before the input is passed to the sp:
Dim sqldatenull As DateTime
Dim DateVerify As DateTime
sqldatenull = DateTime.MaxValue
[Code]....
Im in the process of building a call loggin system and its finally been put on the server, but i keep getting the above error "Title" the first stage it goes to be authorised and when the authoriser auths it...it updates the table with the date they authorised it. which is fine, the next stage is the Business Analyst where they check all the content of the task and then approve it but for some reason unknown to me it keeps falling over on the .dateAuthorised
My Sql Column to hold the date authorised is a Datetime datatype and im converting a string to a data time within the procedure this is my Code behind page
Dim StatusNew As Integer = 53
Dim CurrentStage As Integer = 51
ITUpdateTaskTable.Add("@spWorkID", Replace(TskNumLab.Text, "LC", ""))
[Code].....
I have the following code:
Imports System.Data.SqlClient
Public Class Main
Protected WithEvents DataGridView1 As DataGridView
[Code]....
When I debug this, I put the line break on that line and look at the Table Value, which shows 0, but I know that there is data for that time frame.
I'm looking for a way to search a string variable for two words and copy the text in between them into another variable. This needs to be done as many times as the match occurs.
View 3 RepliesHere is a code to insert data to DBaccess from textbox. When I write a colon(') in the textbox to add to DB it caused error and show me this Message "Syntax error in string in query expression '''')'
Code:
Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source =" & Application.StartupPath & "Store.mdb ")
Dim cmd As New OleDbCommand
cmd.Connection = conn
'Add text to DB
[Code] .....
I get the following error:
Line 1: Incorrect syntax near ','. Unclosed quotation mark before the character string ' )'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
[code]....
when saving am getting this error"undiscclosed quotation mark after the character string')'.incorrect syntax near ')'.I used the command in other codes which working perfectly. [code]...
View 10 RepliesI have the following INSERT statement which at run time gives the error; Incorrect syntax near 's' Unclosed quotation after the character string ')'
[Code]....
how do u use connection string in visualbasic? and i want to our compose mail cs file code in visual basic byusing to,cc,sub,message
View 2 RepliesHow can I add a string to my visual basic form?
I'm creating a study application for myself and this is what I have:
Imports System.Diagnostics
Public Class Form1
Dim amounts As Integer
[Code].....
I'm trying to display a line of text on my form saying.. "Prevented firefox from running X times.
X being my "amounts" variable.
Here's what my form looks like:
So how can I put my amounts variable in place of the X?
I am extending some of the basic data types in vb.net for a large application. This includes integer, string, short, etc. As it stands, my new data type objects have names like MYInteger and MYString. Since these are the only types I'm using for my application and they are mostly compatible with the default types, is there a way I can override the defaults with mine so when you Dim iThing as Integer you're actually using my slightly customized integer type?
View 3 Replies
