'SHEETS For Each ctrl As Control In Me.Controls What am I doing wrong here? When I put in manual text after the line return it fill in but as is it doesn't pick up all the checkboxes under HEADINGS. It does create all the sheets under SHEETS.
Code:
If (TypeOf ctrl Is CheckBox AndAlso CType(ctrl, CheckBox).Checked) AndAlso CType(ctrl, CheckBox).Name.Contains("Sheet") Then
wb.Worksheets("Template").copy(after:=sheet)
[Code]....
I have an arraylist and was wondering how do I loop through and get the values, one at a time.
View 1 Repliesi have a loop that does a simple math function and i need all the values to show up in a single message box. I've got it to when i get individual values minus the start value to show up in separate message boxes but i cant figure out how to consolidate can someone ?
View 1 RepliesI would like to ask a code on how to loop using values in an array.To site an example:
Dim arrTarget(Target1, Target, Target3) as Array
Dim i As Integer
Dim endi As Integer = arrTarget.Max() 'Get the sum of arrTarget index
[code].....
I'm having a bit of trouble looping through an xml file and printing the attributes, so far i have[code]...
View 6 RepliesI am going to get the values of REASON ID from the following codes.Such as 6 in <REASON ID="6" Description="Cash Reason">5 in <REASON ID="5" Description="Check Reason">.[code]
View 4 RepliesI have a List of structure's in my VB.NET program, and I'm looping over them, and change the values of the objects in the list, as follows
Dim retvals As List(Of SomeStruct) = parser.RetrieveData(new_path)
For i As Integer = 0 To retvals.Count - 1 Step 1
dim temp as SomeStruct = retvals(i)
[Code]...
When I look into my List of structs after this loop, none of the values were overwritten. Why? I thought that I had references in my list, so if I change reference A to a struct, then reference B to the same struct should see the changes?
what if you created a pool of numbers: 1 - 21 and then chose a random selection from the pool? Something like the following:[code]This gets rid of those messy if statements and all of those loops.
View 1 RepliesI found this snippet which loops the the old and new values, but I need to figure out the Parameter names that the values are associated with.
Sub DisplayValues(ByVal newValues As OrderedDictionary, ByVal oldValues As OrderedDictionary)
test.Text &= "<br/></br>"
' Iterate through the new and old values. Display the
[Code].....
I have 20+ text boxes that are all named like:
TxtCustom1
TxtCustom2
TxtCustom3
[code].....
How do I cycle through a ComboBox Values list so I can check each value and select one of them efficiently?
Examples in C# or VB.Net welcome.
Is there a way to to combine line's 1 and 2? I only want to loop through a list of the selected items in this listbox. This works just fine, I just wondered if there was a collection of selected values returned that I could use to avoid having to do it this way.
For Loop1 = 0 To MyListBox.Items.Count - 1
If MyListBox.Items(Loop1).Selected = True Then
...
End
Next
how to "loop through a datagrid column to add values to a variable
in VB6 it was something like:
do while not .eof
myvariable = myvariable + datagrid1.collumns(6)
loop
i have 10 radio buttons that have yes/no values. These are options to one question, so need to in the database under 1 record. so - question1 yes, question 1 no, question1 yes and so on. i want to use a while loop or some other loop to take all these values and insert them or update them in the database for that particular question. i m new to programming. the db table is ID, question, Answer. so it will be 1 question1 yes, 2 question1 yes, 3 question1 no.
View 2 Replieshow to, Search for a pixel and replace it well now im stuck on finding out how i could do shades, So im using this code
Dim newImage As Bitmap = New Bitmap(PictureBox1.BackgroundImage)
Dim bmp As Bitmap = DirectCast(PictureBox1.BackgroundImage, Bitmap)
For x As Integer = 0 To bmp.Width - 1[code]....
now how could i have it. say if x,y= any shade of black Then.'Take Action' im making my own paint type tool so im jw how i could paint all black even if it is just 1 digit off from 0,0,0'<- Black' give me some example code on how to loop threw some lines of r,g,b values so i could use that in my function
I have 12 textboxes named TextBox1 to TextBox12. How can I loop through these textboxes to assign and read the values? I.e.:
Dim strTextboxName As String
For i As Integer = 1 To 12
strTextboxName = "TextBox" & i
TextBox{i}.Text = ...... ?????
Next
I have items in a listbox control that I would like to repeatedly (when it gets to the last one, repeat) loop through and set the text to a label.
View 2 RepliesI'm using VB.Net's Excel component to read Excel file, but the performance is totally slow, since it has to loop through cells to get values. Reading a file containing one sheet with 1162 rows and 105 columns (which is small size compared to my general requirement) already costs more than 5 minutes.1. I want to ask if any of you have suggestion on reading such an Excel file with better performance, except OleDB, cuz most compies here have vesion problem?2. Is it normal that it tooks a long time for Excel component to read Excel file, or is it that I implement the code in a wrong way?
View 7 RepliesI have 50 checkboxes for 50 american states. The user can choose all 50 or only 1( so basically any number he wants). Based on his choice, I want to insert or update the table in sql server 2008. e.g-
Color = blue and chk1=check, chk2= check and chk3 = check (chk = checkbox). now the user wants to ad 10 more states to this or remove these 3 and add 5 more. so u basically get the idea. the table in database looks like this - ID Color State_id there is a table called states, so stateid shall come from there. so how do i do a loop insert or update in vb.net?
I have the following code:
[Code]...
The problem I'm facing is that the update happens correctly only for the first of many values. All the other values are calculated and consequently, updated incorrectly in my table. I am almost certain that the looping is what is causing the problem but have been unable to find a way around it.
I'm trying to loop through a column of checkboxes to see how many checked values there are in that column. The user has to have 2; no more, no less than 2, otherwise an error should show up.
Private Sub Form1_FormClosing(ByVal sender As Object, ByVal e As System.Windows.Forms.FormClosingEventArgs) Handles Me.FormClosing
Dim count As Integer = 0
Dim x As Integer = 0
For x = 1 To DataGridView1.RowCount - 1
[Code] ....
The error message still occurs when I have only 2 chosen in that column. I even tried this
If CBool(DataGridView1.Rows(x).Cells(7).Value = Checkstate.checked) Then
I am making my first windows forms application in VS2010 and I am having trouble with arrays. I have code that dim's an array 'TabSiteInfo(2,20)' as a string. Then, I have a Loop that adds records to the array. The problem is that my array is not filling values from the loop. I know VS2010 handles arrays differently, but I have this same code working fine for me in VS2008 ASP.NET application. Below is a sample of the code.
[Code]...
So I am able to get the comboBox populated with the proper list of "clientLocations".
However they all have a valueMember of 0; thus the issue at hand is properly assigning the value of the comboBox items to the database column (which is returned in the dataset) rather than just the name.
Private Sub updateClientLocationComboBox()
'clear list
comboBox_clientLocations_deviceList.Items.Clear()
[Code].....
I'm trying to create a for loop that will display the values (favorite programming languages) a user selects for a listbox.
So far I have this:
Dim selectedLanguages As String = ""
For intLoopIndex As Integer = 0 To languageListBox.Items.Count - 1
[code]....
So far, no matter how many items they select it will display a comma even if only one item is selected, example "C#,"However this is what I need it to do:
1. If the user selects one programming language than it should just printout the selected course with a period right after it. Example: C#.
2. If the user selects two languages it needs to have the text "and" between them followed by a period. Example: VisualBasic.Net and C#.
3. If the user selects three or more languages it needs to seperate them like this for example (again with a period at the end): VisualBasic.Net, C#, and Asp.net.
I am almost there but for some reason I don't find the answer to my issue. Here it goes. In my application I have a form which displays a data grid view with some info I get through XML from a web server. The data grid view have as first column a Check Box colum. The second column have the information I get into a variable (from cells), one by one, to pass it to the sub with the XML command.
What I want to do is to be able to select all the rows and send the cell info of the second row (only for the selected rows) to my sub which will execute once then send the second cell info and execute the sub and so on until all the loop is complete. Currently my code works only if I delete one row at a time (sending the XML code will delete the info in the web server and update the datagridview which in return will remove the item).
[Code]...
Makes the following statement about the code below:
**"The computer evaluates the loop condition in the Do...Loop statment to determine whether the loop instructions should be processed. In this case, the inputsales <> String.Empty condition compares the contenst of the input sales variable to the String.Empty value. As you know the String.Empty value represents a zero length, or empty, string if the inputsales variable is empty, the loop condition evaluates to True and the computer process the loop instructions. *If on the other hand the inputsales variable is not empty, the loop condition evaluates to false and the computer skips over the loop instructions.
Based on the code I think it is the opposite: ...that while the inputsales value is not empty it should evaluate to true and process the loop and if it is empty it should evaluate to false and skip the loop?
See below.
Option Explicit On
Option Strict On
Imports System.Globalization
[CODE]...
I am using vb.net with phpMyAdmin MySql database. While running the piece of code below, the program hangs in the for loop before the variables are assigned values from the data table(dt)...
'Check for appraisal period-----------------------------------------------------------------------
Dim sqlCheckDate As String = "SELECT * FROM tblappraisalsetting where appSetID=(select max(appSetID) from tblappraisalsetting);"
[CODE]................
I am trying to catch an exception but occasionally get an inner exception. I want to output both into a label. I often get Object reference not set to instance of an object if there is no inner exception.
Catch ex As Exception
exError = ex.Message.ToString
If Not ex.InnerException.Message Is Nothing Then
[Code]....
When I debug a program my IDE simply does not catch System.NullReferenceException - execution continues as if there were nothing wrong.Moreover, when I go to the menu Debug/Exceptions System.NullReferenceException is not even in the list(Common Language Runtime Exceptions).
I manually add it (there is the Add button) and I put a checkmark in the 'Thrown' and 'User unhandled' column - now IDE catches it, but after I re-load the project the situation re-appears - and NullReferenceException is not on the list again. What may be wrong?
Update:No, when I step through the code the execution does not continue but exits the current block of code (sub or function). There were no Try...Catch blocks and there is a message: A System.NullReferenceException occured in MSCorlib.dll... But why doesn't the debugger stop at this line?
I have a simple function which tries to get a value from an Obout grid filter column, and if the value is empty, ignores it and moves on. For some reason this code ignore my catch block and always shows a System.FormatException when the input string is empty More bizarre, if I use visual studio's debugger and set a breakpoint on that line, the catch block functions normally (after I continue from that line). I have already confirmed that my Debug | Exceptions | CLR are not set to catch when thrown. I have also confirmed this same behavior in the production version.
[Code]...