Comments by Member 14122214

Member 14122214 19-Nov-20 1:29am View

sure does :D thanks!

Member 14122214 16-Nov-20 0:29am View

you are a genius kgmmurugesh!

Member 14122214 15-Nov-20 20:34pm View

sorry, i just missed callingmy private sub on the event haha.. all works now, thank you!

Member 14122214 15-Nov-20 20:31pm View

Deleted

No error, it just leaves the label 3 blank :(

Member 14122214 13-Nov-20 3:39am View

tried using this as well

 Dim sample As String = TextBox1.Text
        Dim letters = sample.Where(Function(c) Char.IsLetter(c)).ToArray()
        Dim word = New String(letters)
        Label3.Text = word

but also doesnt work

Member 14122214 13-Nov-20 3:26am View

Dim letters = "MSE001243".Where(Function(c) Char.IsLetter(c)).ToArray()
Dim word = New String(letters)
' word is now MSE

this worked like a charm, how can i change "MSE001243" to textbox1.tex? i tried using

"& textbox1.text &".Where(Function(c) Char.IsLetter(c)).ToArray()

but it doesnt work as what i need is for the system to get the letter of whatever i type in textbox1.text

Member 14122214 12-Nov-20 3:21am View

solved guys, sorry i just realized I declared the textbox as "" on the click event

Member 14122214 12-Nov-20 2:38am View

during debugging i found out that its returning a value of 2 double quote ("") any idea how to fix this?

Member 14122214 12-Nov-20 1:41am View

ti worked when I put it this way tho:

createSql = "CREATE TABLE IF NOT EXISTS Mate(CODE VARCHAR(25), PCID VARCHAR(25), Assigned_To TEXT, Deployed TEXT, PRIMARY KEY (CODE))"

Member 14122214 12-Nov-20 1:05am View

still doesnt work, i already used

 Dim cleanString As String = Regex.Replace(TextBox2.Text, "[^A-Za-z0-9\-/]", " ")

to clean my string same but still it has the same error :(

Member 14122214 8-Nov-20 19:33pm View

i used the backtick solution but another error showed.

says "Incorrect Table name " " with the duble qoute

the name of the table i type was random text i.e. "sampleme"

Comments by Member 14122214 (Top 11 by date)