I am iterating through rows in a datagridview in the following manner
[Code]...
Why are the column methods and properties not all available in this manner to set individual datagridview cells properties? The only options available for the variable,
Say I have three lists containing multiple objects. Lets also assume they each contain the same number of items. [code]...
Now say I have a dataGridView that I have defined as having three columns. Is there a way to assign the contents of each of the lists to each of the three columns (e.g. column 1 = myList1, column 2 = myList2, etc.) without iterating through each of the lists? I know I could define a dataTable, create the columns, and iterate through each of the lists...then associate the dataTable to the dataGridView's dataSource. However, I don't want to iterate through the lists since in my real application, these lists are large and the iteration would take too long. I'm just wondering how to assign these lists to a column in a dataTable in bulk.
I have an XML file, with a rather large structure. I'm pulling several entities out of it throughout several systems, and its dynamically updated once a day. I'm using a Linq Query that is exhibiting odd behavior, its only returning if the first entry in the site tag matches the search-pattern. If its number 2 or 3, it fails to return anything. Why would this behave that way?
The following function written in VB handles pulling the data
Public Function xmlSchoolListBySite() As IEnumerable
Dim doc As XDocument = loadXML()
Dim loadedPrograms As IEnumerable(Of XElement) = From c In doc.Descendants("Organization") _
Where c.Descendants("site").Value = MySite.Site.s_Url _ 'contains Result.RawURL.tostring() formatted
Select c.Element("Title")
[Code]...
I am trying to write XML that looks like this. It works so far, but when I get to the <rooms> node I can only output one.
<house>
<id>1</id>
<rooms>Living</rooms>
[code].....
I have two arraylists that contains links in one and the root url in the other. Sometimes the lists dont equal in number and I would like to iterate through the links list and if it contains a matching root url add it to a third list but also avoid any duplicates. I tried this but am not getting consistent results.
For Each link As String In urls
For Each part As String In post
If part.Contains(link) Then
[code]....
Perhaps there is another way; basically the part in post is a link to a page and contains the root url( which is link in urls). After extracting all these I need to ensure the 2 lists match.
I have several label boxes on my design form that all share the naming convention lbl_#.text where # ranges from 1 to 60. I want to make a loop that iterates through each lbl_#.text adding some incremental value, let's say multiples of 2 for this question's theoretical purpose.Something such that the end result would amount to the following:
lbl_1.text = "2"
lbl_2.text = "4"
lbl_3.text = "6"
lbl_60.text = "120"
I'm not sure how to access each of these labels through the coding side, I only know how to explicitly mention each label and assign a value :/
I am writing a simple XML web service and want to return raw XML. I am doing this by creating a string literal that represents the XML. My data source is a SqlDataReader object that contains the results of a stored proc call. The way I am doing it right now is by using a while loop and reading values from the item property like so :
[Code]...
I have a list like this
[Code]...
How can I iterate the list with ForEach to get one string with the emails like this [URL]
If I have a complex structure which contains properties which are both simple and complex types, how can I iterate over all the properties of this structure and any child properties which are not simple types?
I have a complex type called file, which contains lots of string properties and some which are other complex types which contain similar structures, eventually the whole structure breaks down into strings.
At the moment my code looks like this:
Dim file As New File
Dim props() As PropertyInfo = file.GetType.GetProperties()
_propList = New CheckBoxList
[Code].....
This works, but it is ugly and I am not at all happy with certain chunks, specifically the type comparisons to establish if this is a date, string, decimal or boolean which are the potential low level types which I want to get out.
In C# it would seem these type comparisons are easier, but i seem to have to create an instance of a given type to be able to use GetType to return its type.
Can somebody show me how to loop through days between two DateTimes in VB?
View 3 RepliesI have a structure "xyz" with 3 string objects in it. "foo" "bar" and "abc" I want to iterate through the structure and compare the names of the objects.
Structure xyz
dim foo as string
dim bar as string
dim abc as string
End Structure
[code]....
I have an asp program that needs to validate data for textboxes that are dynamically created and put into a placeholder. Each textbox has to have a value when the user hits the Save button. I have the following code:
Dim testCheck As Boolean = True
For Each txt As TextBox In pnlTests.Controls
If txt.Text = "" Then
[Code].....
I have two arraylists that contains links in one and the root url in the other. Sometimes the lists dont equal in number and I would like to iterate through the links list and if it contains a matching root url add it to a third list but also avoid any duplicates. I tried this but am not getting consistent results.
[Code]...
I'm new here, but I always exhaust myself in research before I go asking for help with my code. What I'm actually doing is porting a program I wrote in AutoIT proprietary code over to vb by hand. I've really come far and have figured out out how to read/write data to an XML file, which was the biggest challenge. I'm having a little bit of a rough spot with iterating nodelist data and then adding it to a listview in order.Here's what I have within a sub that begins to pull data from the file.
[Code]...
This adds data a row at a time, which is what I want. But look at the data I'm feeding it, node.innertext.I have to iterate the specific nodelist before I can use node.innertext. Putting .subitems.add in the iteration just results in a huge mess. I thought about using a function to return the data and then drop the function name in there, but whenever I iterate within the function it only ever returns the first item (it iterates only once even though there are more than one interations). Hopefully someone can point me in the right direction, I don't need to be spoonfed the answer.
I want to do something different on the last KeyValuePair of the Dictionary I'm iterating on.
For Each item In collection
If ItsTheLastItem
DoX()
[code].....
How do I go about looping through all the controls within a container, and all the controls in the container of a containing control, and so on.
[code]...
The following only retrieves -Panel and none of the other controlsFor Each cntrl As Control In Me.Controls Next How can I retrieve them all in a For Each loop without an If/Then for every level in the stack?
[code]...
This is so far the best method I found of doing this.
I have the follow code in my program where I hit a SQLCe database to append the results into a list. That part works, but instead of exiting the function 'QueryDB' it goes to the else statement and runs the function again, which will return a null value. I designed it this way becuase I wanted to check to make sure the database is open before I try to execute the SQL statement, and if it's not open, call the method to open it and run through the function again.
[Code]...
i have a problem. I have database with a tableadpater. i want to get the userid with this tableadapter.
Dim dsGN As New ForumTableAdapters.Message2TableAdapter
Dim dtBetrieb As Data.DataTable = dsGN.GetUserIdFromThisMessage(ConversationID)
For Each objRow As dsGN.Message2Row In dtBetrieb.Rows
mystring = objRow.UserId.ToString
Next
i get the error "dsGN.Message2Row is not defined" The Name ob my table in the database is "Message"
I'm working on a VB.NET program that will automatically backup my work to my FTP server. So far I am able to upload a single file, by specifying a file name using this:
[Code]...
I've got a panel (pnlExpenses) with several labels and textboxes on it. I want the program to go through the dollar amounts entered in the textboxes and put the subtotal in a class level variable (dcSumOfExpenses). However, when the debugger passes through this Sub, objControl always shows a value of Nothing, and the Count of pnlExpenses.Controls always shows a zero. What is my code missing? The panel was added to a tabpage at design time, and the labels and textboxes were laid on top of the panel. Do I need to do something more to establish the panel's controls as a collection?
Private Sub SumExpenses()
dcSumOfExpenses = 0
Dim objControl As Control
[Code]......
I seem to be having some trouble finding anything to help me iterate through objects in an embedded resource file.What I have got, is a bunch of resource files that each have a library of sound wav files.What I'm trying to do is cycle through them all and add their name to something like a list box.I found a couple of snippets online that do this but for external resources. Here is what they do.
' Create a ResXResourceReader for the file items.resx.
Dim rsxr As ResXResourceReader
rsxr = New ResXResourceReader("Samples\Kicks.resx")
[code]....
1. It still needs a phisical file in the debug folder (I have them in a folder called samples within the debug folder.)
2. It gives me this error.QuoteResX file Could not find a part of the path 'C:\Users\sed10711\Desktop\Sequencer Interface\Sequencer Mock Interface\bin\resources\kicks\kickdrum1.wav'. Line 123, position 5. cannot be parsed.
I have two arraylists that contains links in one and the root url in the other. Sometimes the lists dont equal in number and I would like to iterate through the links list and if it contains a matching root url add it to a third list but also avoid any duplicates. I tried this but am not getting consistent results.
[Code]....
I want to iterate through the records in an SQLCompact 3.5 data table and combine the field values into a string.The database file is connected to the project.I created a dataset that contains the tables from the database.If I drag and drop any datasource table as a grid onto a form I can view the data.[code]I have tried using the tableadapter.Ran into errors when the Date2 value = DBNull, never could get around those.I've tried dataview and datareader on the dataset.datatable but never could get these to load any data rows.I could sure use an uncomplicated unconvoluted way to simply read the rows of data in a database datatable.
View 7 RepliesI've been working on trying to get a tree view (replica of a directory) parsed into file paths (i.e "Node/ChildNode/ChildNode2/Childnode3") etc.
I currently have this Which is getting there. I can pull out all of the child nodes, but have no way to actually determine which belongs to which parent.
VB.NET
Private Sub Recurse(ByVal node As TreeNode)
Listview1.items.add(node.Text)
Dim Node2 As TreeNode
[Code]....
this is general to any operation calling an SQL server, or anything requiring an open connection at that.
Say I have anywhere from 20 to 1000 Select calls to make for each item in data being looped. For each step, I'll select from sql, store data locally in a struct, then proceed. This is not a very expensive call, so should I keep the connection open for the entire loop? Or should I open and close every step?
How expensive in run time is opening a connection? I would think it'd be better to keep the connection open, but would like to get the correct response for this.
I am wondering if it is possible to iterate using columns of datatable.
I have tried something like this:
Dim myCol As New DataColumn
Dim myRow As DataRow = Nothing
Dim myCell As New DataGridCell
[Code]....
I have a number of idential repeaters, and I need to iterate through all of the items. I currently have:
For Each item In rpt1.Items
.do some stuff
Next[code]....
Is there a simple way to reduce this to a single For Each ... Next loop?
Edit: There are a number of local vars involved in "do some stuff", which is why I can't just pass the item into a function - the call would have to include about 8 ByRef params.
I need to place objects of various types in a "collection" and be able to:
1) Change the value of a property on any of the objects by using it's key.
2) Read the objects in the order they were placed in the "collection"
3) Read the objects in the reverse order they were placed in the "collection"
My findings so far:
1) Collection won't work because Item property is read only
2) It seems that Hashtable and dictionary won't work because I cannot iterate through them in reverse order.
3) Stack won't work for obvious reasons.
Is there a collection like data structure that has satisfies the requirements?
I am just getting back into VB.NET, and I need to ask a question. I am doing a project for a class which requires iterating through 360 items in a scrollable control that will pause every so often. I am thinking I might use either a ListView or GridView, but I am not sure if this is the right way to go or if I need to use a different control all together.
View 3 RepliesI am just can't get my head around this.I've got this Regex:
(?<=Photo:)(.+?)(?=Stock)|(?<=Stock Code:)(.+?)(?=Make:)|(?<=Make:)(.+?)(?=Model:)|(?<=Model:)(.+?)(?=Year:)|(?<=Year:)(.+?)(?=Price:)|(?<=Price:)(.+?)(?=Description:)|(?<=Description:)(.+?)(?=Photo:)|(?<=Description:)(.+?)(?=Page:)
[code]....
