I just can't get this If statement to work with htmlelementcollection. The problem is my msgbox pops up saying element found rather the element is there or not.[code]
View 4 RepliesSee
Public Class Form1
Dim sql As String
Dim conn As New OleDb.OleDbConnection
Dim da As New OleDb.OleDbDataAdapter
[CODE]...
The problem, The INSERT statement works fine in the form load but not in the button click event?
I'm confused on the results of this code. The results extracts the tag "div" but why isn't the results containing the word "Yoga"? Shouldn't the result have only one element because it should exit the for loop after finding the first element? The results show hundreds of elements
Dim ElementCollection2 As HtmlElementCollection = WebBrowser1.Document.GetElementsByTagName("div")
For Each curElement As HtmlElement In ElementCollection2
[code].....
whta does it means :Dim tags As HtmlElementCollection = WebBrowser1.Document.All
View 1 RepliesThe following works:
[Code]...
However, the following doesn't work:
Dim connetionString As String
Dim cnn As OleDbConnection
connetionString = "Provider=SQLOLEDB; Data Source=****; Initial Catalog=****; User ID=***; Password='****';"
cnn = New OleDbConnection(connetionString)
Try
cnn.Open()
[Code]...
I have been working with this for awhile, and I can't get it to work, I have all the correct names where the connection string is, but I just can't get it to work. It is telling me the server does not exist, but I am using a hosted solution that I know is up.
Dim
a As Date? = Nothing
Dim b As Date? = If(a Is Nothing, Nothing, GetValue(a))
I thought b would be Nothing, but it is not...is it a bug?
I have this app that can now control my browser but after I use the htmlcollection of links how can I put that stored information into a richtextbox?[code]
View 2 RepliesI'm not quite sure why, but this program doesnt work as intended. It's kind of difficult to explain but if you tried it, it doesn't work properly.
Private Sub btnApply_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnApply.Click
'clears the changes box before going through if statements
Me.txtChange.Text = ""
[CODE]...
I'm having a problem with the Math.Abs statement. When I try to use this statement to figure the absolute value of a number, as in:
View 3 RepliesI am trying to type in the food Pizza, Taco or Crepe and get a picture of the food to come up along with a message box that gives the country.[code]
View 3 RepliesI was thinking if I can create a code that creates 8 Labels, and each label will show someone's name. The name is not generated, it is randomized. But I Don't want to see 2 same names in 2 different labels. So what I came across is this:
First, I will make an array variable (0 to 8) as String, I will declare each person's name here, the 0 is not used. I Will call this "Names"Second, I'm going to make an array variable (0 to 8) as Boolean. Original State is False. I will call this "Type"Third, I will make another array variable (0 to 8) as Integer, this one is empty. I Will call this "Empty". Original value = false
The Point is that the application will randomize a number between 1 to 8, just say that the randomized number is "x". Then I will take Names(1) and fill it in Empty(x), and set the Type(x) to True, and keep looping. If the application finds the Type = False, then the application will randomize another "x". But after making the code, it seems that the numbers show up the same way everytime I run it. Even with the Randomize() statement.
[Code]...
I'm working through a programming project, which should be quite easy but im stuck right at the start (relatively new to VB). I have a textbox (named textbox1) and a checkbox next to it. I want the checkbox to be ticked (.checked) when ever the value in the textbox is between 1 and 100, the checkbox to not be ticked when theres nothing in there, and for it not to be ticked when the value is < 1 and > 100. Figured a case statement would be the easiest. (this piece of code is just a validation check, basically in the real thing the user would have to enter in a value between 1 and a given number, and need to tell the user if that value is valid).
Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged
Select Case TextBox1.Text
Case Is = ""
[code]....
But what happens is, if I enter in the value 1 in the textbox, the checkbox becomes ticked, as it should. It tick with any values between 2 and 99 (any number not starting with 1) but the checkbox becomes ticked again when the value is 100. For any other range, say 1 to 70, the checkbox would be ticked if the value in the textbox is 1 to 7, or any number starting with 1 or 7, but not 8 or 9, or any number starting with 8 or 9.
how I can get the LIKE statement to work if the user enters a number like 403* ? The sql works if I do not enter an *
strWildCardFound = InStr(TNSearchTextBox.Text,
"*")
TNSearchTextBox.Text = Replace(TNSearchTextBox.Text,
[Code].....
How do I write the equivalent c# code below in vb.net? This 'About' form is launched by a ToolItemMenu. It is just informational and contains only an OK button
//Form contains company logo, copyright info and OK button.
public About formAbout;
using (formAbout = new About())
[code].....
I am having issue with this function where wait_rtn statement does not work and errors out with error 0. it is suppose to search the screen and if it finds (true) get out of the loop...
[code]...
I'm currently having some trouble getting an If statement to work. I want the statement to do its thing when it detects a form is not open. this might sound a bit confusing this is what i mean:
If Form2.open = false Then
blah blah blah
blah blah blah
blah blah blah
[CODE]...
Basically i dont know if im able to have an IF statement occur for when a form is not open and i dont know how to word it.
i'm having troubles with a linq-to-sql statement and getting a left outer join to work. here is a sample of two tables i'm trying to join and my code that i've wrote.
Table1 Table2
f1 f2 f3 f4 fID f1 f2 f3 f4
val1 val2 val3 val4 1 val1 val2 val3 val4
[code]....
Instead I'm returning ALL values from table 1. I need to return all values from the left outer join where tbl2.fID is null.
tags As HtmlElementCollection = WebBrowser1.Document.All
View 4 Repliesupgrade my DAO code to ADO? The following code worked fine in VB.Net for Interop Access 2007.
View 1 RepliesI was convinced that If <expression> Then <statement [:statement]> Else [statements] in concrete form of If a = b Then SayHello() Else SayBye() End has sense. I read article on msdn on If-then-else, but I forgot why I was reading, so I concluded, that snippet above means this
If a = b Then HelloIsSaid : IsNotEnded Else ByeIsSaid : IsEnded But I have tested it now, and I see, that Else without statement is nothing more than decoration. It would be pretty good if it had function I described. Do you think its good request? Or do you know any circumstance where this Else has some function?
y friend and I are re-learning Visual Basic, and we are stumped on this bit of code.
For intAsterisks As Integer = 0 To intLine - 1
lblAsterisks.Text = lblAsterisks.Text + "*"
Next
I have the following SQL:
[Code]...
I want to put it (the select count statement) in this LINQ statement so I can get the sales count in my linq statement: Dim TheLeads = (From L In DB.Leads Where L.IsDeleted = False Select L).ToList() Is this possible to do in LINQ?
add an if statement and an exit statement to my do loop that exits when my future value (FV) is greater than 1000, then to change the exit statement to a continue statement so my loop will continue even though my fv is greater then 1000, point is to get this to run even though my if statement doesnt do anything. problem something wrong in my code and an exception error (xception of type 'System.OverflowException' occurred in mscorlib.dll)
so can someone show me where or why I have an error is, what am I overthinking now! I could use a hint, OMG i could use a tutor for that matter
[Code]...
A co-worker wants to convert the following IfThenElseIf statement into a Select Case statement.
Explain why this is not possible.
If temperature = 100 Then
X = 0
ElseIf population > 1000 Then
X = 1
ElseIf rate < .1 Then
X = -1
End If
I cant get this SQL statement to insert any of the values in the form to add to the database
sql
sql = "INSERT INTO prevresults (ExamDate, ExamTime, CorrectAnswers, PassPercentage) VALUES (date.now, time.now, rightanswers, percentage.text)"
[code]....
I found that when group by multiple values does not work well with VB.NET, but it works well with C# ,here are my code, is there something wrong with my VB.NET Code? Here is my VB.NET code:
[Code]...
I have an application that requires data be entered, and after entering, a button is clicked to process that data. Clicking the button works just as it should--the data is processed properly. In constructing a test module, I provide a set of data values, followed by:
btnWhatever.PerformClick()
Nothing happens. I have used this syntax for years, and it has always worked flawlessly. I have triple checked everything else and isolated the problem to the failure of the PerformClick(). The PerformClick() is in a test subroutine that does nothing but fill textboxes and labels with default data, then calls the PerformClick() on the button to begin processing. Again, the button works fine, the data is entered as it should be, but the PerformClick() does not fire the click event.
I have a form that works on my local Machine I created into. I have Office 2007 on this machine. I created the Form with the Excel 12 Reference. I move the Entire conetence of the Project folder to my work computer. Which has Office 2003. Do I need to recreate the form with the Excel 11 reference. I could not get the form to work on work computer. IT has a com error. I am acessing the EXE for the debug folder w/in the Bin Folder.
View 7 RepliesReturn statement which is true in an if statement
View 3 Replies