Create Small Database Which Handles Student Attendance Record - Repeating The Data Again And Again ?
Feb 6, 2009
I want to create small database which handles Student Attendance Record it will store the roll calls of students on daily basis that teachers collect from the students in the class on paper and then later transfer it on computer .So my database Must contain Month, Year, Program (BCS, BIT, MS, MCS, MIT etc) Batch (1st, 2nd etc) and Subject (English, Math, Geography etc)
Suppose I want to Search for the Attendance Sheet of any month, year, Program, Batch or Subject, it returns me the required dataSo i come up with the Datadase which includes 5 dimension tables and one fact tableDimension Tables1. Student (StudentID, Name, other Attributes)2. Program (Program_Name, other Attributes)3. Date (Date, Week, Month, Year)4. Batch (Batch_Number, Description)5. Subject (Subject_Name, other Attributes)Fact TableAttendanceTable ( StudentID, Program, Date, Batch, Subject, Status)but the problem come when certain columns are repeating again and again which is time consuming for database operator and shows inconsistent behaviour of database.
Look at it: my Fact table would be like this [code]....
problems:1. The StudentId is repeating which shouldn't (Primary Key),2.It wastes a lot of time coz i'm repeating the data again and again Like Program, Date and Batch which shouldn't be in consistent Databases.
View 7 Replies
ADVERTISEMENT
Mar 27, 2012
We are creating a VB program for school to collect data on student attendance and populate it to a table. I have all of the 'GET' statements but am having trouble creating the 'Insert' procedure. This is what I have so far. The form being used to fill the table has 4 items being recorded. 'Present' radio button marked as present, tardy or absent; StudentId, PeriodId and date. Not sure if we are on the right track. The target table is tmAttendance. There are approximately 25 rows of data on the input form.
View 3 Replies
Mar 7, 2012
I'm creating a rewards system for school where pupil earn points for good behavior which they can then use to purchase things like a packet of pens. (They can also have points deducted for bad behavior). I've created all the forms and now its just getting the data in from the Access database. This is what I need to do. On my form called detailsPupil it shows various information such as Name, email address, last login etc. This form is loaded once the pupil has logged in.
Private Sub btnLogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLogin.Click
Dim Login = Me.StudentTableAdapter1.UsernamePasswordString(txtUsername.Text, txtPassword.Text, cboPermissions.Text)
If Login Is Nothing Then
MsgBox("Incorrect Username or Password")
[Code] .....
That all works but I'm having problems working out how to get the information like Name and email address into their places. This is what I have so far on my detailsPupil form.
Public Class detailsPupil
Private Sub btnLogOut_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLogOut.Click
Login.Show()
[Code] .....
So to sum up I need to run a query which searches the DB using the Username which is obtained from the login form and then displays the Student Name in txtName, Email address in txtEmail etc...
View 1 Replies
Aug 28, 2011
im trying to add a new record in a small access database only firstName and lastname i want to chek if that record exist msgbox say record exist if not add a record here what i have done
Dim sqlcmd As String
Dim cmd As OleDbCommand
Dim dr1 As OleDbDataReader
Dim user As Integer
[code]....
View 4 Replies
Jan 13, 2012
I'm basically trying to do a small report card project. I only need to pull 5 Students with each student having 5 Test Scores a piece. The full Code of what I have for the submit button is below. I have actually 3 questions.
1. I always seem to have trouble with them unless I initialize them when I dim them. Is there a better way than below
2. The below code works really well for Student 1 and all 5 test scores. Rather than do that code 5 times though, what is the best way for me to basically state that IF dblStudent1(intMax) = 4 Then Change dblStudent1(intMax) to dblStudent2(intMax) etc.
3. Would this be better suited towards a multidimensional array ?
Private Sub btnEnterGrades_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnEnterGrades.Click
Dim strStudentNames() As String = {" ", " ", " ", " ", " "} ' Holds the 5 Students Names
Dim intMax As Integer = (4) ' Place Holder for Student Number
[CODE]...
View 8 Replies
Nov 15, 2009
I have a problem with my program, and it's really bad because I need to burn it to disk within 12 hours and I can't get it to work: If I create a record, add information to it and click on Next Record, the ID, Status and Notes boxes content will change but the rest of the controls contents are carried over to the next record and I don't know why or how. It was working perfectly but now it stopped and I never done anything.
View 8 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
Feb 1, 2010
On form 1 , i have a number of buttons that open up different websites.What i want to do is when i click a button on form 1 , i want forum 2 to show ( Form2.show() ) , Form 2 will have a list (Buttons) of internet browsers.
View 4 Replies
Aug 11, 2009
I have an Infopath form that retrieves data from a datasource, then populates a repeating table with a dynamic number of rows depending on employid. Once the data is populated, a "user" can enter numbers, times, etc. That part works fine. Now, what I would like to do is submit the data to a sql database. I just can't figure out how to navigate through each record of the repeating table. I have tried the following code, but have been unsuccessful. I can not get the XpathNodeIterator to work on the secondary datasource.
Dim domNav As XPathNavigator = Me.DataSources("getEmpHourlyPaycodes").CreateNavigator()
Dim rows As XPathNodeIterator = domNav.Select("/my:myFields/my:ReturnedData")
While rows.MoveNext()
Dim field1 As String = rows.Current.SelectSingleNode( _
"my:descriptn", NamespaceManager).Value
' Submit code will go here.
End While
View 2 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 19, 2010
I have created a class called Student, with five private variables: [code] My main form is divided into a number of different sub procedures. In one of them, I used a streamreader to take the first name, last name, and phone numbers of a list of records in a text file called PersonalInfo.txt. It seems to work just fine. [code] I have another, separate sub procedure in which I read a different text file containing the "averages" for the students. The first average from Averages.txt belongs with the first student in PersonalInfo.txt. The second average goes with the second student.. How do I add the student average information to the properties of the student records created in the previous sub procedure? [code] I realize why this wouldn't work, but I can't figure out how I could use my counter to reference a specific student.
View 4 Replies
Mar 21, 2010
i want make a attandance software but i need coding for make connection between attandance machine and databass. so i can connect to machine and downloadd attandace logs.
View 1 Replies
Mar 6, 2012
randomly select a single student out of the student array based on their subscript number. This will be accomplished by the following:
[Code]...
View 4 Replies
Nov 27, 2009
I have a small database program that gets data from csv file, I created a function that formats the font color of textboxes based on dates and values.
CODE:
I place this in text changed event and I have a problem implementing it, because the date conversion will not take place until the data is loaded. The second part works but not the first(Date) part.
I can create a button and use its click event to format the text boxes just fine, however i wanted the text boxes to be formatted on the fly . The problem is no matter where i call the function the date conversion wont work.
View 5 Replies
Feb 4, 2012
Before getting started, I'm new to VB and currently using Visual Basic 2010 Express. Just want to make sure I've got this in the right forum and my apologies if I'm not.[code]...
I have 16 cities (those would be my string variables, right?) that I want to appear on my 16 labels in random order without repeating when I click the button. So basically label 1 can be any of my 16 cities, label 2 then will be any of 15 left available cities, and so on and so on.
View 1 Replies
Jun 25, 2010
create an auto incremented student no.in mysql using vb.net lyk 2006-141791
View 2 Replies
Feb 2, 2010
I'm following the sops from msdn on how to create a database from scratch. I would now like to programmatically add a single record via a command button?
View 3 Replies
Dec 4, 2010
I want to save student detailed in MS SQL SERVER database like names class..... But I have a form such that user can enter one student detailes and then press save. But I want now to allow to have like a spread shit (excel) and then enter all student detailes and when he press save all data are saved like data in name column go to the appropriate one in database>
View 1 Replies
Apr 28, 2010
Student pursuing BSIT degree, employer expectations, entry level. I would like to solicit opinions from this forum as to what your professional expectations are as regards an entry level position in working in the database realm... I see many job opportunities that require a minimum of 2 or more years experience, how does one go about obtaining this experience (I have tried very hard to maintain a minimum 3.70+ GPA) but have ZERO work experience in this field... I spend non school time working in VB and SQL to try and increase my proficiency. I have considered postponing my job search until I obtain certifications from brainbench etc... Any criticism and or advise is welcomed... Again I have no experience in database other than undergrad work in class.
View 2 Replies
Mar 17, 2012
I'm building a Stock control system and what i have is a Location Table. What i want to do is move stock between locations. Obviously I don't want to have the stock being moved to the same location. So i was wondering If there was a way to Create an SQL string that would get all of the locations except for the one that was selected.
[code]...
View 2 Replies
Oct 1, 2009
How to create a Attendance form in windows form.The form should lookk like this:
1 2 3 4 5 6 7 ..........till 31 or 30 based on month selected
1. emp1
2. emp2
I shud be able to enter attendance for employees.....
View 7 Replies
Nov 14, 2009
Using Visual Studio 2008 I am trying to create two subs using the same handles:
Private Sub checkwin(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click, Button2.Click, Button3.Click, Button4.Click, Button5.Click, Button6.Click, Button7.Click, Button8.Click, Button9.Click
[Code].....
As these both use the same handles one sub overwrites the other...... Both subs contain If statements. Do I need to create two different handles... and how do I do this so that the handles use the same buttons?
View 3 Replies
Jul 21, 2009
i am getting a error went i update or save a record to my database.
View 3 Replies
Aug 9, 2010
I am trying to check a record in database before inerting a new record here is my code but problem is when i enter a names first alphabet it imediatly populate massage. i want to check it after entering whole name
Private Sub TextBox1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TextBox1.KeyPress
Try
Dim cnString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &
[CODE]...
View 2 Replies
Apr 14, 2012
I have a program with two forms, one that handles the applications controls, and the other with the functions that open a file (csv), open a database, and query the database. The controls on the first form are a list box, three labels (to display parsed csv information), and three buttons (clear database, load database from csv, and load listbox).
The clear database and load database buttons (events) seem to function correctly.On the other hand, the load list box event doesn't function 100% the way I'd want. [And, I can't test the selected index event yet]
The code for the load list box event is:
Code:
Dim db As New DBUpdt 'second form
b.openConnection("weather.mdb") 'open database connection
db.query("SELECT * FROM stations") 'query database
Do While db.moreRecords
[Code]...
View 3 Replies
May 20, 2009
I can't seem to save data in the database when updating a record. The record appears to be updated and even displays the new record on my form but as soon as I close and restart the program the old record is back and no changes are made to the database. Is there something im missing here ?
If CN2.State = ConnectionState.Open Then
Dim Comand As New SqlCeCommand("SELECT * From Incentives Where IncentiveCode = '" & TxtCode.Text & "'", CN2)
Dim rs As SqlCeResultSet
rs = Comand.ExecuteResultSet(ResultSetOptions.Sensitive + ResultSetOptions.Updatable)
If rs.Read Then
[Code]...
View 4 Replies
Jun 12, 2011
i think there is a problem with my code below....it insert the data more than 1 record (data redundancy) in the server database....i think there is a problem at the place i highlight with red....
If Not Update_ServerPOS() Then
Update_TempPOS()
End If Public Function Update_ServerPOS() As Boolean
[code].....
View 9 Replies
May 1, 2012
I have a combobox that I am populating with the contents of a dataset (from an access database). The field that it is showing has lots of values that repeat. I want to remove the repeats of the data so that only unique records are shown in the combo box. I imagine this can be done with the SQL for the data adaptor? I tried: "SELECT type FROM products GROUP BY type" and "SELECT DISTINCT type FROM products" but both still showed the repeating records.
View 8 Replies
Apr 19, 2011
I am coding a Student Management System using VB.NET and Access DOn the Form for Teacher Bio-Data, I want to use a table in which I can place Teacher Qualifications in a tabular format. In other words, say, the teacher had Primary, Secondary and Tertiary education. I want to put a header as Qualifications, Year and Grades. Is there any such tool in Visual Studio that I can use?
View 9 Replies
Feb 7, 2011
I'm trying to find the right RegEx to capture some (potentially) repeating data. I don't know how many times it will repeat. If I give an exanple of the data and what I want to capture can anyone point me in the right direction? It's the .Net regex engine (Visual Basic)
[Code]...
View 1 Replies
