Sensors, Information Management Database And Hardware
Oct 19, 2011
I just wanted to know if visual basic 6.0 or Visual Basic 2010 can be programmed to create a system that uses both smart card reader and sensors (photoelectric sensors) and be recorded their information into a information management database for date and time log.
Example:
1. A personnel will have to tag their smart card to the smart card reader. It will then be checked from the database and approved if their record is available in the database.
2. He will then have the access to enter and take a particular stuff from a rack (which has the sensor) guarding on each item on the rack. If the personnel take the item. It will then be logged into the database for the 1. personnel I.D, 2. item position on the rack, 3. time and date when the item is collected.
Question:
1. What hardware are needed to incorporate all this (smart card reader and sensors to database)? a controller perhaps? terminal for all the sensors?
2. What software to create the information management database so an authorized personnel may check the event history? also software to incorporate with the sensors? will it have to be on separate software or all can be done in the package given in VB6 or VB2010 or an additional software to be used?
3. Does MSComm Control have any relevance on this subject? All i know is what it does (vaguely) and no idea how to implement it.
View 7 Replies
ADVERTISEMENT
Jan 28, 2010
I'm developing a standslone system for my school project. I'm developing an audio management system which allow user to add audio files itself into database together with the audio information such as artist name and album year. I just started it few days ago and face some problems.. my song in the playlist wont continue to play after 1 finished and i need some idea on how to store the audio files into database ... in blob types may be?
Heres the screenshot and codes
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles bt_add.Click
[CODE]............................
View 2 Replies
Jul 21, 2011
I've been assigned to do some report analysis in a management information system.My question is, do you think it's a efficient way to gather datas from SQL, with the use of basic syntax and have them manipulated through my code in VB.NET?(I'm more skilled with this kind of execution, but it takes a lot of data calling from the database)Or should I just do the advance way of inner jointing or more likely a stored procedure?
View 2 Replies
Jun 9, 2011
The program is currently trying to pull information from three different database tables and compiling the information onto one screen, to do this i am using three different connections and a function to handle the data at each stage. The issue is as my code hits PageLoadStage of "2" and runs the QueryDatabase() Function i am encountering an error of: "OleDB exception unhandled: No value given for one or more of the required parameters." This occurs on line 15 of the first code snippet. Can anyone explain this and/or identify any code issues if that is the cause.
[Code]...
View 8 Replies
Nov 5, 2009
Using Vb.net 2003 Asp.net 1.1 Sql Server2005 Express Vs.Net 7.1. I have Vb.Net Standard and there is no Web Set Up with this version. I have FTP things along time ago but not asp just basic stuff. I have read about xcopy,copy project, I have XP and IE that I can FTP from. I also have to put a database up from SQL Managment Studio. I need to know HOW WHAT WHEN WHERE on how to do this right. This is an interactive site that I made, very similar to a Forum like this site. Do I just upload the dll.
I don't want my source code available for everyone to see, do I have to obfucate it if I am using [url] as a host. The site can't really be down all the time, I have read that I could work on thesite while it is up but I believe I will have to have all the source files up and open.
View 2 Replies
Feb 14, 2010
create database management system in vb 2008
View 2 Replies
Jan 28, 2011
A year or so back I made a database management program in vb.net and now its out dated and i want to start from scratch, since I wasn't very good at vb.net at that time most of it is hacked together in one single file.Now i want some tips in making these kind of programs.I've heard of something called a data access layer. What is it and Should I use It ? Is it a Class or interface (I don't know what interfaces do yet but they should be to hard)?
[Code]...
View 1 Replies
Jul 15, 2009
i tried finding some links from this forum , however still can't get my problem solved. Anybody who has done some projects on stimulating images using sensor of an accelerometer..kindly step forward to assist..Below are the part of code which i can only move the car from right to left..I thought of making the car move in different directions (diagonal ways, up down etc.
[Code]...
View 1 Replies
May 24, 2010
Please how can i publish an application created in vb.net along with a database which i created in SQL Management Studio?
View 4 Replies
May 20, 2009
1 how to work a robot with vb ?
2 how do i recieve input from robot sensors ?
3 how do i send output commands to the robot ?
4 can you refer me to sources about the above ?
5 can vb interact with the software tobotbasic ?
6 is there a vb procedure for recieving text strings from another software that runs at the same time as a vb application ( like a revese getkeys()
7 can vb send commands to a robot via bluetooth if so how ?
View 9 Replies
Oct 28, 2009
I am working on a small personal database management program and am at the stage where I am trying to search the MS Access database given a user input.I need to look up lets say the "customer" ID and the update other records associated with that customer. Here is what I have so far.
[Code]...
View 14 Replies
Dec 18, 2009
how to incorporate a PIC with VB.
I`m trying to find out the steps needed to achieve that, i`m i correct?
1) i need to find a PIC that is suitable for my project (to handle wireless motion sensors)?
2) I need to write the code for the PIC? (does the manufacture of the PIC provides an environment to write the assembly language?)
3) Then i need to write the vb code?
4) Finally to use a serial port to create a communication between VB and PIC. Also are their any all ready made PIC`s that can support VB code direct without the need of writing the assembly code?
View 16 Replies
Jun 22, 2009
I was thinking is there anyway VB2005 can be done if I create an animation( car) such that its movement can me opearted using another external component(example a sensor).
View 2 Replies
Mar 9, 2009
I've developed an application in VB2008 express and have installed it to another PC. The installation has put the mdf file in c:documents and settingsuserappsdata.I want to attach this with SQL Server Management studio but when I try to browse to the file in order to attach it, I find I can't browse further then C:documents and settingsuser.
View 3 Replies
Jul 6, 2010
I am an absolute newbie in both oracle and visual basic. I have covered some basics as tutorials and want to develop a database using Visual basic as front end and Oracle as back end. I have Visual Studio 2008 installed and I will use Visual Basic from that. I also have Oracle 10g express edition installed on my system.
View 6 Replies
May 8, 2012
We are thinking about changing our current database system, MS Access 2007 front end and MS SQL Server 2005 backend to using a higher level language such as Visual Basic .Net. I wonder if this is the BEST solution for data management? Currently, among others, we have two big database programs that handle more than two hundred users and it's crashed often. That's the reason we think about changing to something that can handle these database programs effectively preferably using MS technology such as .Net.
View 12 Replies
May 28, 2012
I am trying to get an Email and password from a database and use them as a log in (not acces database) i tryed rdr = mycommand.ExcuteReader but that dosent work [code]...
View 2 Replies
Oct 25, 2010
Is there an external gadget that i can use say a phone or any other to get information from my database?
View 4 Replies
May 26, 2010
I want to get information from database and then i want to assign this information to label's text or textbox. I wrote sql codes and i used OleDbDataAdapter.
SELECT soruno, soru, cevap1, cevap2, cevap3, cevap4
FROM quiz
WHERE (soruno = ?)
Then i wrote codes that OleDbDataAdapter1.SelectCommand.Parameters.Add("soruno", OleDb.OleDbType.Integer).Value = 3
View 4 Replies
Jul 22, 2009
I need save some informations, in a table (date, hour, number of points...) I use Vb .NET 2008.
View 5 Replies
Nov 11, 2010
I'm trying to insert information from a form to an Access database. I get the error: Object reference not set to an instance of an object. It points the line: dsWHNewRow = WHds.Tables("WeightHeight").NewRow() in the btnAdd_Click Sub. I'm sure I'm missing something but don't know what to look for.
Public Class WeightHeightPopup
Dim WHcon As New OleDb.OleDbConnection
Dim dbWHProvider As String[code].......
View 4 Replies
Mar 24, 2012
I have a database with about 10 records - each with their own ID. I'm trying to add a new record, and to do this I decided to have a text box on my application form show what the next ID will be. Here's the code I am using:
Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click
'get EmployeeID from the textbox:
Dim intEmployeeID As Int16 = Val(txtEmployeeID.Text) + 1
'store the emlpoyee
[code]....
The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.How would I go about finding the maximum ID in the database and then adding 1 to it so I can display it in the text box?
View 5 Replies
Apr 27, 2010
does anyone know how to make it that when you type something in to a text box the click a button called add to then have what you typed in added to a checked list box and then have it that when you click another button called add that the information in the checked list box which has been checked is then added to a database.would it be better to make th information entered in to the text box be saved to a text document and then have the checked box get its information from the text file if so does any one know how to do that.
View 3 Replies
May 9, 2011
I want to retreive customer information from microsoft sql server database using just his/her user id onto a web form.
View 1 Replies
May 7, 2011
I am working on login and registration page in vb express 2010. I have connected access 2007 database with my project and when I register as a user, it stores information to the database successfully and I can log in with that id as well. But when I close that project and reopen it, the same exact id won't work and the information in the database disappears.
View 1 Replies
Dec 16, 2011
I'm working with the project that require save all user personal information in one table when they login the my system. The problem is too many users login my system per day, it's very hard to manage. So, I want to add one more function which can specify one user information. My solution is filter that user and copy to other table, the problem is I don't know how to do that. how can I delete all information in a table in database?
View 3 Replies
Apr 4, 2012
i am new to working with databases, I have done some of my own research and have been adding and regtrieving records without trouble. Now I need to retrieve a specific record based on a selection made by the user. I found that the way to do it is with the WHERE statement and from examples i have seen the code below should be how it is done:[code]The problem I am having is that when i try to run the sub i get the error:Syntax error (missing operator) in query expression 'Show Name = Strictly Hip Hop'.The show name is in the database because that is where the data is retrieved from. All I am trying to do is populate a text box with information from the Host column when the Show Name column is the same as the selected item in the combo box.
View 7 Replies
Jan 20, 2011
I have a problem getting the right information to a ComboBox.I have a table in SQL Server that contains a list of names.I want to get those names to appear in my ComboBoxes shown in the picture. (DONE)I also want the list of names to decrease by the names already used in other ComboBoxes in that Form...
EXAMPLE:So, lets say I have a list:
Name_1
Name_2
Name_3
[code]....
In the Form, there are 10 ComboBoxes.I choose the Name_1 for ComboBox1, Name_2 for ComboBox2 and Name_3 for ComboBox3.The options available for all other ComboBoxes should be Name_4 ... Name_6.If all of the 6 names are filled, the rest of the ComboBoxes should have no option to insert into them...
View 4 Replies
Aug 15, 2011
I am populating a datagridview with information from a database. One of the columns is a monetary amount. Right now my datagridview columns just show a double.
View 2 Replies
Mar 15, 2009
I'm new to VB.NET and having problem with retrieving information from a MySQL database, when populating the datagrid. [code]
View 17 Replies
