I am working on MS Excel 2000 form and inside VB code, I want to replace following block of code with a loop.
OptionButton1.Value = True
OptionButton2.Value = True
OptionButton3.Value = True[code]....
post an example of a working code to replace 10 lines below with a loop and still be able to set the OptionButton values iteratively ?
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'm using a DynamicJsonModelBinder from a blog post to pass my JSON data from JavaScript to my ASP.NET MVC Controller as a DynamicJsonObject.
Have a look at the blog post: [URL]
I converted it for my project to VB.NET : [URL]
Imports System.Dynamic
Imports System.Web.Helpers
Namespace MyNameSpace
[Code]....
This works. In my controller, I can access my jsonObject like this: obj.ID '123
But I haven't got an idea yet how to iterate through all properties. I can get all member names as a IEnumerable String Collection (obj.GetDynamicMemberNames()), but how do I use the TryGetMember method to access the value of a member ?
I have a VB Web Application with a bunch of textboxes on it in Default.aspx (Using the basic template in Visual Web Designer 2010 Express). I'd like to iterate through those textboxes using some sort of VB solution if at all possible and clear them when the user presses a button. I've tried using something like this:
Dim cControl As Control
For Each cControl in Me.Controls
If cControl Is TextBox Then
[Code].....
[This is a simplified example] I have a collection ("myCollection") in which exists three entries: ("hello", "goodbye", "welcome"). I want to iterate through the collection and if in the collection there is the entry "welcome" I want to take one action, if that entry doesn't exist I want to do something else. Like this (pseudo):
[Code]...
I need some help with a LINQ query in VB.Net, please.[code]This works, and returns me the data I need to work with. Now I want to iterate through the groups, using a For Each construct. like this: For Each x In drivers Next...However, the compiler is barking at me, telling me that the "'x' is not accessible in this context because it is 'Friend'."
View 3 RepliesI have a simple XAML file with a grid in it and textboxes. But when using my code it does not find the textboxes by iteration.
VB.Net:
Dim ctl As FrameworkElement = Me.MainWindow
Code:
Dim ChildrenCount As Integer = VisualTreeHelper.GetChildrenCount(ctl)
'ChildrenCount is always zero
For i As Integer = 0 To ChildrenCount - 1
Dim Child As FrameworkElement = VisualTreeHelper.GetChild(ctl, i)
[Code].....
I have a BindingSource bound to a DataTable.
I use the BS Filter and would like to iterate the filtered dataset of the DataTable using the Bindingsource.
I know I can do a MoveFirst and the MoveNext and each time using the BS.Position get the correct row in the underlying DataTable. But how do I know when the sets ends? I'm sure there must be such a property, but what is it?
if I run the following code,For each itm in MyList Next if the list is nothing i got an error..Is there a better way to deal with list=nothing than using a condion like [code]
View 14 RepliesI want to iterate through an equation and modify a number e.g. Multiply it by 10, where there is one. How do I do this?
View 4 RepliesI have a structure with types ranging from thread's to control.what im looking for is a easy way to iterate through those item like For eachbut i couldn't get for each to workis there a way to do it
View 1 RepliesI am having trouble looping through the following XML file and returning the proper values at each level.
XML File:
<?xml version="1.0"?>
<Domains>
[code]....
I'm debuging an complex calculation object in my project, and I'd like to show its various and many properties in a textbox, to make my tests easier.
Can I do something like
for each p as someKindOfProperty in MyObject1
debug.print(p.name & " - " & debug.print p.value)
textbox1.text = textbox1.text & vbcrlf & p.name & " - " & p.value
next
I'm trying to iterate through each line of a multiline textbox. Something like:
For Each line In Me.txtBox1.Lines
Response.Write line.Text
Next
Is there any neat way to do this, or will I need to write a character-by-character parser and look for carriage returns?
I have List (Of Report). Report has 90 properties. I dont want write them each and every propertiy to get values for properties. Is there any waht to get propeties values from the List
Ex: Dim mReports as new List(Of Reports) mReport = GetReports()
For each mReport as Report In mReports
'Here I want get all properties values without writing property names
next
We have a common component in our source which contains all the enums (approx 300!) for a very large application.Is there any way, using either C# or VB.NET, to iterate through all of them in order to perform an action on each one?
How to iterate all "public string" properties in a .net class is almost relevant but the enums I am dealing with are a mix of types.
I have List (Of Report). Report has 90 properties. I dont want write them each and every propertiy to get values for properties. Is there any waht to get propeties values from the ListEx:
Dim mReports as new List(Of Reports)
mReport = GetReports()
For each mReport as Report In mReports
[code].....
Lets say I have 30 text fields in a Frame on my form, and I want to set them all to disable (so users can't edit them).Is there an easy way to walk through those fields without having to create an array of text fields?
I.E., in ... VB 6, with an array of text fields, I can do something like this:
For i = 0 to 10
txtfield(x).enabled = true.
Next i
Is there something in VB.NET where I won't have to use an array of controls, something like this (assuming all txt fields are in a frame):
[Code]...
Is there some way I can iterate through all available attributes for a given html element
something like:
for each lo_Attrib as attribute in htmlElement.attributes .........
I need an elegant way using VB.Net to iterate through a range of IP addresses when the input will come to my app as a string in this format: 192.168.100.8-10 This range would include 3 addresses: 192.168.100.8, 192.168.100.9, 192.168.100.10. I found a solution in C# that uses the IP Address class that I could probably convert to VB but it seemed to be way too much code for what I need to do. I could definitely use a bunch of string parsing functions but I was hoping someone already had a simple way of doing this.
View 1 RepliesI have created a collection of structures. Each structure, of course, contains fields.
Lets say something like:
Public Structure clientStructure
Public ID As String
Public firstName As String
[Code]....
How can I access a field of a particular structure using for.... each?
That is, how can I retrieve out of the collection (lets say item 5's) firstName, using for...each?
I've done some VB Script and I know C++ fairly intricately. I'm having trouble understanding, and making for loops with if statements perform as expected. What I'm trying to do is iterate through a string and turn all of the "a"s into "c"s "b"s into "d"s and "c"s into "e"s? Here's what I've got thus far and I'm keeping the old string intact.
For i = 0 To first_string.Length - 1
If first_string(i) = "a" Then
second_string = first_string.Replace("a", "c")
ElseIf first_string(i) = "b" Then
[Code] .....
I can do this for loop in my sleep in C++, but it seems that the increment counter i is never what I expect it to be. It should start as 0 (first letter of string) replace whichever of the three it finds, then change to 1 (second letter of the string) and replace whatever it finds there right?
I want to see what the different MessageBoxIcons look like. I found some code that jmc had posted but it only gets the names and values, I want to see the names and the pictures.
View 10 RepliesI asked on SO a few days ago what was the simplest quickest way to build a wrapper around a recently completed database. I took the advice and used sqlmetal to build linq classes around my database design.
Now I am having two problems. One, I don't know LINQ. And, two, I have been shocked to realize how hard it is to learn. I have a book on LINQ (Linq In Action by Manning) and it has helped some but at the end of the day it is going to take me a couple of weeks to get traction and I need to make some progress on my project today.
Click HERE To see my simple database schema. Click HERE to see the vb class that was generated for the schema.
My needs are simple. I have a console app. The main table is the SupplyModel table. Most of the other tables are child tables of the SupplyModel table.
I want to iterate through each of Supply Model records. I want to grab the data for a supply model and then DoStuff with the data. And I also need to iterate through the child records, for each supply model, for example the NumberedInventories and DoStuff with that as well.
For the record I have already written the following code...
Dim _dataContext As DataContext = New DataContext(ConnectionStrings("SupplyModelDB").ConnectionString)
Dim SMs As Table(Of Data.SupplyModels) = _dataContext.GetTable(Of Data.SupplyModels)()
Dim query = From sm In SMs Where sm.SupplyModelID = 1 Select sm
This code is working...I have a query object and I can use ObjectDumper to enumerate and dump the data...but I still can't figure it out...because ObjectDumper uses reflection and other language constructs I don't get. It DOES enumerate both the parent and child data just like I want (when level=2).
I have a ListView with a CheckBox as one of the columns, bound to a boolean property of a custom object. I'm trying to figure out how to iterate through the items in the ListView and check all the checkboxes. What I have so far is below:
XAML:
<ListView x:Name="MyListView" DockPanel.Dock="Top" Height="275" IsSynchronizedWithCurrentItem="True" ItemsSource="{Binding}">
<ListView.View>
[Code].....
I'm building a litle console app that involves a control hierarchy -- there are screens, and inside of screens you can compose controls together.
You can add controls to a screen by declaring member variables (which all inherit from AresControl). The control constructor takes a simple coordinate pair. It looks like this:
Public Class IntroScreen : Inherits AresScreen
'Controls
Private LabelSelect As New LabelControl(72, 0)
[Code]....
This would result in cleaner, convention-based code. But try as I might, I can't get it to work - I can walk the member variables of a type, but I need to walk the member variables of a live object.
We are updating our SQL SERVER 2005 database to reflect the name of our new corporate masters and we need to change the values of the fields.
Once we do so, we will hit those fields with update queries, but right now, my group just needs a listing of the affected tables There are over 250 tables to search, is there a way to iterate through the tables?
I imagine I could search the datatables once I get them, so that part isn't a problem. I just need to know how to set up some code to peek in, record what needs to be changed, close it and move on to the next table.
I've done as much for a single table, but never a load like this.
I am trying to move over vb6 code that worked through arrays of comboboxes.I have a panel that has 18 comboboxes that each need to be populated the same.I first clear the combo boxes and it loops through them, but keeps going until it gets an error.Likewise on sFillLotNO, it adds the first foundrow to each but bombs out when it tries to get the 19th.[code]
View 2 RepliesI have the following class that i use to pull data from a API.here is my callDim myProducts As clsMagentoProduct() = clsMagentoProduct.List(apiURL, sessionId,New Object() {filterOn})
View 2 RepliesMy application is very simple:
In my Resources folder, there are four folders. Each has a couple .png images in them.In my form, I have four checklists and one picturebox.
When my application loads, I want each checklist to populate with the names of the images (one checklist for each folder)
When the user clicks on a checklist, the Picturebox will display the corresponding image.
