Store And Represent Data?
May 31, 2011
I'm creating a program that outputs Quotations (and other information relating to these 1. What is the BEST way to read/write from a database (I only really know how to use Access but if XML or SQL would be better, I'm willing to learn). The database needs to be stored and accessed from the same state every time that the program opens. I've tried multiple different ways, both through DataAdapters (in code) to doing it through connecting the database through the Visual Studio GUI. Neither have seemed to work. Other people have told me that using DataAdapters and such aren't the best way, but no one has been able to tell me what this 'best way' is. Also, I need to somehow be able to link pictures in the database - apparently it's not easy to do in SQL?[code]...
View 5 Replies
ADVERTISEMENT
Apr 15, 2012
"Create a class called Invoice that a hardware store might use to represent an invoice for an item sold at the store. An Invoice should include four pieces of information as instance variables--a part number (type String), a part description (type String), a quantity of the item being purchased (type Integer) and a price per item (Type Integer). Your class should have a constructor that initialize for each of the four instance variables. Provide a property for each instance variable. If the quantity is not positive it should be set to zero. If the price per item is not positive it should be set to zero."
I attached the code I have. obj is underlined and says "Argument not specified for parameter 'Invoice4' of the 'Public Sub New (Invoice1 As Object, Invoice2 As Object, Invoice3 As Object, Invoice4 As Object)' and so the program won't run. What am I doing wrong?
Public Class Form1
Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs)
Dim obj1 As New Invoice(Val(TextBox1.Text))
TextBox1.Text &= obj1.Invoice1 & vbNewLine
TextBox1.Text &= obj1.Invoice2 & vbNewLine
TextBox1.Text &= obj1.Invoice3 & vbNewLine
TextBox1.Text &= obj1.Invoice4 & vbNewLine
[CODE]...
View 14 Replies
Feb 8, 2012
i can retrieve the data from the DB and put it in a vector and then, vector in a JTable, to display data in a tabular format in java, all i wanted to know is there any similar way in vb dotnet?
View 4 Replies
Apr 1, 2009
I'm trying to set up a CLASS to represent a data stream.This is a newbie question so if the answer is obvious, please excuse me.Several of the data items are multiples which I would normally represent as an Array element.For example, in the code below, the element SolarNameplate has up to 10 instances, so I'd like to use array notation.I get errors, and it doesn't work, so I assume I can't do it like below.
QUESTIONS : 1 - is it possible to use an array element in a class ?
2 - is there another way to achieve what I want ?
Public Class SM1PS01
Private _Projid As String '... name or number of project
Private _LogoFile As String '... file containing customer logo[code]...........
View 18 Replies
Apr 27, 2009
What suggestions do people have for a timeslot data structure? I have a number of activities and I'm planning to display them in a datagrid with days as columns and timeslots as rows. This suggests to me a timeslot data structure with 5 properties for the five days (the columns) for every value I want to use e.g. a timeslot ID and the number of slots left.
So.
Property Day1ID
Property Day1Slots
Property Day2ID
Property Day2Slots
Property Day3ID
Property Day4Slots
etc
Then each TimeSlot structure would be for a specific time. say 9:00 and another for each hour after that. Then I'd have a list of timeslot structures that will auto bind against the datagrid. I'm exploring new ground here and as you can see I'm not very clear on what/how to do it?
View 2 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, 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
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
Jun 1, 2011
I'm trying to convert old VB.NET code into C# and I'm not sure about the current line and what it means really.
[Code]....
View 5 Replies
Jun 29, 2010
I know you can put unicode character codes in a VB.Net string like this: str = Chr(&H0030) & "More text"..I would like to know how I can put the char code right into the string literal so I can use unicode symbols from the designer view.
View 5 Replies
May 9, 2011
Below is the code I am using to restrict user from entering any other characters except for the predefined ones. But using my code I cannot hit backspace.
How to include backspace also ?
Dim s As String = "0123456789$"
If s.IndexOf(e.KeyChar) = -1 Then
e.Handled = True
End If
View 3 Replies
Nov 19, 2010
I am reading a pot that has a range of 1000 to -887.I need to convert that numeric value to represent 0 to 1024Where 1000=0 and -887 = 1024.
View 4 Replies
Oct 5, 2009
I have a parcel post assignment, and i have three textboxes that represent height, width, and length. here are my questions1. how do i decalre them as integer? do i decalre the textboxes or the labels that represent them?2. how do i multiply all three together and multiply the total by 4pence and add 20p?
View 6 Replies
Jan 14, 2011
I'm pondering a design that will require zooming. My intention was to use pictureboxes to represent a variety of items, and I have the code written to draw on those pictureboxes, as needed. However, there will be many pictureboxes on the form at any one time, though only a portion of them will be visible. That shouldn't be a problem, necessarily, as there isn't any issue with having controls that are not on the visible area of the screen. My issue is that when the user rolls the mouse wheel forward or back, the image will have to scroll in or out, which means that the location and size of the pictureboxes will have to scale relative to the point where the mouse is located.
Technically, this would be more easily accomplished using graphics directly, since I can use ScaleTransforms and...uh...one other, to do the scaling. However, I would prefer to stick with the pictureboxes because I will be doing lots of drag and drop work with them (dragging things into and out of them), and that code is already written. If I were to change that to use rectangles and circles drawn dynamically and scaled dynamically, I'd have to use some kind of hit testing to figure out which object I dragged or dropped onto, and where. Therefore, switching away from pictureboxes would require a fair amount of recoding. There really shouldn't be a problem scaling and translating the controls on the form, but rather than writing the math behind that, I was wondering if there were any built-in tools that will do it for me or will help with the process.
View 9 Replies
Mar 2, 2010
In a tic tac toe game I'm working on I have 2 dictionaries (plyrPairs and cmptrPairs) In the program there is a procedure that is used numerous times. The procedure varies with the dictionary that it calls. I'd like declare a variable in a sub procedure that will represent these two different dictionaries. Here is what I have:
Here are the two enumerations:
vb.net
' Assign values to player pairs enumeration
Private Enum plyrPairsList
empty = 0
[Code].....
View 5 Replies
Aug 10, 2009
I am creating a Point of Sale software for a small company I work for. I am a beginner with Visual Studio and have just stumbled my way around. I have completed the GUI and would like to start assigning code. The problem I am having is assigning numbers to a keypad on the screen. I would like each button to represent numbers like on a calulator of keypad. When these are pressed they need to input into TextBox2.
View 6 Replies
Jan 26, 2010
I'm working in VB.Net developing data logging software. I've developed classes implementing a common interface that works with many of the data loggers my company produces. These classes handle the low-level hardware interfacing and expose common methods for accessing the data logger's records.
[Code]...
View 1 Replies
Mar 25, 2010
i am working with serial communication in vb.i need to know how to get &h1 to be &ho1 to represent the byte o1 in hex or 0000 0001 in binary.i cant remeber how to parse the byte and represent it with two characters instead of one.
View 8 Replies
Jul 31, 2011
I hope this is the correct place to obtain a little bit of advice for a program I am looking to produce in visual basic 2010.
I currently work as a design engineer designing press tools and a lot of our designs are similer just maybe a feature, length, diameter change etc. So the design principles are the same for each product.
What I am aiming to do is program the 3D design package so that 80% of the tool design can be done using the program etc.
Now the enquiry I have is where would the best place to hold the standard data be?
For instance each press has a maximum blank diameter, shutt height, bores diameters in the bed and likewise each product type has design features with the same calculations such as length, pierce etc.
I have done a bit of reading and I have found that data can be stored into text files, xml files and databases etc or hard coded into the program.
I am looking to allow new presses to be added so the user would need to add new shutt heuights, blank size etc but the tooling would have to be unqiue dependent on the typs of stage. So I am wondering to store this information would a database be the best option even though the data will not be continually updated more a place for it to be retrived from excpet under failry rare circumstances.
View 3 Replies
Jul 24, 2009
I was thinking about using an access database to store the data but I would like to know if there is a better way of storing data?
View 4 Replies
Jul 6, 2011
I have a theater seating project. I am creating checkboxes in a panel that represent the seats. Each of the rows has a label on it, giving it a row number.When a user clicks one of the check boxes, I need to be able to determine what row the seat was that they clicked on. I then use the row number to determine the price of the seat. I am stumped!! I can't seem to figure out how to get the row number associated with the seat. Here is my where I am configuring the seats:
Private Sub ConfigureSeating()
intTheaterID = CInt(frmTheaterTickets.cboTheater.SelectedItem)
Dim strSQL As String
[code].....
View 5 Replies
Apr 28, 2009
I'm trying to format a string to represent a date in a specific format using the Format function but it's return odd results.
Here's an example:
Dim s as String = "01/01/2000"
Dim result as String = ""
result = Format(s, "dd-mmm-yyyy")
result equals "dd-mmm-yyyy" (the format string) very strange.
View 2 Replies
Mar 9, 2009
I have a TableLayoutPanel that is 1 column wide. In it, I make UserControls to represent components of a color formula.When a user chooses a formula on the left, I call "TableLayoutPanel.Controls.Clear" and then using the data from the formula, set the number of rows and create X many new user controls in a loop and TableLayoutPanel.Controls.Add them.
The problem is, if one keeps this screen open and selects through roughly 60 to 70 different formulas, eventually, without warning, the program will crash in an unhandled exception: Error creating window handle. (There is no debugger breakpoint)What's causing this? Is it a disposal problem? Should I be doing something other than TableLayoutPanel.Controls.Clear? Would you handle building the objects differently? I'm including a screenshot of the screen in question (you can see the usercontrols vertically on the right) and the error box that comes up.
View 1 Replies
May 13, 2010
I have a very large number of tables with data in the following format:
A X Y Z
1 0-2 0-13 0-1
2 3-5 14 2-4
3 6-9 15-16 5-10
In other words, there is a variable (call it A) with a single value that corresponds to a range of values in the other variables (call them X, Y, and Z).My program needs to accept user text input of values of X, Y, Z, etc. and then match each to the corresponding value of A.Example: User enters 4 in the X text box; program determines that if X=4, A=2.Again, we're talking about tables and tables of data in this format. Unaware of a better method, I have been using arrays.
Example:
Dim a() as double = {1,1,1,2,2,2,3,3,3,3...}
Dim x() as double = {0,1,2,3,4,5,6,7,8,9,10...}
Note how I had to artificially deal with variable A so that the index of each score corresponds to the index of the matching X variable.It is this modification of the variables that is taking forever. There has to be a better way! Hypothetically, what I need is the ability to do something like this:
Dim a() as double = {1,2,3,4...}
dim x() as double = {0 to 2, 3 to 5, 6 to 9...}
Is there a way to represent a range of values at a single index of an array, such as my hypothetical example above? This would save me hours of re-shaping the data to make the arrays work.
View 6 Replies
Dec 19, 2009
I'm writing an app in vb.net and was wondering wath the best way to store/retrieve data was?
View 5 Replies
Mar 31, 2011
I've just finished an application which does everything I want within the Visual Studio environment now I need a way to store the data the user creates but I've never had to do it before and am a bit lost. I've spent days trying to use XML to do this but to no avail mainly cos my classes use ArrayLists as properties and it gets a bit beyond me. I've been told that ArrayLists were not the best choice for this and would be prepared to change my design if need be if I thought the end to this problem was in sight.
View 11 Replies
Apr 21, 2011
I am reading data from wordpad one by one which records the sale of grocery item by barcode. I want to store it in memory so that after reading the whole file I can calculate the total number of the same items sold by comparing the bar code.
View 2 Replies
May 21, 2010
I'm making a program that uses XML to store data and I'm having problems retrieving the data. Here's an example of how I'm storing data:
<?xml version="1.0" encoding="utf-8"?>
<main>
<category>
[Code].....
View 4 Replies
