I am using VS2008 Pro. I have a simple DVD database built. I'm trying to make a data driven app to store my dvd collection.One of my tables is Actors and is structured as follows.[code]On a form in my app I have a combobox. I'm trying to make it list FirstName LastName ie. Will Smith. I know how to make a query that'll take the LastName and FirstName fields and list it as Actor. I'm having a heck of a time getting it to do that in the combobox as it'll only let me use one field for the display and won't let me use the query I've made.[code]I keep getting some error about schema don't match default query. I know I could simply change the table to only have one field that holds first and last name, but from what I understand that's not proper db practice. I've searched this site and google until I was blue in the face at looking at soulutions that don't match what I'm trying to do.
I like the PHP way of doing things but, it seems I am stuck with using a Collection of Object's to store/retrieve the data I need. I have my Collection loaded with my Objects's and the code to iterate through the collection, my problem is I am unable to retrieve the "key" as it would be called in PHP (I believe in this case it is actually the name of the object).
Consider the following example:
Dim xDoc As XPathDocument = New XPathDocument(fName) Dim xNav As XPathNavigator = xDoc.CreateNavigator()
Dim sender As XPathNodeIterator
[CODE]...
As you can see, I am navigating an XML document, and creating an Object with some Key/Value pairs. The Object would look something like this if it were in JSON:
When I iterate though the Collection I can only get the value of the object, but I need the Key, in this instance I want "name","address1","city","state" to be stored in a variable for each iteration.
I am trying to build a dynamic validator for a data entry application. I want to be able to query a table for the validators relating to the current task and then be able to reference class properties based on the description of the validators returned.
I am designing a desktop application that will be driven by local data. I am trying to determine the best way to accomplish this. The database would contain about 10-12 tables if I use a database and I would imagine no more than 10000 records in any one table (but honestly 99% of users would not have more than 1000 records). I am thinking about using SQL Server Compact.
Is this a good solution? I can certainly include this in my installation, but I am just wondering if anyone knows of a better solution? If this is the best solution, how would you suggest that I create the tables upon deployment? Should I just run "queries" with create table statements in them from my vb application or include a database file or what?
I have been researching for a couple of days now and to no avail. Does Anyone know how to make a custom collection that take advantage of the collection editor? I would like to be able to have 3 Color Values, 1 Boolean and 1 String.
I built a custom class and collection for the class for an app that I'm creating. What would be the best way for me to store it so that it will be available on the next startup of the app? It's a pretty simple class with a few strings, etc.
is possible to store a colletion into database field (ms sql server) is this case, the collection can contains different data types. What data type should be the database field ?
I am supporting one old project built on VB6.0.Can anyone please tell me how to store and retrieve collection from Dictionary.I searched over net but got nothing satisfactory.I really got strucked because of this.Please provide Any Example or Any Link,so that i can do self study.
I have a string array called m_DirFileList and a collection called myFileCollection. I'm trying to loop through the items in the collection and store each one in the string array. It's not working though.
ArialRegular8 | <Corresponding Font Object> ImpactItalic10 | <Corresponding Font Object> TimesRomanRegular12 | <Corresponding Font Object>
These font types come from an external library, the real type is DocumentFont, I prefer not to store just values and recreate the font object later, so I need to store the object, and i want to be able to call Contains() later without looping. like for example Dictionary (of T Key, T Value), is this the best option? Also, to be able to call Contains(), i will have to overload function Contains() using an Interface or this is already built-in in some Collections / Dictionaries when using a String as Key?
I would like to store references to a bunch of structs in a collection. The general scaffolding looks like this:
Structure myStructType Dim prop1 as String Dim prop2 as int End Structure
[Code]....
now this doesn't work, because it's referencing the same memory. What I would really want is the 'pass reference by value' behaviour that is also used for reference types, so that I can easily keep producing more of them.
Is there any way to fix this other than to make the structs into classes? Is this actually a proper way to use structs, or do I have it all wrong?
I am trying to come up with a way to store 3 pieces of information for each employee in the company on a daily basis. So for instance: Day 1: Joe, 8, 80 Day 2: Sam, 10, 90 Day 3: Bill, 5, 40 Day 4: Bob, 8, 40 Day 5: Sue, 2, 50 I am very new to collections and most of the applications that I build are Create, Read, Update and Delete type applications that don't really need arrays so I have almost no experience with either.
This is what I have so far. VB ' Dim iDays As Integer = NumberDaysPerMonth(Date.Now) Dim DayNumber(iDays) As Integer Dim EmployeeRecords As List(Of String) = New List(Of String) For i = 1 To DayNumber.Count - 1 [Code] .....
I am a beginner on Visual Basic but was able to create the 'skeleton' of the application I need to build. Basically, it is an application dedicated to keeping a check on the vinyl I have. When I buy a new record, I want to effectively 'Add New Record' on Visual Basic and be greeted with a page consisting of various forms such as 'Artist' and Title'. Once these are filled in, I want to click 'Enter' and for all that information to be converted to one of the pages within my application.
Here's an easier look at it... There are LPs that have 10" and 12" sections. There are singles that have 7" and 12" sections.
In the 'Add New Record' page I want to also have a drop down list with the above elements in, once 12" LP is selected and all the other forms are filled in and I click 'Enter' - I want the application to send it to the 12" LP section of the application.
I am trying to come up with a way to store 3 pieces of information for each employee in the company on a daily basis. So for instance
Day 1: Joe, 8, 80 Day 2: Sam, 10, 90 Day 3: Bill, 5, 40 Day 4: Bob, 8, 40 Day 5: Sue, 2, 50
most of the applications that I build are Create, Read, Update and Delete type applications that don't really need arrays so I have almost no experience with either.
VB ' Dim iDays As Integer = NumberDaysPerMonth(Date.Now) Dim DayNumber(iDays) As Integer
I am coding a program that will allow the user to input 5 payrolls for Store 1, Store 2, and Store 3. The total of the 5 payrolls are then added together and shown in the respective Store's labels. A total label is also there to add up all the totals into one number. The numbers in the label must be in currency form. My problem is the numbers don't add correctly when I hit calculate. The first two numbers add together, but then after that the number just seems to subtract a random amount.
So far I have this --
Public Class Form1
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click Me.Close() End Sub
my webbrowser navigates to a webpage. I need to store all the links into a collection, I did find the code to do the job (on this forum) and it works, but there is a problem: there are more links on the page than those the code reads, like when i right click on a picture and choose "copy shortcut" I get a link that is not showing when I display the "view source" for the entire page. I can't figure out how to do it.
i need to be able to compare data from a text file with the collection of a combo box.My algorithm currently populates the combo box with data from the text file on the form load event.I have included an update button that updates the combo box collection.[code]
The situation:I have a collection which contains names and I want to be able to add the names to a combo box, i.e.comboBox.Items.AddRange(theCollection)I get an error that 'collection cannot be converted to a one-dimensional array of object'comboBox.Items.AddRange(theCollection.ToString) doesn't work either.
I'm in the process of converting files written in java to vb.net for a window app using vb.net 2005.
In java, they have a way to make a collection "unmodifiable" by calling the collections namespace. This method apparently makes it so the user can't add, remove, clear anything from the collection.[code]...
Returns an unmodifiable view of the specified set. This method allows modules to provide users with "read-only" access to internal sets. Query operations on the returned set "read through" to the specified set, and attempts to modify the returned set, whether direct or via its iterator, result in an UnsupportedOperationException.The returned set will be serializable if the specified set is serializable.
I have an application that uses Dataset.WriteXML to create a small backup before data is syncronized to a data store (less than a meg).This application has worked well for 5 years now, and all of a sudden with the installation of XML 6.0 SP2 the XML document is not working correctly.I have multiple tables within a Dataset (Company, Contact, Notes, etc...)When WriteXML is called, the first table should be Company, however, the first table is being named Contact with the Company Data in it. The Notes table is being called Contact and so forth. In other words it's not giving the correct names to the tables in the XML File.This appears to be a bug, which is causing great distress on all the companies who have been using this program.
I am wanting to make a collection of form instances.I was wondering if the arrayList is a list of pointers (or references) to items added or if a new instance of an object is placed when using the add method.
i.e. if I had: Public Shared forms as Arraylist = new Arraylist Then if I called forms.add me from an instance of a form would it create a pointer or reference to the instance or generate a whole new one?
How can I data scrub a collection of data? I am working with existing VB.NET code for a Windows Application that uses StreamWriter and Serializer to output an XML document of transaction data. Code below.
Private TransactionFile As ProjectSchema.TransactionFile Dim Serializer As New Xml.Serialization.XmlSerializer(GetType(ProjectSchema.TransactionFile)) Dim Writer As TextWriter Dim FilePath As String Writer = New StreamWriter(FilePath)
I'm trying to construct a database driven VB.Net app that pulls a list of registered accounts from a database and displays the usernames of throes accounts in menu, so the user can select one and a new form open (where they work with it).what I have so far is the constructor for the MDI parent window.[code]What I want to happen is when a user clicks on the context menu a new MDI child form is created and the data in user is passed, however because AddressOf doesn't like passing data this doesn't work.I've looked at delegates and landa expressions but don't think either of them do what I need, the other option is to make my own subclass of the ContextMenuStrip class, which 1) handles the clicks the way I want to and 2) sounds like a nightmare.Before I launch into what I think will be a hell of a lot of work, am I missing something? is their a simple way to do what I want to do? or if not will sub-classing ContextMenuStrip work and if not any ideas as to what will (and if it will, any ideas as to how to start learning how to do that)
I'm another newbie with VB (2010) so please bear with me. I am attempting to make a method that is event driven by data threads on the Ethernet port. Simply put, the method is to wait until a data thread from a "Control By Web" 5-input device sends an "information update" data packet to the application, with the application then processing the information. This application is on a private, well controlled network, with no access to the internet. I have a method that is working right now reading data packets when invoked with a timer (see code below) but I really need it to be event driven.
' this is added at the top of the class Dim tcplistener As New TcpListener(IPAddress.Any, ip_port) 'this is added in the "form1_load" module
So. I'm making a tool for an online game called Shin Megami Tensei.In this game you can fuse Demons, depending on what family of the first demon you fuse and the second demon you fuse come from, and their levels, the outcome changes.This is unimportant though.
However, the application is driven by a database, the application consists of a Demonic Compendium (Index of the demons, including race, family, stats, levels etc.).This application is meant for usage by the community playing SMT, and here is the problem; a person without Microsoft SQL Server cannot run this application.I can't ask the community, some of which aren't very techy, to install Microsoft SQL Server 2005 Express Edition just in order to run this program.
You see my problem?Is there a way to get the program running on other computers that doesn't have MS SQL Server installed?
