Students Trainings Windows Application - Database Design ?
Nov 24, 2010
I am developing a new application for Students Training. how the database design should be? And could you provide a sample application similar to my requirement? Following is the requirement of the Application, The objectives of the program or application are:
Get Information about the total number of students trained in all company's department
Get Information about the total number of students who were either withdrew/ apologized /rejected
Anticipate of the future needs for student's work placement opportunities (numbers of students as well as the majors)
On light of the objectives mentioned above I consider the following data for the application preparation: Company's Department Needs Department Major Number of students for each major Supervisor Mobile Number
If it is possible when entering students details the program will automatically register him/her in the Department that has vacant place and already fit the requirements of the certain department-Internship Information.
Using visual studio 2008 environment, i would like to change a classic windows application design, so i'm wondering if there is an idea a bout this. i've find some skins like irriskins ( www.sunisoft.com ), but i'ts not what i'm looking for.
The main purpose of the my app that I need your help with is, to deliver an always (or close to) up to date a list of files for the user to choose from for a variety of common purposes. For instance, opening the selected file in its native client editor application so the user can make changes. Another purposes would be to print the file, and I have others.
If nothing else (meaning recommendations for a better design that still keep my desired in mind) I'd like ideas on how to update my complex DataSet (background processing options, what's the most efficeient/quickest way to update my DataSet) as the list of files changes while my app is running and my app is designed to never close due to the long amount of time it take to load it initially.
The list must be always kept up to date while my app is running because not only the intial loading of data takes a lot of time but updates (new/modified/deleted) could potentially take too long depending on not only how much data to update/add (new files) but how efficeient my code is in updating the list. To be perfectly clear: If a new file is created then it need to be somehow (automatically preferably or manually i.e. button code) add to the list. If a file is deleted then it needs to bet removed from the list. And if the file has changed, perhaps some of it metadata or thumbnail image have changes so update the file's data in the list. All of which (new/modified/deleted) need to be as real-time as possble without degrading the server too much and without the user waiting more than a handful of seconds.
Listing all the files as quick as possible whether that be with or without metadata initially is very important because most of the time the user is going to filter (or scroll the list by typing) for a partial file name. Once the user filters/scrolls to the desired file there's a very good chance that he/she isn't even interested in the metadata, most of the time the user wants my app to open the selected file in its native client editor application so he/she can view or modify the file. The initial load time of the data doesn't concern me as much as updates because the user can possibly do other things while it initially loads all the data as long as it not too long (more than a few minutes). From there the updates will either be automatic if possible (most desirable from a users standpoint) or the user initiated (e.g. button). Plus I'm thinking the updates might need to be done with a few different background processes (multiple threads) because I think I need one for periodic updates (e.g. every 15 minutes) and one background process for page updates meaning whatever the user has either scrolled to or filtered for, more accurately all files currently display to the user will be systematically update in the background so the user can still operate my app.
I'm currently using SqlDataAdapter.Fill to fill a DataSet object variable (which is bound [BindingSource] to a DataGridview control) to first populate the DataSet from the SQL query and then prorgammatically adds records (DataRow) for local files but please make recommendations. I don't mind big changes or starting over if necessary, I just want the best app possible based on the aforementioned criteria. I'm not sure if it complicates matters but I've also added custom columns in the DataSet for some special needs (thumbnail of files, booleans for tracking custom statuses). For the local files I'm currently populating the DataSet prorammatically (iterating a path/file string collect made by System.IO.Directory.GetFiles) since the list is first (and very quickly) populated with Vault files (which is always a far larger list than the local files) so . Again, I don't have to take this direction, make recommendations.
I want to build an application that checks every second for certain windows and then react according to that.
My Goal:I'm building the application for a pc in a Students Home with about 10 users. To create 10 different user accounts for windows will be annoying and crowded, because new people come in every year(or couple of months) and then old accounts have to be deleted and new ones created.
I want to build an application that accepts folderPaths or window names.Lets say user1 creates a folder with the name "Susan" that she wants to protect (her personal files/picture/work will be stored there. She opens the application, selects the folder. The application saves the folder path and her password that she enters.
If the application detects that a user is trying to open/move/delete/copy/whatever that folder, the app must pop up a password box. Correct password gives her the freedom she wants, wrong password just ignores the open/move/delete/copy/whatever command.
I am a new user to VB and I am having difficulty with one of my assignments. The assignment states that to create an application that allows a user to enter three test scores each for three students. The application should calculate each student's average test score and assign a letter grade. The application should prompt the user for each student's name and three test scores.
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?
Visual Basic Project - Student Check In Form using an Access database backend This form needs to draw information from an Access database containg tables for STUDENT, INSTRUCTOR, and SECTION. These all need to have primary keys and ids. When (the user) clicks on the drop down box that displays all the sections:
{Table Tennis 1, Table Tennis 2, Table Tennis 3, Billiards 1, Billiards 2, Billiards 3}This should populate the listbox or datagrid from the STUDENT table with the Students that have the same SECTIONID as the SECTION selected in the drop down menu above.
After the Student list has been populated (the user) clicks on a student name in the listbox/datagrid and this inserts that student into the CHECKEDIN table that has a datagrid/listbox associated with it.
This is a great project to practice connecting a database to Visual Studio 2008 .net and playing with the data that has been pulled in. You could use SQL instead of Access.
i am doing project of Order Accepting system for five star hotels.Scenario is Waiter will accept order using Window Mobile which is Connected to WiFi present in hotel.I want to communicate to database(Sql Server) present on My Machine (Computer present in kitchen) through WiFi and Add order into table present inside database. This should notify my application present on Compter and should print order. After completion of Order Application from kitchen will notify to waiter about completion. My problem is How to Communicate with database present on Remote computer using WiFi from windows Mobile.
I am having two databases for the same application , one in windows and the other is web based.Since web based one have few functionalities I can't opt for a single database.At the same time I want to share Both databases to be updated with other's data so as to work error free with my module of appointment fixing.
I have done alot of work over the years designing MS Access DB's, but its getting to be problematic with end users needing to have access installed to use them. also if the MDB files have OLE's the file can get very large. I tryed using FoxPro years back and it sort of worked as long as we didnt use OLE's but I'm behind the times with that also. I'm currently not sure where to start, I have decided on a beginner style Dtabase project but need to know some things and then will need some help. Heres my requirements.A single Form, with multiple textboxes, about 6. i will list the names and such in a moment, it would be nice to have search, and images, some buttons too. I basically want to use the layout I use right now in Access but I want to code it from scratch.
Now I need to know what is the better way of going about this, Do I use a MDB Access file and go ahead and setup a table with all my fields, or Do I need to use SQL? Just a note I have never used SQL. Now I need to be able to save my SQL/MDB file for backup purposes.One of the problems with this DB is that while a user is keying in parts, if they run into a new manufacturer, they have to close the Data Entry form, open the manufacturer table and add them manuall then return to the data entry form. its slow and can cause issues . When I messed with VB DB's before I never could get the crystal reports thing to work at all. now I would like to add a textbox/field for picture, it will only host the image location eg. c:DBimages image01. jpg..You Know Your Addicted To Computers When - Your main computer is a 7 terabyte, Core2Quad 3 Ghz +, with 4 or more gigs ram, over 200 programs installed, and you would rather sit with it programming than go to the movies!I've got 13 PC's in the House and 7 are in my bedroom and my main one exceeds this set of stats.
With VB.net, I'm coding a simple application to get more used to the new .Net format.
I'd like to save all the information to a 'new' database file. how to create a database on the fly, once that is done i'll be able to connect to it no problem, but actually creating the file is proving difficult to work/find out.
Also, with vb.net and the newly created custom file, how can it be made to automatically open that information with the program?
Is there a method in installation to associate the file type with the new program? How can i check when the program loads if a database file has been 'double-clicked' (rather than just running from the .exe of the program) and proceed to load the data?
EDIT1 - Extra InfoThe windows application has many different fields and content etc, then i need to save that to a file that could later be loaded by 'double clicking'. I assumed the easiest way would be to create a mini-database for each unique file
i would like to build an inventory manager application that would have two versions :1. Would run on the desktop 2. Would run on windows mobile 6 I would like to have both these versions store and read data from a database that can be stored centrally either on a webserver or somewhere on the LAN.
I would like to know can i use Access as my backend database or sql server ? will windows mobile app be able to access it and read and write to it Note : I would prefer to create only one database that will just store the details in the tables and do not need any other functionality. All functions such as save,edit,delete,search,filter etc with be done from the FRONT-END VB.NET interface ONLY If you suggestion involves the use of 2 databases such as one for desktop version and one for windows mobile then please also tell me how would i sync the data between them.
I've been trying to connect a MS database to a V.B. form unsucessfully.Actually when i try to do that, i can't connect the tables information to the form or store the information i enter in the form in the MS table.I was doing an exercise here, and to store the information in the table called readers, i typed:
I have develop a wiindows application and it's done in MS Visual Studio 2008 using the VB language and it connect to a 2005 sql database. now i want to deploy my application and want it to be directly attached to my database so that when someone installs it, it comes directly with the database attached to it.
I am about to finish an application for a client. Now I'm having hard time deploying it since I really don't know how to do it.How do I deploy a windows form application with database?I've already downloaded the prerequisites redistributables. I also want those to be included in the installer.
I'm Using Visual Studio 2005 and Mysql Database to create a windows application. The datagrid displays all the records. Since I don't know how to directly update from datagrid, thats why I have used textboxes for the respective datagrid fields. A load button is provided which on clicking puts the data on the respective textboxes. The data can be edited in the textbox. Problem is that I can't save this edited or modified data back into dattabase.
I want to use windows authentication in my vb.net application rather than validating against Database. Is there any possiblitiies or APIs that allows me to use Windows authentication? I have user id and passoword text boxes. Once user entered the userid and password, it should validate again Windows authentication.
Windows form application Access database Is it best practice to restrict user entry via keypress event then validate all info entered & show error control message
or use dataset partial class columnchange as cannot restrict user entry here Could an experienced programmer suggest best way i actually prefer restricting keypress then loop through and validate all entrys but want to be right
i have written this code to inser data in my database table "member "through the form but it is not working if i start debugging the code it gives no error but when i open my database table to see the inserted data it is not working.
Imports System.Data.SqlClient Public Class Form3 Dim con As New SqlConnection("Data
Do users of windows applications have to have the database application installed if your program uses databases to store information? For example, when making VB2008 programs, if I use the visual studio express database (.sdf), or maybe a MSAccess database, to store information within my visual basic program...when I deploy the application to the users, can they run the program okay even if they don't have MSAccess installed on their computer?Also, do I need to have MSAccess installed in order to write programs that use MSAccess databases?
The problem has been simplified for the purpose of clarity. I want to make a windows form application that uses an access database. The application will store the list of person's basic details such as name, age and country. The database contains two related tables ie person(id, name, age, country_id) and country(id, country_name) My windows form contains TextBox, DateTimePicker, ComboBox for Name, Age and Country respectively. Now I want to make CRUD operation Programmatically (Not using Visual tools) in the same form with some navigation buttons.
how can i deploy windows application developed using Vb.net and Sqlserver R2 Express as local database?..how can i make it in setup format(including sqlserver) to deliver to clients?is it compulsory the client should install SQL Server R2 Express in his system apart from the installation of this windows application?
I am a SQL Server Developer and DBA. I have some experience in VB.Net (Windows Application) programming. I used to use .config to setup database user and password. I have a windows application running on my computer. I would like to check which username and password is used to connect to SQL Server Database.
The application sits on a virtual environment and when I remote in and run the application, it connects to the remote database. However, when I remote in with a service account and double click the same .exe, it tries to connect to the local host database and ignores the app.config. The code is the same, only the login name I use is different. The login I use is part of the local admin group. Any ideas?
I have created an windows application which stores it data in a database. What I would like to know is how do I access the tables in the dataqbase and transfer the data in them into textboxes on the forms in my application. I can connect to the database and view the tables, but I have'nt got any idea how to get the data from the fields in the tables into the appropriate textboes on the application forms.
I m working on an school management application, i design the database in access2003 and forms in vb.net2005. but i dont have any idea about the database conectivity. with the help of a book to connect with the db but i cannot save the data in the mdb file. in my application 1 add the followin buttons add new record modify record delete search using id or enrolment no.
Iam developing a Windows application using Visual Basic 2008 with a SQL Server database. Throughout the program I give the user as many options as possible and have no problem with either the database or the windows forms. The program does not initially require a Login and I want toprovide the User with the opportunity to add a Login to the system. The default Login form is perfectly satisfactory.
The problem is that I can't figure out how to program the change sothat the Login from isopens the program rather then th form designated as the StartUp form. this forum I am able to prgrammatically change the form but I can't figure out how to make the requirement a permanent factor. I tried using a Constant, but if the User wants to change, you can't change the constant. Its an apparantly simple yes/no situation but if I set a varable to yes and then change it to no the next time the program runs, the change will be lost.
I just started using vb.net express 2008 about 2 months ago.I wanted to design a gui application and the controls for 2008 express look a little plain.
1. What software can I use to design cool looking windows and gui?
2. Does the full version of vb.net come with a better gui designer?3. What do people use to design gui, if you want to have something nice that people would buy?
