Iam doing a project in Visual studio 2008, I connected database from MS SQL Server 2005 to Visual studio 2008. In my SQL I've created two tables, Student Information Table and the Payment Table. In my Student Information table I have the following fields: Student Number, Name, Year Level and Section... while in my Payment table I have Student Number, Downpayment, Balance fields... What I want to do is when I click a button 'SAVE' it will save in the database then whenever I want to view the Payment Records of Student it will display the Student Number, Name, Downpayment and Balance in combined in one table in a form... How can I do that? Can you provide me some codes? or any explanation about it? thanks.. :)
select a.StudentNumber, Name,DownPayment,Balance from StudentInformation a inner join Payment b on a.StudentNumber = b.StudentNumber
where StudentNumber = '1234'
But I am not sure that the structure you are following will work out for you.
What are you storing in downpayment? Only the last payment? How will you keep track of all the payments (if this is the table, you might want to also record payment date and payment method). Also Balance is not something we would record with payments, as it needs to be updated with the Credit as well as with the Debit.
Hey, so I wanna ask how I need to create a method who will remove word if in that word is 2 same chars. Example: "Potato" in this word there is a 2 "o" chars so this word will need to be removed. "Forum" in this word there is no ...
Help! I want to create a java program that finds the highest even integer among the values entered by the user. Stop asking values when a value less than 1 have been entered. If no even integer is entered, display "No Even Integer"
I am writing a java program that needs to execute shell commands, so I wrote a function that would take the command to execute as a string (ie: "mkdir ~/Folder1") and execute that command with the shell. Here is the function:
Runtime run = Runtime.getRuntime();
Process pr = ...