You should use SQL parameters. These will not only simplify your code, they will make certain kinds of errors regarding syntax and data types extremely unlikely and protect against SQL injection attacks: Dim sql = <sql> UPDATE tblPatientsRecord SET [Names] = @p1, Licensenumber = @p2, Address = @p3, Fullname = @p4, Birthday = @p5, [Age] … Read more
While I’m glad you found a solution, I advise against using Application.DoEvents() because it is bad practice. Please see this blog post: Keeping your UI Responsive and the Dangers of Application.DoEvents. Simply put, Application.DoEvents() is a dirty workaround that makes your UI seem responsive because it forces the UI thread to handle all currently available … Read more
There’s no difference if both operands are strings. However, if one operand is a string, and one is a number, then you run into problems, see the code below. “abc” + “def” = “abcdef” “abc” & “def” = “abcdef” “111” + “222” = “111222” “111” & “222” = “111222” “111” & 222 = “111222” “111” … Read more
The And operator evaluates both sides, where AndAlso evaluates the right side if and only if the left side is true. An example: If mystring IsNot Nothing And mystring.Contains(“Foo”) Then ‘ bla bla End If The above throws an exception if mystring = Nothing If mystring IsNot Nothing AndAlso mystring.Contains(“Foo”) Then ‘ bla bla End … Read more
Depends upon the version. The If operator in VB.NET 2008 is a ternary operator (as well as a null coalescence operator). This was just introduced, prior to 2008 this was not available. Here’s some more info: Visual Basic If announcement Example: Dim foo as String = If(bar = buz, cat, dog) [EDIT] Prior to 2008 … Read more
for simple .. use SELECT CASE Private Sub txtchange_Change() Select case Ucase(txtchange.Text) case “A” : lbloutput.Caption = “Apple” case “B” : lbloutput.Caption = “Banana” case “C” : lbloutput.Caption = “Cat” case “D” : lbloutput.Caption = “Dog” case “RED” : lbloutput.BackColor = RGB(255, 0, 0) case Else lbloutput.Caption = “Not Found” End Select End Sub
It seems to me Visual Basic Code. If it is VB.NET Code use instead String.Join(Environment.NewLine, _contents)
You can try for example : Private Sub TextBox1_TextChanged(sender As System.Object, e As System.EventArgs) Handles TextBox1.TextChanged DateTimePicker1.Value = DateTimePicker1.Value.AddMonths(Convert.ToInt32(TextBox1.Text)) End Sub You can use AddDays, AddMonths or AddYears to modify the value of your dateTimePicker
If you want a shortcut, that’s what Math.Min is for. It returns the smaller of two numbers.
Try to adapt your code like this: Dim i as double=2.5 Textbox1.text= i.tostring()