I have a bunch of code with IF..., when this code is run ListBox1.SetSelected(j + 1, True) it select the next value but j is still 0 so the next ListBox1.SetSelected(j + 1, True) will select the same value. How can i update j?[code].....
View 16 RepliesOkay I've been wondering about this for a while now, but whenever you assign variable values to objects they tend to just become references to the original object
For example:
Dim copiedCollection As ListBox.ObjectCollection = ListBox1.Items
For Each L As String In copiedCollection
If L = "Goodbye" Then ListBox1.Items.Remove(L)
Next
As soon as it encounters the string "Goodbye" and removes the item from the listbox, the program will throw an error saying the the collection (copiedCollection) has been modified. How can I make copiedCollection a true copy (not a reference) to the Listbox1.Items collection?
Return statement which is true in an if statement
View 3 RepliesI'm using the following statement to search an Excel file. It specifies Sheet1$ and I would like to do a search that included another 12 sheets. Is there syntax that allows a search across several sheets?
View 13 RepliesI design a database in datbase.mdb which have a table name Fuel.The primary key Column Name is ID which data type is AutoNumber (Long Integer)User select the ID number and i run he following statement but error occurEID= combo1.text.trim()userid= Convert.ToInt64(EID)Strsql= Select a1,a2 from Fuel where ID= 'userID'ERROR is Creteria DATA TYPE MISMATCH or No record foundPlease
View 4 RepliesI am developing a code to open up a .dbf file and append data to a access database.Here is my code for opening the .dbf file.
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim constr As String = "Provider=VFPOLEDB.1;Data Source=F:JUNO4.dbf;Persist Security Info=False;"
Dim con = New OleDbConnection(constr)
Dim da = New OleDbDataAdapter("Select UNIQUE_ID FROM JUNO4", con)
[code]....
this code gives an empty datagrid.
what is the propert way to use Case statement for;When user click on a button it will show different picture everytime.I do not want a random generator. Just show pictures in order
View 10 Repliesi have a list box which is populated with folder names via directoryinfo, and i have a second listbox which is also populated with folder names from a user selected folder. So listbox1 is populated like this:
[Code]...
I'm in the middle of making a battleship game, and I'm trying to get picture boxes .visible=True based on the coordinates (that have already been given a nice Try/Catch/Finally error handeling block) of the ships. Example: I have picture boxes in a grid formation that are all red, and my naming convention for them is picR00 for the coordinates (0,0), picR01 for the coordinates (0,1)... et al. Because I'm using a(10,10) for my boolean array, I want the stuff thats false (not marked), those coordinates' red picture box to become visible, and the true have the green ones become visible. Here is what i have so far:
Dim a(10, 10) As Boolean, b(10, 10) As Boolean, c As Integer, x As Integer, y As Integer, ox As Integer, oy As Integer
For c = 1 To 3
[Code].....
I am use to coding in php and everything does not need to evaluate to true or falst in an if statement. I have this [code] How would I make that return true or false?
View 3 RepliesI don't see why this code is not running. I want the form to be hided if the statement is true, but what it does is only open the other form but not hide this one.
Dim fileExists As Boolean
fileExists = My.Computer.FileSystem.FileExists("C: est est.tx")
If fileExists = True Then[code].....
I'm not reciving any errors at all this is Still my homework on the Compound Intrest and it's due tommarow and well an if statement isn't working
Private Sub btnCalc_Click(ByVal sender As Object, _
ByVal e As EventArgs) Handles btnCalc.Click
Dim decAmount As Decimal = 0D
[Code].....
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?
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 have a form that contains multiple conditional or if statements on several defferent for controls.
Example: Radio Buttons, TextBoxes and CheckBoxes.
I am intending to create an order form(demo) where the user can select multiple products.
I have a default order number that changes by one everytime an order is successful.
An order is only successful if all the information on the form is entered correctly.
My question is where do I insert the code for the order number?
Basically for the order number I have a counter that count by increment of one if an order is successful.
Meaning when the user hit place order, and all the infromation is right, then the order numer goes to 1 from zero.
Where do I add the condition for the order number since all the fields must first be completed.
Do I have to create a whole line of if else statements?
have a table with following fields
Emp_id varchar(50)
Emp_Name varchar(50)
Emp_surname varchar(50)
[code].....
I need to use a SELECT statement to select all data under a column name (like all employee names) and then to add the values to a listbox.
I usderstand that the select statement must be:
"SELECT * FROM EmployeeTable WHERE EmployeeNames LIKE *" (at least I think)
but then what? combobox1.fill ("EmployeesTable") ?
I have a table which contains a list of products for a company. They input data about how much stock they have and also the level at which they want to be reminded that they need to order new stock.
[Code]...
I want to list all the true results in a form which the user is then able to navigate through. What would be the best way to go about doing this?
i am new here. So my first question: How do i make, so people can upload a .txt file with a word on each line.- and then it add all the words to the listbox? I want to import a proxy list..
View 17 RepliesI have 2 listboxes, and i can't get out what i need to do for the method. The method is, if a item in listbox1 is selected, it will select the same line in listbox2 and same in reverse. there can be many many items.
View 5 RepliesSo, to save the 2 listboxes i use:[code]But how i open the file and see the words again in the listboxes?
View 1 Repliesas title says. and if it has the same values, delete one of them and add (2)
so itll be like: - before the filter:
[Code]....
I have a CheckedListBox with some stuff in it and a ListBox with nothing in it. I'm using this code to get the Selected one in CheckedListBox1 to ListBox1 and splitting it:
[Code]....
i'm trying to add some items into a specific ColumnHeader in ListBox1. If i have 3 columns, and i want to add the information written in Textbox1 to ColumnHeader2, how can i do it?
I add using:
ListView1.Items.Add("blah blah blah")
But that adds it into the first column...
with the following code which gets stucked on the line of reader = Cmd.ExecuteReader(). It says the SqlException was unhandled (An expression of non-boolean type specified in a context where a condition is expected, near '7/2/2010'.)
[Code]...
I have successfuly connected to a database and have create a select statement (with access) which works most of the time except when im trying to perform a where statement with a date:
strEmployeeDepartmentLocation = Application.StartupPath
con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = " & strEmployeeDepartmentLocation & "swineFlu.mdb"
strSQLSelectQuery2 = "SELECT NumberOfCase FROM table1 WHERE Date = 21/04/2009;"
i dont no if im writing it in the wrong format or what but it dont seem to bring back any data
I want to populate a listview and leave selected records that are true
I have a DB record which is ID int, desc varchar, selected boolean.
I have tried the code below
LVProducts is a Listview and DS is a dataset
CODE:
I have a datatable and I would like to get the MAX number from this table where Term Number (first Column) is a certain value. If my datatable is declared as dtMyTable, I'm assuming I need to use dtMyTable.Select(), but I'm not sure if this is the best way.
View 2 RepliesI'm using Vb2005 and Db MS access Is it possible to use tow Select in same sql Statement like this example:
Code:
"Select....Select......."
I have 2 dropdown lists, 1 label & 1 textbox.on selection of 'product categories' @ 1st ddl, 2nd ddl displays all product categories.question is, how may i display the product category id @ the label, and name @ the textbox, on load/selection of 2nd ddl?[code]....
View 3 Replies