MySQL Student Database Beginner SQL Employment Expectations
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.
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.
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>
I guess some or all of us may experience this at some point in our lives but I really do wish that employment agencies and employers discriminated less when it comes to employing people.It feels like a lot of them are being ageist when I am trying to get a start in the world of software development. I have turned 45 last August but it seems like I will probably need to either; [code]Please do not read this thread in the view that it a "whine" or a "moan", I would just like to read your thoughts on age discrimination .In fact a recent scientific study has shown that middle aged folk are just as bright and savvy as those in their late teens, 20's or 30's and they are also more likely to be loyal towards an employer,so why do some employers think differently ( it seems )?
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...
I remember that to set expectations on methods that return void in C# one has to write: mockedRepository.Expect(() => mr.AddUser(someUser)).DoOtherStuff()where AddUser returns void.How to achieve the same in VB.NET?
EDIT:I've found similar question. May be helpful: How to mock a method with Rhino Mocks in VB.NET .
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.
I have determined thanks to the last q & a that there is something wrong with my "save to db" code as well as my "retrieve to picture" code. Even If I manually save the pic in the db it stil wont retreive. This is code i patched together from 3 or 4 examples around the net.
Dim filename As String = txtName.Text + ".jpg" Dim FileSize As UInt32 Dim ImageStream As System.IO.MemoryStream[code]......
I am trying to make a login system mysql try to connect to a mysql database.
Here is my code:
Imports MySql.Data.MySqlClient Public Class LoginForm1 Dim MySqlConnection As MySqlConnection Private Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK.Click MySqlConnection = New MySqlConnection()
I can have mysql database. but i have not mysql. how to connect this database vb.net 2005. but i have mysql-connector-net . I want to mysql-connector-net use to connect this database. database path(C:Documents and SettingsAdminMy DocumentsVB.NETStock delnaSTC.sql)
I want to learn visual basic, what book or books are the best to take me from beginner to intermediate?Would it be more advantageous to go through VB 2008 or VB2010 tutorials first or should i start with a book before going through VB2008 or VB2010 tutorials?I am comfortable with Sequel (SQL) language, learned on the job and am at the advanced level of Excel/Access writing formulas functions,etc. the next logical step is to learn VB.
I am trying to create a program that calculates the prices of different payment methods of a buffet.The program requirements are simple. The buffet start in 1/7/2011 and ends 31/8/2011. Payments methods are online, cash and coupon. coupon is only valid from 1/8/2011 to 31/8/ 2011. 1 child is free for every 2 adult that pay. There are different prices for weekends (sat and sun) and different prices for weekdays. [code]
I'm trying to pick up some simple object-oriented programming skills so I am trying my hand at beginner's problem - and I am totally stuck...I'm trying to write a program that will print to a label, the area and perimeter of your shape of choice, dependent on the Length and Width (for Rectangles and Triangles) or Radius (For Circles) you input and the shape you select.
I know how to do this easily with simple event-driven programming, but I'm trying to do this by using classes and inheritance.The idea I have is that you enter in length/Radius and/or width into text boxes (txtLen, txtWid) and then you can click a button to display the Length, Width and Perimeter or Radius and Circumference, and Area.
I'd create a Super-Class: Shapes to define my overarching parameters - all shapes have area and perimeter. Then I would create sub-classes for each shape inheriting the overarching "Shapes" class - dim'ing all of their respective extra pieces. Then the buttons would display the appropriate info when clicked.I understand this seems like a lot - but really I just need help getting my feet on the ground for this.
I have been working on this all weekend and can't figure out what I am doing wrong. The objective is to collect 3 numbers from the user then display to them the numbers they entered, the lowest number entered, the highest number entered, the total, and the average. Can someone review this and tell me what I am not getting?
I just need a good nights sleep, but Im simply reading through a file (2010 data) and for selected teams, accessing the corresponding data for the previous year (2009 data), which is held on a separate file. (I painstakingly input all the 2009 data manually)
ds1.Clear() cmd1.CommandText = "SELECT * FROM Teams WHERE Team = ?" cmd1.Parameters.Add(NewSqlCeParameter("Team", (ds.Tables(0).Rows(x) ("Team")))) cmd1.Prepare() cmd1.ExecuteNonQuery()
Dim conn As New SqlCeConnection, in the position marked **, it makes the program fall over on the cmd.prepare statement: requires an open and available connection
Public Class Form9 Dim compactStr As String Dim conn As New SqlCeConnection
The program should request the person's occupation, the amount of the bill, and the percentage tip as input and pass this information to a Sub procedure to display the person and the tip. Title is gratuities, first line Person's occupation, amount of the bill:, Percentage tip: Compute Tip, and show the tip. Im not sure how to approach it properly.[code]
I had this incredibly ambitious goal to make a video game and so I am teaching myself/relying on kindness and knowledge of others as I go along. So far I have learned a lot, however needless to say, this is a monstrously difficult challenge, however one that I am very passionate about completing. The idea is that I am making a trading card style game and I was hoping that I could continue to use this thread and your kindness to keep me going whenever nessecessary throughout this challenge.So, here is where I am now. (Please forgive me if i have posted too much details/not enough details. Since I am new, I am not sure what information you need to help me. This will be corrected as time goes by and I learn more)I have created a card class with two properties. name and picture with name As String, and picture as PictureBox. the constructor looks like this: [code]
My next goal(and where I am currently stuck) is making i so that when the user clicks on one of the items in the listbox, a picture of the appropriate card(saved in a pictureBox of its own on a different form, and referenced in the card via the picture element) will be placed inside the empty picture box on the deckPage.
Im using Visual Basic 2008.Okay I got all the design, and everything set up, even the hangman body parts coming on the screen and stuff. So my problem is creating the BLANKS, the underscores "_", and replacing them with a letter...
I was thinking creating Lables which i have no idea how to dynamically. Then giving each label name the letters they belong to, and everytime the user gets the rigth letter they get replaced.
I am having an issue getting my code to work. It is not showing my Look-Up Button for me to calculate the rate based on the weight and zone and it continues to constantly show that I have an error that I cannot seem to correct.
I have been looking for a good beginner tutorial on polymorphism, inhertance,and related terms.Something where I can start at and go through and get most of the common programming terms and techniques explained with examples
I'm beginner programmer in the amazing world named ".Net".I've a lot of questions
well, what I should learn C# or Vb.net What's the best blogs which talk about .Net technology and Open source projects Where can I find good tutorials, free books and ideas of projects how can I progress in ".Net" please, share your knowledge , your OPML of your favorite blogs or web sites about ".Net "
