| Author |
my project |
gemleeus
Member
Posts: 20
Location: georgia
Joined: 26.09.05 |
| Posted on 29-09-2005 09:04 |
|
|
|
first of all hello to the community. I would like to know if anyone could help me get started with a small creation i'm trying to produce with limnor? |
|
| Author |
RE: my project |
yw
Administrator
Posts: 670
Location: ***
Joined: 23.06.05 |
| Posted on 29-09-2005 12:17 |
|
|
|
Sure. Please post your questions here. I guess you have some "how to..." questions? |
|
| Author |
RE: my project |
gemleeus
Member
Posts: 20
Location: georgia
Joined: 26.09.05 |
| Posted on 29-09-2005 13:28 |
|
|
|
yes if you can help that would be great. I'm trying to create a program where someone could put a vehicle identification number ( vin # ) in a box and then click a go to button and another screen would come up showing all the relavent information about the cars vin # that was typed in the box. so i figure i need to create a small box for putting in the vin #, and a button to click once the vin is put in and then a screen to put the vin information on once you click the button, how to link it all together. |
|
| Author |
RE: my project |
yw
Administrator
Posts: 670
Location: ***
Joined: 23.06.05 |
| Posted on 29-09-2005 16:42 |
|
|
First where should we save the car information? A small database to save all car information will make things easier because then we may use data-binding feature to save lots of programming efforts. If we decide to use a database then the next question is to decide what car information we want to save. vin#, maker, model, ...,
Once you decide that, you may open Project Explorer window, select Databases and click "New" button to create a database connection. It will allow you to create a Microsoft Access database for it. You may create a Car table to hold all car information. |
|
| Author |
RE: my project |
gemleeus
Member
Posts: 20
Location: georgia
Joined: 26.09.05 |
| Posted on 29-09-2005 17:43 |
|
|
|
ok, i don't know where to save the info. the car information will be extensive, all options etc. that came on the car. then i will be dealing with multiple vin #'s. each vin # input will need to create a different set of information. for instance one vin # may be 1234 and another 4321 and each will need to produce a different set of results because the numbers will mean different things. so i will check the database connection window for holding the car information. then we will need to link these together. |
|
| Author |
RE: my project |
yw
Administrator
Posts: 670
Location: ***
Joined: 23.06.05 |
| Posted on 29-09-2005 18:08 |
|
|
Example of a Car table:
Vin# Maker Color Model Year
-------------------------------------
1234 GM Blue Buick 1999
1235 Ford White Explorer 2000
....
-------------------------------------
Once you have such a table then you may add endless Vin# and car info into it.
You may use DataTable to show and edit/add car info.
You may use TextBox, Labels, Picture Boxes and set their DataBind property to point to each piece of information.
Lots of possibilities to satisfy your design. |
|
| Author |
RE: my project |
yw
Administrator
Posts: 670
Location: ***
Joined: 23.06.05 |
| Posted on 29-09-2005 18:10 |
|
|
|
Manually input all car info into the database is a lot of work. If you have a existing car info data source then it can be imported into the database. |
|
| Author |
RE: my project |
gemleeus
Member
Posts: 20
Location: georgia
Joined: 26.09.05 |
| Posted on 29-09-2005 20:41 |
|
|
|
so i will input all the vehicle information into this database and once someone enters a paticular vin #, all the info i have entered into this database pertaining to that particular vin # will be displayed once they click the button? thats what i'm looking for. and yes i believe i will have to enter all this information manually as the info is scattered about different places on the web and of course i want to arrange the info in my own way. right now it will only pertain to 1969 model camaros and once i get that down i will begin adding other vehicles. so i need to enter limnor and search for this database connection window and follow prompts? |
|
| Author |
RE: my project |
yw
Administrator
Posts: 670
Location: ***
Joined: 23.06.05 |
| Posted on 29-09-2005 23:52 |
|
|
Yes, exactly. Click a button and all info for that vin# will be displayed.
If you never create a database before, here are some concept you may need to know: every database contains many tables. Each table has many fields (or columns). Each field is one piece of information you want to hold in the table. For example, for the Car table, vin# is one field, Maker can be another field, Year is another field, and so on. You may decide what fields you want the the Car table to have. After you giving a file name for the database, click "Change schema" button, it will allow you to add Tables and add fields to each table.
If you never create a database before then you may tell me all the fields you want for this Car table, I will create such a table for you and you can start adding car info into it. |
|
| Author |
RE: my project |
gemleeus
Member
Posts: 20
Location: georgia
Joined: 26.09.05 |
| Posted on 30-09-2005 05:41 |
|
|
|
ok. i will do that. let me ask you this. when we create this database table and someone puts in their vin # and clicks the button and the database table comes up with all the relevent info about that vin # will the table show all those columns and lines in it, kinda like i've seen with an excel spreadsheet? |
|
| Author |
RE: my project |
yw
Administrator
Posts: 670
Location: ***
Joined: 23.06.05 |
| Posted on 30-09-2005 17:12 |
|
|
spreadsheet style display is only needed for displaying many vin# and their related info. For example you can use such a display to do manual data entry: type in new vin# and related data or modify exist data. New data and modifications will be saved to the database.
For your requirement, you just need to display info for one vin#. You can still use spreadsheet style display. But there will be just one row. A more attrctive screen layout design could be to use Labels to make a "Form" to show the info for one single vin# |
|
| Author |
RE: my project |
gemleeus
Member
Posts: 20
Location: georgia
Joined: 26.09.05 |
| Posted on 01-10-2005 08:35 |
|
|
I see. i don't want it to look like a spreadsheet, i would like it to look like when you visit a web page no lines etc. when someone clicks that button after they insert their vin # the page it brings them to has a blank background with of course the information on it i provide arranged on that page in a certain way. some text at the top introducing the software then in the middle the vin # info and at the bottom some kind of closing text. like arrangment on a web page but it can't be a web page because everyone would have to go to a particular url to use this. it needs to be bundled as a piece of software that can be dowloaded and used and i could create updates to this software as more vehicle information is added down the road if i choose. so maybe we need to use labels in order to make a form type of page?
thank you for all your responses, you've been very helpful!
Edited by gemleeus on 01-10-2005 08:35 |
|
| Author |
RE: my project |
yw
Administrator
Posts: 670
Location: ***
Joined: 23.06.05 |
| Posted on 01-10-2005 14:27 |
|
|
|
Yes, you may use Labels, TextBoxes, PictureBoxes, etc., to design your forms. They all can be diectly linked to a DataQuery or DataTable to automatically show data from database. But first you need to have a database. Do you have questions on how to create a database and its tables? Do you want me to create a database for you? |
|
| Author |
RE: my project |
gemleeus
Member
Posts: 20
Location: georgia
Joined: 26.09.05 |
| Posted on 01-10-2005 14:48 |
|
|
yes that would be great. i will provide you with one vin # and the relevent information each digit and or letter will represent. if thats what you would like, if not let me know what type of info you need and we'll get started.
thanks. |
|
| Author |
RE: my project |
yw
Administrator
Posts: 670
Location: ***
Joined: 23.06.05 |
| Posted on 01-10-2005 16:10 |
|
|
Please tell me what are the car info you want. I image you will want Year, Maker, Color, etc. Give examples of data. Also indicate how maximum number of characters for each piece of info. For example:
------------------------------------------------------------------------------------------
Vin#(20 characters) Maker (20 characters) Color Model (30 characters) Year
------------------------------------------------------------------------------------------
1234 GM Blue Buick 1999
------------------------------------------------------------------------------------------- |
|
| Author |
RE: my project |
gemleeus
Member
Posts: 20
Location: georgia
Joined: 26.09.05 |
| Posted on 01-10-2005 17:14 |
|
|
1 = Chevrolet
2 = Camaro
3 = 6-cylinder engine
4 = 8-cylinder engine
37 = coupe body
67 = convertible body
7 = 1967 model
8 = 1968 model
9 = 1969 model
N = Norwood, OH assembly plant
L = Los Angeles, CA assembly plant
ok, the chart above represents the first part of a vin # on camaros built between 1967 and 1969.
an example of ones vin # that could be typed in: 124679L and after this part would be a series of numbers which would tell you the sequence the car was built. the sequence part i'm not concerned with because that info in the vin # is self explanatory.
so the 124679L, by the chart above tells us this: the 1 means its a chevrolet
the 2 means its a camaro
the 4 an 8 cylinder enigne
the 67 its a convertible
the 9 its a 1969 model
the letter L means built in los
angeles, ca assy plant.
so as you can see when someone types in that vin # i want them to click that button and all this information will come up on another page. this is just a small inkling of what i'm trying to accomplish, but if you could compile some type of small program or database with this i could learn from it.
Edited by gemleeus on 01-10-2005 17:15 |
|
| Author |
RE: my project |
yw
Administrator
Posts: 670
Location: ***
Joined: 23.06.05 |
| Posted on 01-10-2005 18:57 |
|
|
By this info, I misunderstood your original intention. So you want to build a program to interpret vin#. In that case, please fill in the vin# data:
--------------------------------------------------------------------------------
vin digits possible values for the digit and their meaning
--------------------------------------------------------------------------------
vin digit 1: 1=Chevrolet (what else?)
vin digit 2: 2= Camaro (what else?)
vin digit 3: 3 = 6-cylinder engine; 4 = 8-cylinder engine (what else?)
vin digit 4 and 5: 37 = coupe body; 67 = convertible body (what else?)
vin digit 6: 7 = 1967 model;8 = 1968 model;9 = 1969 model (what else?)
vin digit 7: N = Norwood, OH assembly plant;L = Los Angeles, CA assembly plant;(what else?)
-------------------------------------------------------
Is this interpretation correct?
|
|
| Author |
RE: my project |
gemleeus
Member
Posts: 20
Location: georgia
Joined: 26.09.05 |
| Posted on 01-10-2005 23:57 |
|
|
|
you've got it correct, there is nothing else, thats all those digits mean for a 1969 camaro. that is all the vin # tells you about the car. I know it doesn't seem like much, but right now I just want to get a basic understanding of what i'm doing and go from there, like adding more vehicles chevrolet makes and then information about the different other makes out there. after i get this correct there are other pieces of information about the cars i can compile, like color, interior color, transmission type, rear end type and so on, and do basically the same thing with that info as i'm doing with the vin #. |
|
| Author |
RE: my project |
Cloudsail
Member
Posts: 1
Location:
Joined: 04.07.05 |
| Posted on 02-10-2005 03:04 |
|
|
I found following information about vin. It is not the same as you explained:
1st character- Identifies the country in which the vehicle was manufactured.
For example: U.S.A.(1or4), Canada(2), Mexico(3), Japan(J), Korea(K), England(S), Germany(W), Italy(Z)
2nd character- Identifies the manufacturer. For example; Audi(A),
BMW( , Buick(4), Cadillac(6), Chevrolet(1), Chrysler(C), Dodge(,
Ford(F), GM Canada(7), General Motors(G), Honda(H), Jaquar(A), Lincoln(L), Mercedes Benz(D), Mercury(M), Nissan(N), Oldsmobile(3), Pontiac(2or5), Plymouth(P), Saturn(8), Toyota(T), VW(V), Volvo(V).
3rd character- Identifies vehicle type or manufacturing division.
4th to 8th characters- Identifies vehicle features such as body style, engine type, model, series, etc.
9th character- Identifies VIN accuracy as check digit.
10th character- Identifies the model year. For example: 1988(J), 1989(K), 1990(L), 1991(M), 1992(N), 1993(P), 1994(R), 1995(S), 1996(T),
1997(V), 1998(W), 1999(X), 2000(Y)------2001(1), 2002(2), 2003(3)
11th character- Identifies the assembly plant for the vehicle.
12th to 17th characters- Identifies the sequence of the vehicle for production
as it rolled of the manufacturers assembly line. |
|
| Author |
RE: my project |
gemleeus
Member
Posts: 20
Location: georgia
Joined: 26.09.05 |
| Posted on 02-10-2005 08:34 |
|
|
|
that kind of vin # started in the 70's i believe. i'm only interested in the muscle car era 60's thru 1971. |
|
