Wednesday 22 January 2014

Auto-Refresh using Javascript 

<html>
<head>
<script type="text/JavaScript">
<!--
function timedRefresh(timeoutPeriod) {

        setTimeout("location.reload(true);",timeoutPeriod);
}
//   -->
</script>
</head>
<body onload="JavaScript:timedRefresh(5000);">
<p>This page will refresh every 5 seconds. This is because we're using the 'onload' event to call our function. We are passing in the value '5000', which equals 5 seconds.</p>
<p>But hey, try not to annoy your users too much with unnecessary page refreshes every few seconds!</p>
</body>
</html>
Posted by at No comments:

Tuesday 21 January 2014

C# DATABASE PROGRAMS




  1. Create a table employee with the following fields :  idno, name, designation, department, dob, doj and salary. Insert 6 values into the table. Write a C# program to do the following :
a)    Display the employees belonging to sales department and whose salary is in the range of  Rs. 10000 and Rs. 15000.
b)    Display the employee details whose salary is maximum.

  1. Create a table CIA with the following fields :  regno, name, class, test1, test2, asmt1, asmt2, quiz and total. Insert 6 values into the table. Write a C# program to do the following :
a)    List out the student details whose quiz mark is greater than the average of assignment marks.
b)    List out the student details whose total is greater than 80 and belonging to I M.C.A.

  1. Create a table accounts with the following fields :  accno, custname, bankname, acctype & balance and create another table transaction with the following fields: accno, trans_date, trans_type, and trans_amt. Insert 6 values into each table. Write a C# program to do the following :
a)    Display  the accno and bankname of customers whose deposit amount is greater than 5000 for this month.
b)    Transfer the details of SBI account whose trans_amt is < 10000 to IOB.

  1. Create a table employee with the following fields :  idno, name, dept, dob, doj & salary and create another table personal with the following fields: idno, address, phone_no, bloodgroup and accno. Insert 6 values into each table. Write a C# program to do the following :
a)    Display  the name and address of employees in accounts dept. and whose salary  is greater than 5000.
b)    Display the employee details with minimum and maximum salary.
  1. Create a table stock with the following fields :  item_code, item_name, company_name, quantity_on_hand, reorder_level and price. Insert 6 values into the table. Write a C# program to do the following :
a)    Display  the item details which has the lowest price and highest price.
b)    List out the item name and price of items whose item name ends with ‘r’.

  1. Create a table student with the following fields :  regno, name, class, dob, & bloodgroup and create another table hostel with the following fields: hostel_no, block_name, room_no and regno. Insert 6 values into each table. Write a C# program to do the following :
a)    Display  the total number of students in each block from M.C.A.
b)    Display the student details in Gandhi block and whose name begins with ‘M’.

  1. Create a table employee with the following fields :  idno, name, designation, department, dob, doj and salary. Insert 6 values into the table. Write a C# program to do the following :
a)    Display the employees in the sorted order of their salary.
b)    Count the number of employees in each department.

  1. Create a table accounts with the following fields :  accno, custname, bankname, acctype & balance. Insert 6 values into the table. Write a C# program to do the following :
a)    Display  the customer details who has both type of accounts.
b)    Insert a new record into the table.

  1. Create a table student with the following fields :  regno, name, class, subject1, subject2, subject3 and total. Insert 6 values into the table. Write a C# program to do the following :
a)    Display  the student details whose name begin with ‘P’.
b)    Count the number of students who scored below 50 in all subjects.
  1.  Create a table book with the following fields : isbn, title, author, publisher and price. Insert 6 values into the table. Write a C# program to do the following :
a)    Display  the book details of same author for same publishers.
b)    List out the book details in author wise order.

  1.  Create a table stock with the following fields :  item_code, item_name, company_name, quantity_on_hand and price. Insert 6 values into the table.
a)    Insert a record into the table.
b)    Modify the price value of the item whose item_code is I005.

  1.  Create a table accounts with the following fields :  accno, custname, bankname, acctype & balance and create another table transaction with the following fields: accno, trans_date, trans_type, and trans_amt. Insert 6 values into each table. Write a C# program to do the following :
a)    Display  the accno and bankname of customers who have withdrawal transactions in this month.
b)    Insert a new record into both the tables.

  1.  Create a table journey with the following fields :  ticket_no, date, passenger_name, origin, destination, gender, bloodgroup and age. Insert 6 values into the table. Write a C# program to do the following :
a)    Count the number of male passengers traveling below 21 years.
b)    Delete the details of passengers those who are travelling from Chennai and age is between 50 and 75.

14. Create a table book with the following fields :  isbn, title, author,  publisher    and  price. Insert 6 values into the table. Write a C# program to do the following :
a)    Display  the book details with same title written by same author for different  publishers.
b)    Display the book names belonging to TMH publications and author name ends with ‘raj’ or ‘Raj’.


  1.  Create a table stock with the following fields :  item_code, item_name, company_name, quantity_on_hand, reorder_level and price. Insert 6 values into the table. Write a C# program to do the following :
