Make A Data Driven App To Store Dvd Collection
May 12, 2009
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.
View 3 Replies
ADVERTISEMENT
Feb 8, 2012
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:
{"name":"John Smith","address1":"123 Anywhere St.","city":"This City","state":"FL"}
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.
View 2 Replies
Feb 17, 2010
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.
ex. Validator = "person/firstname"
How do I get to _clsPerson.FirstName?
View 2 Replies
Jun 28, 2011
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?
View 1 Replies
Feb 8, 2010
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.
View 15 Replies
Mar 29, 2011
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.
View 12 Replies
Mar 24, 2010
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 ?
View 4 Replies
Dec 2, 2011
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.
View 1 Replies
Sep 2, 2009
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.
[code]...
View 2 Replies
Jun 10, 2012
I need to Store Objects with Key like:
Key: <Fontname & FontSize> / Object: <Font Object>
Example content:
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?
View 3 Replies
Oct 28, 2011
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?
View 1 Replies
Aug 25, 2010
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] .....
View 4 Replies
Jun 17, 2012
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.
View 11 Replies
Feb 26, 2009
We use a custom collection derived from CollectionBase to store our Business objects
[Code]...
View 3 Replies
Feb 27, 2006
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
[code]....
View 19 Replies
Mar 22, 2012
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
[CODE[...
View 14 Replies
Sep 11, 2010
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.
View 3 Replies
Apr 14, 2011
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]
View 1 Replies
Sep 11, 2009
I am new to VB.net. I want to read and input file and store that data to an SQL Server database. Do you have an sample code that do such?
View 1 Replies
Mar 2, 2012
I have a modbus TCP device that I have managed to connected to through my VB source code.
I want to poll (continueously read) data from certain registers of the device, and store the polled data in a file (text,csv, excel).
View 1 Replies
Mar 24, 2009
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.
View 3 Replies
Sep 27, 2011
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.
View 12 Replies
Feb 14, 2011
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.
View 3 Replies
Dec 12, 2011
i just want to know how to get a template and store it in a data base without using data set
View 1 Replies
Nov 11, 2010
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?
View 2 Replies
Jun 2, 2011
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)
[Code]...
View 1 Replies
Jan 21, 2009
What is a event driven application.
View 2 Replies
Nov 15, 2009
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)
View 1 Replies
Aug 23, 2011
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
[code]....
View 1 Replies
Jan 22, 2010
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?
View 5 Replies
