I'm currently on a VB.NET project and wish to use a KeyValuePair to facilitate a reverse lookup. I've found a great example in C# here: [URL], however I am having a small problem converting to VB.NET (both manually and using a translator (online carlosag)). For example the syntax I would expect in the Add method is as follows:
[Code]....
How can I check a new KeyValuePair against an existing list of KeyValuePair ? I want to compare for a condition to include or exclude the item. I am using vb.net 3.5
it is a nested For loop and I am deleting a datarow on the result of the condition
args = (existing list of KeyValuePAir)
For Each datarow As DataRow In ds.Tables(0).Rows
Dim args2 As KeyValuePair(Of Integer, Integer) = New KeyValuePair(Of Integer, Integer)(datarow.Item("Integer1"), datarow.Item("Integer2"))
what I want to do here is see if args2 is already contained in args if not I would delete the datarow , but I also need to search the datarow multiple times
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?
To be able to sort a dictionary by value I'm using this code:
Dim idCurrentJobs As IDictionary(Of String, Int32) = New Dictionary(Of String, Int32)
'The string in the dictionary represents a jobname and the integer is a counter for how many jobs im currently are running in the application'
idCurrentJobs.Add("JobName1", 2)
[code]....
I need to reverse a string of words without using the reverse function. This is what I have so far, BUT it only shows the last two letters. For example: if i type "John" it will only give me "ho"
Public Class frmReverse
Dim original As String
Dim New1 As String
[code]....
I need to this without using things we haven't seen in class.
i was wondering if anyone body has used Chilkat Zip Component or any Chilkat compression in there project before.I am currently developing a small project used for drive and directory backups.i am looking at using a 7Zip Or Tar Compression as Chilkat supports theses.i was wondering if a Drive backup is capable or will it crash and burn?
View 2 RepliesI have a ListView capable of displaying files in all available views (Large Icon, Small Icon, Tile, List, Details). Now I am wondering how to properly use the SmallImagelist and LargeImagelist for the small and large icons...the ListView is actually a modified listview (inheriting from ListView), using a modified ListViewItemCollection.In this custom ListViewItemCollection I use the Add override function to add a few details to my ListViewItem:
vb.net Public Overrides Function Add(ByVal value As System.Windows.Forms.ListViewItem) As System.Windows.Forms.ListViewItem
Dim file As clsTexture = TryCast(value, clsTexture)
If file IsNot Nothing Then
[Code]...
I realize it is a pretty complex post to read and will probably not get very many answers, but I really want to make the most of my Listviews...Of course, one work around is to just always use the LargeIcon which then gets scaled down automatically when the SmallImagelist is used but I am pretty sure there are icons that are very different in Large or Small view...
I want to create a converter that will be capable of converting a .doc file into an .exe file: How to proceed?
View 7 Repliesi can get a value, a key out of a list by using index ,key or value parameters but a kvp as object ?nattelip
View 13 Repliesstill working on my game, but a college classmate said that I need to use databases instead of text files...so I'm wanting to know, what databases does visual studios 2010 provide for you to use...what code line should I use to create/write to/read from a databasew, and how do/should I create a database table/refer to it??
I would love to provide code, but I'm both using my cell, and don't have access to my computer right now due to it not being accessale due to not having the ability to have it hooked up right now...got new floors and don't have it plugged in yet/set up again...
I want to group items from a linq query under a header, so that for each header I have a list of objects that match the header title. I assumed the solution would be to use ToDictionary to convert the objects, but this allows only one object per "group" (or dictionary key). I assumed I could create the dictionary of type (String, List Of()), but I can't figure out how to write it. As an example I have written a simplified version below.
[Code]...
Is it possible to use a custom structure in place of a KeyValuePair? [code]
View 3 RepliesGiven the following vb.net class:
Friend Class PairCollection(Of TKey, TValue)
Inherits List(Of KeyValuePair(Of TKey, TValue))
Public Overloads Sub Add(ByVal key As TKey, ByVal value As TValue)
Me.Add(New KeyValuePair(Of TKey, TValue)(key, value))
End Sub
[Code]...
I am trying to bind a New List(Of KeyValuePair(Of String, Integer)) to a listView
Currently, I have a code off:
Dim TestList As List(Of KeyValuePair(Of String, Integer))
For Each key in GetTPDesc (Which is a list of strings)
TestList.Add(New KeyValuePair(Of String, Integer)(GetTPDesc.ToString, 0))
[code].....
I have created a class with a function in it. I have a collection of data I want to pass back. I tried an arraylist first. Now I am trying to use a dictionary. My problem is that it creates the dictionary ok, but I am only get the last row of data from my
Function GetWeldAuditInfo(ByVal ResourceId
As
String,
ByVal VendorId
[CODE].........................
I have the following object:
countDictionary As Dictionary(of Category, Dictionary(of Date, Integer))
The Class has a Enumeration Property. For the purposes of demonstration, I'll call it MasterCategory.I have been trying to get out an object that looks like the following:
groupedCountDictionary As Dictionary(of MasterCategory, Dictionary(of Date, Integer)
The best result I could get was:
Lookup(of MasterCategory, Dictionary(of Date, Integer))
From:
countDictionary.ToLookup(Function(o) o.Key.MasterCategory, Function(o) o.Value)
Which results in a IEnumerable (Of Dictionary(of Date, Integer)) for each MasterCategory value.However, I need that IEnumerable of Dictionary flattened to one dictionary with all the integers summed (total counts) for each date. I then tried to use various selects and group bys (from numerous stackoverflow posts) to "flatten" it, but my efforts have fallen short.
Current Code
[Category Class]
- MasterCategory As Enum
- Name As String etc
[code]....
I have the array dimensioned as public to the form. I populate the array on Form1_Load.When I click the button btnReversingAnArray the first time all are sorted in reverse except for Wendy and it is the last item shown. ie..(The book I am even shows an image of the list Box and their example also shows Wendy as the last item)
Richard
Michelle
Jay
Harriet
Wendy
Then I do nothing else except I click the button btnReversingAnArray again and then it displays correctly.
Wendy
Richard
Michelle
[code]....
I have created a Dictionary class (MyDictionary for the example). I am currently trying to pass MyDictionary into a function, filter it into a new instance of MyDictionary and pass this new instance into another method. When I am attempting to create the second instance from the filtered first instance of MyDictionary via Lambda Expressions and the ToDictionary Method, I am getting the following error:
Unable to cast object of type 'System.Collections.Generic.Dictionary`2[System.Int32,System.String]' to type 'MyDictionary'. I have simplified the example and recreated it in LINQPad and am getting the same error.
Here's the simplified version of my code:
[Code]...
I use VS2005 and I have just started working with the dictionary in particular the Dictionary.ContainsKey method. At the bottom of the page in the msdn library it says the following in the community content How to make sure that Contains functions properly.
View 3 RepliesThis code:
vb Dim s As String = strContents '<a global variable) Dim currentPos As Int64 = 0 Dim endPos As Int64 = strContents.Length - 1 '// A dictionary, used to count the frequencies Dim characterCounter As New Dictionary(Of [String], Int64)() While currentPos <> endPos '//
[CODE]...
Gives this error: Value of type 'System.Collections.Generic.KeyValuePair(Of String, Long)' cannot be converted to 'System.Collections.DictionaryEntry'.
I have a datagridviewcomboboxcolumn which has its .DataPropertyName set to a int field, its .DisplayMember set to a nvarchar field and its .ValueMember set to a int field on a lookup table. I have captured a dataerror which states that the control is trying to push the .DisplayMember(nvarchar) to the .DataPropertyName(int) field. When I load existing data it works fine. When I try to leave the datagridviewcomboboxcolumn after selecting a different value in it or leave it when I add a new row, I get the error. What am I doing wrong?
View 1 RepliesSimple Code lookup to get Description I have a static list of Street Type Abbreviations and their associated Street Type Descriptions: RD to Road. I have the complete list needed. There are 37 elements in the list - 37 Street Type Abbreviations with their associated Descriptions. The lookup will only happen once. The input lookup field is in a single field: stType.
[Code]...
i am using the LookupEdit control from DevExpress fairly heavily in my projects. It is like a combobox, but it is bound to a datasource and can display multiple columns from the datasource. A single column is identified as the "value" column and a single column is identified as the "Display" column.
I use the LookupEdit control on my forms to give users a pick-list of appropriate values for a particulat database field. Each field has its own table in the database holding said values, commonly referred to as a lookup table, and each lookup table is used as the datasource for each paired LookupEdit control. Of course when a form is being filled-in by the user this works great. And it works good when the user opens a saved record into the form and I set the EditValue of the LookupEdit based on the value stored in the database. Pretty basic stuff right?
Now here is the problem... Let's say a lookup value is no longer an appropriate entry and so it is removed from the lookup table. Say I sell cars and one of the fields in the Cars table is Color. And I have a lookup table called CarColors and the selections are: Black, White, Red, and Silver. Now let's say we sold some Red cars in the past, but now we no longer carry Red as an option and we probably never will. So I remove "Red" from my lookup table, and now when I load an old Order into my form the LookupEdit for Car Color value now shows NULL. What is the best way to handle this situation? ProcessNewValue? Set NullText property? Use a bit field in my lookup table for IsActive, and set to FALSE for Red instead of deleting it?
Obviuosly I want to retain the historical values while maintaining a currently valid lookup list. And I know this question goes deeper as there are probably database design considerations like whether or not to put a constraint on the foreign key relationship between the lookup and child table, etc... I should also mentioin I am using LookupEdit control rather than a ComboBox becasue a lot of my lookups have other information like Description, Sort Order, or are coded and thus require a multiple column display.
I have a datagridview control on a form that is filled programatically (dataadapter, dataset ) from a database table (access).
Some of the columns in this table are foreign keys to other tables. Is it possible to have these
columns as combo box columns so the values can be selected directly from the other tables?
I have an Access 2003/2007 application that pulls computer names from my network along with their last know TCPIP address. This data is created by another application. I am trying to use the IP Adresses to install software via a push application that accepts a list of IP Addresses.My app has a history table of every comuter that has been checked to see if the software is installed. I use the Fully Qualified Domain Name to make this verification. I then populate my text file with the IP address of the computers that have not been installed.This all works well if the last know IP address is still valid for that computer.What I am trying to find is a function that I can pass the FQDN to and have it do a NetBios lookup to return the current IP Address from our DNS Servers so I can be sure that the IP addresses I am populating the text file with match the FQDNs of the computers I am trying to push the software to.I found some info on System.Managment.dll. For some reason Access will not let me add it to my library references.Does anyone know of a standard library function I can use to achive this.[code]
View 2 RepliesI am trying to setup a macro to lookup a value. Its very basic, I am trying setup a sheet to build tariff requests for mobile phone deals. so on sheet i will have lots of macro boxes that simply pubulate a table with a value on sheet 2.
Its basically so a sales person can go onto the excel sheet click click click and it will produce a table of all the product on each mobile number connection.
I have a sql query that looks like this
SELECT SUM(A) AS expr1 FROM TREES WHERE (b = ?) AND (c = ?) and (d = ?)
How do I map the parameters? Since its a sum, I cant select multiple rows.
I am converting a DTS update lookup to an SSIS lookup with an update query. So far it doesn't seem to work.
OLD DTS ACTIVE X CODE:
value = DTSLookups("apple").Execute(DTSSource("ID2"))
SQL Query in DTS:
UPDATE TABLE1 SET STAMP="TEST" WHERE (ID = ?)
In SSIS:
Create a lookup, use same above query, and I get an error if I click on column: "Parameter information cannot be derived from SQL statements. Set parameter information before preparing command"
IS there anyway to accomplish this in SSIS with a lookup? Or is there a better way?
in item Search form i can search the item that i want, if i found the item that i need i will select the entire row and fill this row in DataGridView in frmSWSfromGrid.i been able to achieved this same scenario but it uses textboxes.the ff. COde
frm Dialog code
Public Property DepartmentID() As String
Get
[code].....
I am almost finished building my application. All the data need is being inputted from various locations. I have a form that is suppose to consolidate all this data into a specific format. There are 47 fields that have to be populated and/or calculated based on two fields, the Username and a date range (this part is done). I was trying to set each of the TextBoxes equal to the SQLCommand that would return the proper value, but i am not calling it correctly. Would somebody please take look, is there something i am missing, do i need to write it in a function? I have had to use the Select statement itself in a couple of filters so I'm pretty sure that is correct, but i need help getting it to run the sqlcommand.[code]
View 16 Replies