a)    Display  the item details whose quantity_on_hand is less than the reorder_level.
b)    Display the item_code and item_name which belongs to the same company.

  1.  Create a table book with the following fields :  isbn, title, author, publisher    and  price. Insert 6 values into the table. Write a C# program to do the following :
a)    List out the book names whose price is > 250 and author name ends with ‘h’.
b)    Display the book names belonging to PHI publications and price is between  Rs.1000 and  Rs.2000.

  1.  Create a table student with the following fields :  regno, name, class, dob, & bloodgroup and create another table hostel with the following fields: hostel_no, block_name, room_no and regno. Insert 6 values into each table. Write a C# program to do the following :
a)    List out the blood groups available in the hostel with number of students having it.
b)    Display the students belonging to Nehru block with ‘O+ve’ bloodgroup.

  1.  Create a table accounts with the following fields :  accno, custname, bankname, acctype & balance. Insert 6 values into each table. Write a C# program to do the following :
a)    Count the number of customers belonging to SA type and whose balance is > 30000.
b)    Display the customer details with maximum and minimum balance.



  1.  Create a table employee with the following fields :  idno, name, dept, dob, doj & salary and create another table personal with the following fields: idno, address, phone_no, bloodgroup and accno. Insert 6 values into each table. Write a C# program to do the following :
a)    List out the employee details whose salary is maximum with O+ve blood group.
b)    Count the number of employees in sales department with B+ve blood group.

  1. Create a table student with the following fields :  regno, name, class, dob, & bloodgroup and create another table hostel with the following fields: hostel_no, block_name, room_no and regno. Insert 6 values into each table. Write a C# program to do the following :
c)    List out the blood groups available in the hostel with number of students having it.
d)    Display the students belonging to Nehru block with ‘O+ve’ bloodgroup.
Posted by at No comments:

LIST OF C# AND .NET QUESTIONS




Control Structures :
1.      Write a C# program to find the sum of  ‘n’ numbers.
2.      Write a C# program to check whether a given number is prime or not.
3.      Write a C# program to find the sum of all digits of a given number.
4.      Write a C# program to generate even numbers between a given range.
5.      Write a C# program to find the factorial of a given number.
6.      Write a C# program to calculate the binomial coefficient.(nCr)
7.      Write a C# program to  generate the Fibonacci series.
One Dimensional Arrays :
8.      Write a C# program to find the maximum and minimum value of  ‘n’ given numbers.
9.      Write a C# program to sort an array in ascending order.
10.  Write a C# program to count the number of positives, negatives and zeroes in an array.
11.  Write a C# program to find the sum of alternative numbers in a given array.
12.  Write a C# program to search for a given number in an array and display the number of occurrences of the number if found.
13.  Write a C# program to swap two arrays of equal sizes.
Two Dimensional  Arrays :
14.   Write a C# program to perform matrix addition, subtraction and multiplication.
15.  Write a C# program to find the transpose of  a  given matrix.
16.  Write a C# program to find the sum of all diagonal ,row, column elements of a given matrix. 
17.  Write a C# program to swap two matrices of equal sizes.
Parameter Arrays :
18.   Write a C# program to sort the given numbers using parameter arrays.
19.   Write a C# program to find the sum of odd and even values using parameter arrays.
Collections :
20.  Write a C# program to search for a given word in a dictionary using collections.
21.  Write a C# program to implement stack operations using collection class.
22.  Write a C# program to implement queue operations using collection class.
Inheritance :
23.   Write a C# program to prepare student’s mark list using hybrid inheritance.
24.   Write a C# program to prepare paybill for employees using multilevel inheritance.
Interfaces :
25.  Write a C# program to check whether a given matrix is a sparse matrix or not using interface.
26.  Write a C# program to check whether a given matrix is an identity matrix or not using interface.
27.  Write a C# program to find the row sum, column sum and diagonal sum of a given matrix using interface.
28.  Write a C# program to perform arithmetic operations using interface.
Operator Overloading :
29.  Write a C# program to perform matrix addition and subtraction using operator overloading.
30.  Write a C# program to perform complex number addition using operator overloading.
31.  Write a C# program to add two time objects with hours and minutes fields using operator overloading.
Exception Handling :
32.  Write a C# program to add only positive numbers in an array using exception handling.
33.  Write a C# program to implement the following exceptions :
    1. Division By Zero Exception
    2. Format Exception
    3. Index Out of Range Exception
    4. Argument Out of Range Exception
    5. User Defined Exception
Form Controls :
34.  Write a C# program to perform arithmetic operations using button controls.
35.  Write a C# program to move the items from one list box to another list box.
36.  Write a C# program to prepare student’s mark list using form controls.
37.  Write a C# program to prepare EB bill using form controls.
38.  Write a C# program to prepare Shopping bill using form controls.
39.  Write a C# program to prepare Sweet Stall billing using Windows Application.
Menus :
40.  Write a C# program to prepare jewellery shop bill using menu and error provider control.
41.  Write a C# program to perform number conversion using menu. (decimal to binary, binary to decimal, decimal to octal and octal to decimal)
42.  Write a C# program to prepare pay bill using menu and error provider control.
43.  Write a C# program to prepare hostel mess bill using menu and error provider control.
Using Database in Console Application :  
44.  Write a C# program to prepare student’s mark list using database.
45.  Write a C# program to perform bank transactions using database.
 Using Database in Windows Application :  (simple binding)
