Create Program Where Database Is In Different PC?
Apr 17, 2010
"Employee Monitoring Program"
Source: Visual Studio 2008 Pro
Language: Visual Basic
I already Installed the components came with the VS2008 Installer (Sql etc)
The idea of the program:
The program will create a personal information of every employee including the userid and password that will be use to log in (user validation) .The application will monitor the login / logout and save the task of every employee.he application will save/store the daily activity task done by the employee (login/logout time,notes, and other task assign). the information will be saved in a database which can be access by the application in every PC within the network (LAN).The application will be installed in different PC within a network(LAN). The number of PC is not yet confirmed (5-10 PCs)
The application will be used concurrently within the network.The database will be updated after the employee save his/her task.
I plan to have ONE application only, to make it simple no server type installation and client type installation needed. Just one installation type only, the functionality/privilege will depend on the login information validation.
There will be 3 account types, Manager Account (Administrator),Regular Account (Normal Employee) and Guest account.
1. How to create an application which the database will be on the other PC within the network (LAN) ?
2. How to do it during run time/design time ( the database will be on the other pc)?
3. Can I have a guide or walk through on how to do this project?
View 4 Replies
ADVERTISEMENT
Aug 21, 2009
I'm looking to create a program that needs to use a database I have (MySQL is the format it is in right now). The program doesn't need to change/update this database, only read from it. How would I go about making the data available to the program, without the end user having to install an SQL server?
View 9 Replies
Oct 23, 2010
I am trying to create a username database for my program where people create a username when they first open the program and it saves it and uploads their username to an FTP text file.The problem I am having is that I want it to do this and then display ALL users that have created a username on my program and used it in a list on a textbox. I was going to have it do this by having it add all usernames to a text file on my FTP and then have it download the text file of all the users created from the FTP and load it into the textbox on the Form that displays them all.
[Code]...
View 2 Replies
May 28, 2009
I am creating a rather simple program to do nothing more to show a row form a database when the form loads, the program consists of 2 forms, form one has nothing more than a label and a button to load form 2, form 2 has a listbox where the database row is listed and a button to close form 2 and reshow form 1. The code i have so far is [code]...
View 4 Replies
Mar 17, 2009
How to create a database using sql in vb 2008. Creating a database as in make it a valid one. I'm actually trying to develop a program. I've got everything in mind it's just that the database that i'm lacking and i am wondering if there's any idea to create it inside vb.net.
p.s. I know how to link. I just need the information to create the database from the scratch using SQL.
View 18 Replies
May 22, 2009
I need to create a program that connects to a database and determines if what the user entered is in the database. Trying to do this in somewhat the same way that a translator might workchecking to find the word, and if found replace it with what is in the row beside it in the database)
Anyone have any idea on how i should go about doing this?
I know its gonna involve looping but as to how i am completely lost
View 4 Replies
Feb 26, 2010
I have tried to create a bar to search the form
View 1 Replies
Jul 2, 2011
I trying to create an application using vb 2010.This application handles booking of airline customers. i am using ms access 2007 where i have created a table that stores customer information and another that stores and updates seats available in different flying classes. Am trying to develop an interactive application in visual basic 2010 where customers can book. i want to add this data to the database in real time and communicate to customers the seats available,prices and so forth. In otherwards the application communicates with database and updates accordingly. Firstly how do i connect to my database? I tried ADO.net but seems better equiped to work with sql server which i have no idea how to use. Is there a tool that can make my interaction with the access seamless
View 1 Replies
Nov 15, 2009
i have sql 2005 and i want to develop a small program that can access the database and amend a few rows of data. in sql database, i have 1 table and it consist of 3 columns = datetime, type & price. below is example:
[Code]....
View 13 Replies
Oct 20, 2010
I have a slight problem with something i am working on. I found this module here:
View 2 Replies
Dec 22, 2011
Im Trying to create a NotifyIcon Program. I want this to basically be like a service that every second looks at a database to see if anything has changed this is the module thus far
Imports System.Data.OleDb
Module ModNtifi
Public conn As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\MyserverMyDatabase.accdb ;Persist Security Info=False")
[CODE]...
The Problem i am getting is that after the start procedure has finished the program closes. i want it to start the the timer and then keep it going till the user exits the program manually.
View 6 Replies
Mar 12, 2010
i am trying to create a program that connects to a database and shows table fields in listview in windows form i manage to do that but i want now to have a button to take the total of a column in a list box ,lets say from the column "money"?
View 9 Replies
Feb 27, 2012
how to create a program that can access information held in an excel database and show it in a simple form.
View 2 Replies
Oct 9, 2009
does VBasic allow a MS Access Database DataSet create a Stored Procedure or will it only allow SQL Database DataSet create SP...
View 4 Replies
Aug 4, 2010
Hello I want to create a windows form application program that can create games something like Gamemaker or Klik & Play (butt less advanced) with D&D "Drag and Drop" events and actions.
View 7 Replies
Nov 30, 2011
To create a program that asks for input then uses an else statement to create a handling fee balance.
Input: sales record - first name, last name, purchase amount, balance before purchase
Output: report - full name, old balance, purchase amount, handling fee, new balance
Definitions: handling fee is 5% of the old balance if the old balance is less than $1000.00 else it is 2% new balance = old balance + purchase + handling fee
Processing:
Ask for and receive sales information
Calculate new balance
Print output report
End the program when a purchase amount of 9999.99 is entered
View 3 Replies
Nov 30, 2010
I have a project to do for one of my classes that i need help on. Its and extra credit so im left on my own. Project Create a program to allow a student to create there own schedule. what i am trying to do is create a checkedlistbox for the student to check classes they are taking, and need something else to pop up or to show in another box or listbox the classes they can take for the next quarter. I know it has to do with if then statements but i dont know how to write basically:"if (class is checked in checkedlistbox) then ( these are the classes you can take)".
View 2 Replies
Apr 17, 2009
I have produced an application which works with datasets but I now wish to provide the user the ability to add and admend records within the database.But i wish to do this in a seperate form.My current dataset instanciates classes onLoad.Should i try passing the Dataset to the new form class? although I have the problem where by when i pass the dataset to the form class using code below i get this problem:[code]Should i just create a create a new connection to the database and produce a new dataset for this form? or is there a better way to do this?
View 2 Replies
Jun 15, 2009
how i can write a program to create a shortcut in the startup folder of a different program. So i have one program on my computer that should run at startup, i just need another program to create a shortcut to it, and then copy this shortcut into the startup folder.
View 20 Replies
Nov 15, 2009
I am very very new to VB.NET and would like to ask a simple question. I want to create a vb.net program and allow visitors to a website to download this program. However, I prefer not to have visitors download a zip folder. I would like to have a program that just gives a prompt to save in a selected folder, once the saved file is selected it prompts the person to download, and then when finished prompts the person to run the program. The reason is twofold:
1. I don't like the extra step involved with unzipping the file. and 2. I don't like the visitors having to look for the "main" file program within the new downloaded folder. So is there any way to have just one file for others to download without having it in a zip folder?
View 4 Replies
May 18, 2010
When I am developing an application and I use the 'Data Source' tab to create a database, will that database be automatically created when I use the software on another machine?
View 1 Replies
Jun 3, 2010
I'm trying to create a program that installs required .dll's for a program due to a clean install..What I need to do is Get a value in the registry and use it for the program files path.. but I've noticed some pc's don't have the same configuration because of the version the user is using. Anyway This is what I have so far:[code].....
What I'm trying to do is find a registry key called "SoftInstallPath", if found I need the end of the path to goto the new directory(new_dll) not the old one (dll).. and if "SoftInstallPath" cannot be found.. I need it to find "ProgInstallPath" and use it instead and do the same thing.By the way I'm using Visual Studio Professional 2008 on a Vista x86 machine.Also error I keep getting is: Warning 10 Function 'FixPath' doesn't return a value on all code paths. A null reference exception could occur at run time when the result is used.
View 4 Replies
Feb 5, 2009
Anyone ever try and create a program in visual basic that interfaced with an USB device? For example say I want to build a clock but I want to have the software to control this through usb. I want to write the clock setting program that tells the clock what to set for time and date and things like that.
View 3 Replies
Mar 30, 2009
I want to create a program that will auto update another program i have created. I want (this program) to check for updates (from a txt file that i wil have in the first line the previous version and in the second line the present version) and if there will be a new version then start downloading and the progress bar will show the progress. How can i do this?
View 3 Replies
Aug 18, 2010
I am creating a very simple Voting System, that will be use on electing new set of officer in a teacher cooperative...
So I have to create two separate program, a Server Program that will manage all the information in the election and a Client Program where voters will vote their selected candidate...
The election officers wanted that the Server Program will display the Voting Results at real time... So when the Voter finished voting, The Voting Result displayed by the Server Program will also be updated every time the Client Program Insert the data to Database....
An action listener in Server Program that will execute if new data is inserted in a Table in the Database made by the Client Program...
View 11 Replies
Sep 20, 2010
I have a program where a lot of the required information for it is stored in text files. I simply read this information into large arrays. However, I don't think it's necessary to load all the information each time. Rather, it would be more efficient if I could simply search through a list of items to find the one I need and then use the data from it, or to find a similar name and use it elsewhere.
Would I be right in using a database? And is database programming done in SQL? I have a book on it telling me to use the SQL Server (IIRC), so I shouldn't be doing it in the VB.NET Express GUI?
Here's an example of what I would do:
Hex = 03 00 => dex number 003
Search in file Pokemon Dex Numbers
003 returns Bulbasaur
Check Bulbasaur base stats in the base stats file
etc
So basically I'm reusing a lot of information. I think a database would be best and it would all be internal right? I'm getting complaints about access denied to a text file (since it's stored in the program directory in the program files).
So to cap up the few questions I have:
-Databases are done in SQL and not inside the GUI?
-Databases would load internally?
-I could search a database without having to load it into like an array or something?
View 2 Replies
Apr 20, 2010
This program is very difficult for me, but I must get threw it or I cannot finish... What I am doing is making a Database of foreign Languages with the spelling of the words and the pronounciation inside the database... The USER enters a paragraph of words into the translator textbox and pushed translate. The program has a DATABANK of words with the phonetic spellings and matches the word, then translates to phonetics. The problem is that new words keep appearing inside the language. So I incorporated a Database of 2 fields
[Code]...
View 4 Replies
Nov 18, 2009
My question is does Visual Basic 2008 Express Edition provide a way for you to create a SQL Server 2008 Database using the Database Explorer ?
View 2 Replies
Aug 12, 2009
I create my database with SQL server management 2005 Express and i must connect my application elaborated with VB.NET2008 express when i go Tools-connect to database a window appeeas;it demands to set database name But the problem is: i create my database with windows authentification and i don't know the path of the database
View 1 Replies
Apr 13, 2012
i have a application that i designed for an assignment which uses a DB (ACCESS) However when i publish the application it fails to load even though the application completes. I have managed to find that it is the database that is not copying over, how do i solve this (the db is located when debugging and is also in the project files)
View 3 Replies