46.  Design a windows application to manage library operations using simple binding.
47.  Design a windows application to maintain book shop inventory using simple binding.
Using Database in Windows Application :  (complex binding)
48.  Design a windows application to prepare EB BILL using complex binding.
49.  Design a windows application to maintain car details using complex binding.
50.  Design a windows application to prepare the in patient’s bill using complex binding.







Windows Applications and Database Programs

  1. Create a shopping database with relevant table and process the orders given by the users and prepare the bill for the items they purchased. Write a program to implement the task.
  2. An education institution invites application for admission for various courses. Candidates will enter the details through forms. The application should be processed and the accepted or rejected message is displayed to the candidate. Write a program to implement the above using Windows Application.
  3.  INSYS, Authorized GRADUATE TALLY academy has the following features :
It gives Tally graduate course material and Tally course graduate CD with fully functional and also option to be listed on the TallyWeb for job opportunities in India and abroad. Write a program for course registration to INSYS using Database.
  1. A library enters the details like book access number, book title, subject, author and publication. Only the librarian with username and password protection enters these details. Write a Program to do the above using database.
  2. A college maintains an information system with regard to the various courses offered, department, fees for each course, number of students admitted within a data base. Write a program to display about the course particulars if any user wants to know about it using windows application.
  3. Write a Windows application to implement Employee Pay slip details for a given basic pay. 40% of DA, 2% of HRA, 10% of CCA are all calculated from basic pay. Tax is calculated as 15% of basic pay and for LIC Rs.1000 is deducted.
  4.  An education institution invites application for admission of various courses. Candidates will enter the details in the application form. The application should be processed and the accepted or rejected message displayed to the candidate. Condition for accepting the form is for UG, necessary qualification is +2 and PG minimum qualification is UG. Write a Windows Application program to implement the above.
  5. Nokia mobile shopping centre has all kinds of mobile phones and cellular, fax, billing machines, other essential accessories of mobiles. Write a Program with database to implement Nokia shopping centre billing. 
  6. Election commission wanted to enroll the voter’s information. For register, the voter enters their name, house number, constituency, date of birth, occupation, etc. The voter data should be accepted only if age is above 18 and constituency name is correct. Write a windows application  to implement the above process.
  7. An electricity board wants to computerize their billing system. Every month EB enters the consumer number, meter number, the OMR & CMR values into the consumer database. The reading can be viewed by entering the meter number. Display the chargeable unit and amount according to the conditions. Write a Windows Application  to implement this.
  8. An education institution invites application for admission of various courses. Candidates will enter the details in the application form. The application should be processed and the accepted or rejected message displayed to the candidate. Condition for accepting the form is for UG, necessary qualification is +2 and PG minimum qualification is UG. Write a Windows Application program to implement the above.
  9. Write a program to store the registration details for an Intercollegiate competition conducted by your department. When user checks their status of the registration then display his/her information by getting the registration ID provided by your system using windows application.
  10. Define student info with the following details: Student name, application no, course applied, place and date of birth. Write a Windows application program to find the age of the student and display whether the student is eligible to join the course or not. 
i)   Age below 18 eligible to join any Diploma course as private
ii) 18<Age <21 eligible to join UG course and iii) above 21 eligible to join PG course
  1. Create a registration form which is having input items :  username, password, retypepassword, country(Listbox), City(Listbox), Hobbies(Check Boxes). Get the details from the form and display the contents in an attractive manner using Windows Application.  
  2. Create a table with the following fields: consumer name, consumer number, telephone number, number of calls. Write a Program with database to prepare the Telephone bill for the given consumer.  Charge should be calculated by the following conditions:

            Calls                                        Rate

First 100                                  Rs. 1.10 /call
Next 150                                 Rs. 1.80/call
Next 200                                 Rs. 2.40/call
Above                        Rs. 3.60/call

16.  Create a table called “Sales” with the following fields sales man name, sales man number, location of sales, district, sales date, sales amount.
Write a program using database to calculate the commission for the given salesperson. Commission should be calculated using the following conditions:

            Sales amount                                       commission

            Below 5000                                                     No commission
            >=5000 and <10000                           5 % of  sales
            >=10000 and <20000                         7 % of  sales
            >=20000 and <30000                                     9% of  sales
Above 30000                                      11%  of  sales
  1. Create a table called “Bank” with the fields Account holder name, account number, address, account type (with/without cheque) and balance amount. Write a program with database  to perform the bank transactions like deposit and withdrawal. The bank follows below criteria for their operations:
i. Minimum balance should be maintained as Rs. 500/- for without cheque, Rs. 1000 for with cheque facility.
ii. At a time maximum of  Rs. 3000/- only withdraw by the customer.
iii. Maximum of  Rs. 50000/- only deposited by a person at a time.
Posted by at No comments:
Subscribe to: Posts (Atom)