Category: Ms-Access projects

Ms-Access projects listed here are for Computer science final year students. Ms-Access is used for back end application as database for storing data. Ms-Access projects database is used for vb, .net, c# projects. Download full project reports and database with source code.

Posted on

Electronic Employment Management System

Abstract: The project entitled “Electronic Employee Management System” fully describes about the process of employment office schemes and provides the strong connection between job seekers and job providers. In this portal the job seeker has to register their details into the employment office database. Once they register the identities the system automatically post the complete details like Renewal time, validity and the cost if any required to the registered candidate.

Electronic Employment Management System Architecture

The candidate can view the current opportunity through the job portal of the respective candidate. The system provides complete opportunity to the job providers to upload the job details immediately into the site; many candidates/job seekers get benefits from this system. This system provides one more add-on like if the date is expired to renew then the system automatically alert the candidate by sending mail to them whenever the site gets logged in. For all the entire system handles the process of employment office and provides the bridge between job seekers and the job providers.

MODULES

  1. AUTHENTICATION
  2. Employee REGISTRAION
  3. VERIFYING employee detail
  4. Experience renewal

AUTHENTICATION

The authentication module that allows the user provides to the identity of their own into the system, and gets full access rights to handle the website. Basically this website starts with the authentication port once the user properly registered in this website after that making the process. The employee management system provides the secure authentication and authentication process. The employee can login into the system with correct username and password and get all benefits of the site.

REGISTRATION

The registration process allows the user to enter the proper identity into the system. The identities are nothing but it is the basic information about the respective individual. The information like name mail id address username and password, which in be store to the server. The employee management system is to provide the registration process. In employee side the registration process is based on the personal detail like as name, Mail Id, address etc.

VERIFYING employee detail

This module is used to view the working employee details and relieve employee details. It is used to calculate the overall manpower of company, and calculate the overall employee salary details. And this module allows to verifying the present employee details like name, employee designation, and address. 

Experience renewal

Experience renewal module allows to renewal the employee experience. This module helps to improving the employee salary based on their qualification and their experience. The company gives the promotion for employees based on their experience. This renewal portal is used to update each and every employee experience up to date.

Electronic Employment Management System Registration Table

DATAFLOW DIAGRAM

Level-0

Level-2

Level-3

Electronic Employment Management System DFD

SYSTEM ARCHITECTURE

SYSTEM SPECIFICATION

Hardware Requirements: 

  • System                            :   Pentium IV 2.4 GHz.
  • Hard Disk                      :   40 GB.
  • Ram                                 :   512 Mb. 

Software Requirements:

  • Operating system           :    Windows 7 Ultimate (32-bit)
  • Coding Language           :   ASP.Net
  • Data Base                         :   Ms-Access
Posted on

Time Table Generation System in ASP.Net

The aim of this project is to create software for college and for the purpose is to maintain the “TIME TABLE GENERATION” for both the students and staff.  Each Department head is having problem in work scheduling to their sub ordinates and work status feedback.  This project solves the above problem.  This software gives permission to the students and staff to view their allotted subject and Time Table.

Interaction Between The Student And The System

This software is used to maintain the details of staff and student’s Time Table details and college Time Table details.  Visual Basic.NET is used as front end that is used to design the user interface.  Microsoft Access is used as back end and used to design the database and stores the details.

The tables used here are Course Details, Department details, Staff Details, Time Table Allocation details, Subject Details.

The project is more user-friendly so that anyone have minimum computer knowledge can access and handle the software without having any complexity.  This system provides security to the users by providing proper login.

Time Table Generation System

Modules in this project are,

  1. Course Details
  2. Department Details
  3. Staff Details
  4. Time Table allocation Details
  5. Subject Details

Course: 

In this module both the entry and view of the course details can be done.  If the entry should be done, then the details will be checked.  After that the details will be added in the database and a message will be displayed to confirm the entry.

Time Table Generation System Semister wise

Department:

If the Department details entered then the Id of the corresponding Department must be entered, then the entered Id will be checked against the database. If the match is found, then the Department details of the Corresponding Department will be shown in that module, Else an error message will be displayed.

Staff Detail: 

In this module both the entry and view of the staff Details can be done.  If the entry should be done, then the details must be entered and checked for duplicate.  Then the details will be added in the database and a message will be displayed to confirm the entry.

Time Table Allocation:

In the Time Table Allocation Details the staff, subject of the Corresponding staff will be entered, then the entered staff Name will be checked against the database.  If the match is found, then the Time Table Allocation details of the corresponding staff will be generated and stored in database, Else an error message will be displayed.

SUBJECT DETAILS:

The subject details master includes subject name, id and the staff handling the subject will be entered and stored in database. In time table generation the details will be retrieved and used as per the requirement.

Existing System 

In the existing system, each task is carried out manually and processing is also a tedious job.  The Organization is not able to achieve its need in time and also the results may not accurate. Because of the manual maintenance there are number of difficulties and drawbacks exist in the system. Some of them are

Drawbacks of the Existing System:

  • Increased transaction leads to increased source document and hence maintenance becomes difficult.
  • If any student, staff entry is wrongly made then the maintenance becomes very difficult.

PROPOSED SYSTEM 

The proposed system is designed to be more efficient than the manual system. It invokes all base tasks that are now carried out manually, such as the forms transactions and reports which is added advantage.

Advantages of the Proposed System:

  • Gives accurate information
  • Simplifies the manual work
  • It minimizes the documentation related work
  • Provides up to date information
  • Friendly Environment by providing warning messages.

ENVIRONMENTAL SPECIFICATION 

Software specification 

Platform                      :           Microsoft Windows XP

Front – End                 :           VB .Net

Back – End                 :           MS Access

Environment               :           Microsoft Visual Studio .Net 2005

Posted on

Inventory Control System in VB

System Analysis and requirements tells about the project requirement like the background knowledge needed to do this project, the purpose of the project, the end-user of the project, the project features, the application of the project, development and operating environments, hardware and software requirements and perspective and constraints of the project.

This project mainly deals about the “INVENTORY CONTROL SYSTEM”.

This application software is computerizing the inventory level of all materials of the stores department and also some operations of purchase department. The company is maintained for each and every material. The main functions of stores department are material purchase, purchase order, purchase return, stock maintenance, material issue and material receiving.

The project consists of four modules:

  1. Master
  2. Transaction
  3. Service
  4. Reports

The first module includes the details about Vendor details, and Material Stock details.

The Second module includes the details about Purchase order, Material Receiving, Material Issues, and Purchase return.

The Third module includes the details about Material Outgoing and Material Incoming.

The Fourth module creates various reports for company requirement.

This project is developed in Visual Basic 6.0 as frond end tool and MS Access as back end tool.

Inventory Control System in VB

INTRODUCTION

ABOUT THE PROJECT

Definition:

This project purely deals with the computerization of  “Inventory control system”. This system is computerized to get varies types or reports and bills. The user has entered the  purchase,  issue,  service    and   vendor   details,  The  system   is designed to meet the user requirements and  is user friendly along with the support of  the facilities of Visual basic 6.0in which the required coding  are written. This project is concerned with developing a new system that eradicates the loopholes and the draw back of the existing   system.

A through investigation of the existing system was carried out and its boundaries were analyzed. In accordance with the user requirements the format were designed.

EXISTING SYSTEM STUDY

The existing Inventory Control System is manual and is almost a tedious task to do various transactions. In day today life lot of transactions will be taking place. The employee who deals with this system will have to take much pain during the end of the final year.

The system will be dealing with a number of calculations during the end of the financial year. There is a chance of occurrence of errors at all levels of the system.

The records are stored in large and in different ledgers which is really an inconvenience to the user of the system.  A lot of entries have to be made in the ledgers for the transactions.

In case of announcement of the increment in the fuel cost the rates will differ. The users find the job to be difficult, as a lot of process has to be taken place.

Up – to- date reports have to be prepared at regular intervals.  Reports of this type require a lot of reference and calculations. The users may find it difficult with it, if there are lots of reports of this type.

CONCLUSION

The Inventory control system is developed for the stores Department. Since the system developed using Visual Basic in GUI environment, any report or information, which may be either regular of adhoc in nature, can be taken easily using this system.

As the language is fully menu-driven the user will find it very easy to handle the system. Also, the system is developed in such a way that it is mostly parameterized. This means, wherever possible the variable data like material, vendor can be found easily. This will enable the users to change any parameter, as and when required, without the any assistance from EDP professionals.

The developed Inventory control system will be very useful to them and the concern would utilize it extensively for their applications.

PROPOSED SYSTEM

The proposed system seeks to eliminate discrepancies of the existing system. Hence the proposed has the following advantages over the existing system.

  1. Reducing error due to human factor as all the major manipulations are carried out by the system itself.
  2. Transactions statements via the proposed system turns out to be less costly compared to the manual system.
  3. Time factor allows sine less amount of time is taken to prepare the final statements.
  4. Accuracy, reliability and efficiency are greatly improved since the functionality of the proposed system excels the former one.
  5. Various settings can be done with less effort.
  6. Automatic computation of the currency.

SOFTWARE

Operating System: windows’98

Front End: Visual Basic 6.0

Back End: MS-Access 7.0

Posted on

Flight Booking Portal

Abstract

The project entitled “Flight Booking Portal” is all about and for passenger assistance as the name states.  Now-a-days passenger traveling on a Flight gets confused very Often and is in contact only for the duration of the course that they undergo. Only one third of the passengers in a Flight Onboard are able to frequent travelers and interact with each other. The primary objective of this project is to announce the passenger list, Takeoff time and landing time of each flight. Flight details, Airport details and Airline timings are maintained in this project. The passenger list tells about the details of each passenger and the takeoff time tells about when the flight will takeoff and landing time tells about when the flight lands. This project is used to eliminate problems that arise in the manual system. This site provides the facility to handle the details and data easily and accurately.

Flight Booking Portal System Architecture

Primary Objective

The primary objective of this project is to announce the passenger list, Takeoff time and landing time of each flight. Flight details, Airport details and Airline timings are maintained in this project. The passenger list tells about the details of each passenger and the takeoff time tells about when the flight will takeoff and landing time tells about when the flight lands. This project is used to eliminate problems that arise in the manual system. This system is user friendly to maintain the records easily and accurately. 

Flight Booking Portal Login Page

Working Nature of Flight Booking Portal

The working nature of the flight booking portal does not facilitates only the booking and cancellation of flights and also it maintains the complete working scenario of the airport and the flight landing and take-off strategies as well as the clear passenger details into the concern. Once the passenger book for the particular flight it confirms the passenger details like in which class they book for the particular flight and in which day the flight is turned on to fly and so on. Basically the working scenario of the entire system fully handles the working nature of the airport and provides facility to the passengers to book for the flight and know the complete details regarding the corresponding flight to move on.

Flight Booking Portal Flight details

Scope of the System

The scope of the flight booking portal starts from the maintenance of airport strategies and the maintenance of passenger details. Once the flight details are entered into the system the employees and flight capacity are decided by the administrator end such as the particular flight contains this much of seats and the capacities like class I, II and III. For each class the passengers can book their seats based on the necessities. This system maintains one interesting scenario that is the Age Fare Concession, once the passenger details are collected it automatically calculates the fare based on the age of the respective passenger.

Development Environment 

Hardware Requirements:

System                           :   Pentium IV 2.4 GHz.

Hard Disk                      :   40 GB.

Ram                               :   512 Mb. 

Software Requirements:

Operating system           :    Windows 7 Ultimate (32-bit)

Coding Language           :   ASP.Net

Data Base                      :   Ms-Access

Posted on

Software Personnel Management System in VB

The Software Personnel management system is highly unique, because of its distinguished activities and behavior. It sounds to be different, because of its classified nature. It starts right from the conception of an application and it covers up the entire life cycle till the customer’s problems are successfully handled. The management of this process and its required documentation proves to be challenging as it has many cases to concern.

The special cases arise from this management system such as handling the customer’s problem in such a way that it can be clearly mapped to the development details in the database.

In the existing system all the processing are done manually. These systems will have to maintain the data in a hard file. While searching any data it is too difficult to find those.

Maintaining too many data about the software in separate files are too complicated. Similarly, it is too difficult to maintain data for each and every activity. So, the time utilization will be more in the manual system. In order to overcome these problems we have to propose the system which overcomes the problem of the existing method.

We have proposed a system that would modernize the activities of Software Personnel management system. The developed system would perform all the function of the manual system. Using this system we can save time and the operation will be performed with ease comparatively.

Software Personnel Management System Login Software Personnel Management System

1.INTRODUCTION: 

         To analyze, Design and develop code for Software Personnel Management system using Rational Rose software and Visual Basic 6.0.

PROJECT SCOPE:

The main scope of the project is to provide the developing company to maintain an interface to store and access the project details and the respective customer associated with it along with the assignment details with regards to the team working on the project.

OBJECTIVE:

The main objective of designing and developing a Software Personnel Management system is to provide with a system which proves to be manually beneficial i.e., benefits the software developing company. The complete activities and the process right from projects inception to its successful delivery is incorporated in this system.

Software Personnel Management System Use case Diagram

PROBLEM STATEMENT:

Software personnel system is a real time application used in the developer’s day to day system. This is a database to store the project configuration that is specified by the customer and the software developed for it includes customer and developer requirements needed for the process. Here we assume ourselves as the developing company:

1.The company is the developer of the software and it contains the necessary information of the software such as requirements, time limit etc.

2. The customer provides the requirements to the company and requests a suitable solution system. The company is only responsible for developing the system out of the requirements of the customer.

3. The company mainly obtains the requirements from the customer and by analyzing it, prepares a requirements and feasibility documentation initially.

4. Then the company develops a software system that is apt for the integrated requirements and tests it within itself and by exposure to the concerned customer, and finally builds a complete a satisfactory solution.

 SOFTWARE REQUIREMENTS: 

Design Tool : Rational  Rose Software

Front  End: Visual basic 6.0

Back End : MS-Access

PROJECT DESCRIPTION: 

Existing System:

The existing system is the manual system.   The manual system is error prone.  It is time consuming.  It is very difficult for a person to produce report.  There are chances for manipulating the reports and changing it.  This system involves a lot of manual entries with the applications to perform the desired task.

Limitations:

  • Data maintenance adopted by the present system is not accurate.
  • Inaccurate result in case of duplicating, delay and inconsistency in reporting.
  • Generating consolidated reports is more difficult in manual system and it may not be consistent.
  • The transactions are very time consuming.
  • There is no facility for the users to know whether the data is entered is valid or not.  This disadvantage is the major cause of errors in transaction.
  • There is inconsistency in maintaining data’s.
  • No global view ability of data’s.
  • No chance of knowing other members sales daily.
  • It is not user friendly.

Proposed System: 

The proposed system is designed to eliminate the drawbacks of the existing system.  It is designed by keeping in mind all the drawbacks of the present system in order to provide a permanent solution to the problems.  The primary aim of the new system is to speedup process.  The report is prepared for the software personnals.

The personnel code and software code are validated. Accuracy for all the data entered is maintained in the proposed system through validation and verification from all the files.  Verification of personnel code, software code, validation of records, etc., are performed with maximum accuracy.  In short, efficiency is established.  The advantages of this system are listed below,

  • User friendliness is the keyword for all the new software in the market.  The proposed system incorporates this concept into itself to guide the user.
  • At every stage of data entry necessary comments and validation messages are provided to the user.
  • The proposed system is also expected to reduce the amount of paper work involved.  The hard copies of only necessary documents need to be taken the rest can be avoided.
  • Competitive environment is developed with the publications of other members of same level.
  • Good communication is being held via mail options.
  • Data’s are maintained accurately via daily submission of information details. 

Need For Computerization:

            The Project entitled “Software personnel management system” was not computerized previously.  In this system, the information about the software and the progress of personnels and the  movement of the products in the market cannot be noted easily. If these informations are needed we need to spend lot of time, money and energy.

If the company’s turn over has to be increased then there is some need for experts ideas for that up to date information has to supplied this is quite impossible in the present system.

If the company wants to inform some important meeting/decisions, this process should start before sometime before the actual happening. If some person are added this too has to be informed individually for that quite some money has to be spent.

Reports cannot be created easily with much flexibility and with limited amount of time. The head of the company cannot sit at a place and maintain the records without much assistance.

Data maintenance is quite tough when maintained manually. High level of data redundancy exists.

MODULE EXPLANATION: 

The project ”Software personnel management sytem” deals with the process of managing the software personnels of a company.  This project consists of many UML diagrams that are described below,

• Use case diagram

• Class diagram

• Sequence diagram

• Collaboration diagram

• State chart diagram

• Activity diagram

• Component diagram

• Deployment diagram

• Package diagram

The project can be explained diagrammatically using the following diagrams.

USE CASE DIAGRAM

The use cases are a set of scenarios to guide together by a common user goal. A scenario is the sequence of steps describing an interaction between a user and their system.

List of employeeLoginCEOEmployee detailsDatabase

DOCUMENTATION OF USE CASE DIAGRAM 

The use case diagram in the software personnel management system illustrates the sequence of sequencing and describing an interaction between a CEO and a system.

Login:

This use case gives as entry to the CEO and the database.

List of employee:

This will create the situation for the CEO to select particular employee from the available list.

Employee details:

The CEO can able to view the details of the employee using this use case.

CONCLUSION: 

The system is developed for automating the activities involved in the software done by the personnel. The data maintenance and reports generated are compatible with the daily activities of the department.

The main advantage of the system over the existing system is the increase in the speed of information retrieval since that data is maintained systematically and any type of information required for the end user of the system can be generated easily.

This system is of vital use to the software personnel incharge, to the distributor and to the representative also.  They can very well know about the sales done by them on a particular day or a month, between dates, in an area,…

Though “Software Personnel Management System ” is so designed that not much amendment is required.  This system has provisions for adapting to future enhancements.

Posted on

Patient Management System (PMS)

Project Title: Patient Management System (PMS)

Project Abstract:

  • The project consists of Patient Management System (PMS) which is a part of Hospital Management System (HMS). This project contains seven modules namely-Admin, Receptionist, Doctor, Payment Counter, Clinic Center, Inpatient and Online Registration.
  • Hospitals must need to maintain the information of the patients very accurately and up to date. The information helps the doctors to treat the patients very efficiently.
  • PMS project contains seven modules namely-Admin, Receptionist, Doctor, Payment Counter, Clinic Center, Inpatient and Online Registration.
  • Also the hospital must maintain the information of the patients for n number of years and the episodic information

Study of the Existing System

The functioning of the existing system can be explained as:

Patient’s Information

  • The whole information regarding different activities in the hospital is entered in the registers manually for future verification.
  • The patient details like Personal Information are all entered in registers. Each Patient’s information will be maintained in a separate file.
  • If the patient gets any new ailments, their details, tets, reports must be added to the previous information.
  • All the information regarding the patient from entering the hospital to leaving the hospital must be maintained accurately.

Doctor’s Information

    • The information regarding all doctors and their qualifications, their personal details all are maintained in a separate file. Each doctor has a unique id.
    • The doctors’ availability times all are maintained in a separate file. 

Difficulties in the existing system:

  • The process is time consuming and ineffective.
  • It is difficult to find a particular patient file among a number of files.
  • There may be delays intimating the responses to the requested doctors.
  • The current status of the patient is not readily available to the doctor. The file needs to be moved among the departments until the approval process completes.

If any new information is to be added corresponding to a particular patient file, various departments should submit all the reports regarding the patient.

  • When any modifications has to be done, then each and every time new entry has to be filed as it is not possible to update the previous record.
  • The doctors can not estimate easily the physical status of a patient. They have to verify and compare many reports in order to come to a conclusion.
  • There is a chance of missing reports sometimes and it is difficult to put responsibility on a particular person.

Study of the Proposed System 

The new system is designed to overcome the demerits of the previous system. It insists for the proper data collection in a standard form which is designed in an effective manner.

In order to overcome the drawbacks in the existing system, it was decided to create a database, which is

  • Integrated
  • Sharable
  • Reliable
  • Secure

Any incomplete or invalid data will not be accepted as there are thorough checks at each and every stage of all forms.

The software will handle the following functions:

Authorization

  • All the staff in the hospital will be given a user name and password for login in to the system.
  • Different Menu Accessing Permissions will be given to different cadered people.
  • Depending on the validity of the username and password entered, the software will become accessible to the authorized users. 

Patient Information

  • Patient personal information like name, age, sex, occupation, fathers name etc will be maintained.
  • Each patient is given a unique PIN (patient index number).
  • Each patient is assigned to a particular doctor.

Doctor’s and other staff Information

  • Every doctor and staff member will be given a unique id.
  • Their personal information like contact numbers are maintained.
  • Their availability on that day will be maintained.

Patient reports and bills

  • The reports and bills of a patient are stored in the database for further verification.
  • The cost of each test is maintained.

Advantages of the New System:

  • This is oriented, comprehensive and standardized user-friendly software.
  • This software is easy to use and saves a lot of time of the staff in different cadres, as it can quickly respond to the user requests in an efficient manner.
  • Helps in speedy information retrieval.
  • Extra information from various tables in a single query.
  • It performs thorough validation checking while storing. It assists the user with respective messages to overcome the errors at runtime.
  • It can generate different types of reports according to the user needs.

Modules & Module Description

FUNCTIONALITIES OF THE MODULES:

Login:

Once User enters the valid userid and password user move to the page that displays corresponding services of that user.

ADMINISTRATOR:

  • Administrator is the one who will be having complete authority over the software.
  •  He is the one who will decide to whom the access over the software is to be granted.
  • He is responsible for entering new user information, updating their information, and deleting the information when the user no longer exists.

RECEPTIONIST:

  • It works round the clock. Initially the patient is admitted as OP.
  • Depending upon his condition he is then admitted as the IP.
  • Emergency cases are accepted near the causality Counter.
  • This module automates the day-to-day administrative activities and provides instant access to other modules, which leads to a better patient care.

DOCTOR:

  • The doctor module is the important module of the Patient management system.
  • Once the doctor enters the hospital, he will log into the system to see the list of patients allotted to him.
  • When the patient meets the doctor,the doctor will examine him and prescribes him the necessary medicines to be taken and tests if there are any to be performed.
  • The patient after undergoing all the tests visits the doctor with the test report.
  •  Depending on the results of the test, the patient may be advised to stay at the hospital.

PAYMENT COUNTER:

  • The payment counter module handles all types of billing for long-term care.
  • This module facilitates cashier and billing operations for different categories of patients like Outpatient,Inpatient.
  • It provides automatic posting of charges like lab tests conducted in different departments.
  • The payment counter module is extensively flexible by which each of our billing plans can be configured to automatically accept or deny

CLINIC CENTER:

  • Clinic Center module starts with receiving tests from doctors and also allows laboratory personnel to generate requests.
  • The Clinic Center Module supports to perform various tests under following disciplines:Biochemistry, microbiology  etc. Tests are performed only after billing is done.
  • This rule is exempted when the case is declared as urgent

INPATIENT:

  • Depending upon the test results generated by the Clinic Center, the doctor decides the status of the patient i.e., whether he is an inpatient or an outpatient.
  • In case, if the patient is declared as in, then the respective patient goes to the receptionist counter and the receptionist there, will allot him a bed in the required ward.
  • At the time of discharge, this inpatient has to pay the maintenance fee along with the test fee and the registration fee depending on the number of days he stayed in the hospital.

ONLINE REGISTRATION:

  • In Online Registration, the user can “sign up” into the system, so that he can get username and Password(chosen by him/her).
  • As soon as the patient get username, he can now login to the system and will be provided with different services.
  • When he/she fills the form, will be given the appointment date, time and the doctor allotted to him by the Receptionist.
  • He can edit his profile.

Hardware and Software Requirements: 

Hardware Requirements
Processor : Pentium
RAM : 64MB or more
Hard Disk : 2GB (Minimum)

 

Software Requirements
Operating System : Windows9x/NT/2000/XP/Vista
Web server

 

 : Apache-Tomcat

 
Browser : Internet Explorer or Mozilla Firefox
Languages :  JAVA.JSP

 
Database : Microsoft Office Access
Frontends : HTML, Java Script
Posted on

Java Mini & Major Projects

Java Mini Projects developed especially for BCA, BTech and MCA students for their academic mini and Major project development under Java, MS Access, Oracle, SQL Server & MySQL. These are below are selected projects.

Java Web Applications Project List – 2019

Sr.No Project Title Output
1 Booking Photographer Video
2 City Life Video
3 E-Magazine  Video
4 E-Tuitions Video
5 Magazine College  Video
6 Event File Automation  Video
7 Learning Portal Video
8 Nirman  website  Video
9 Ship Management System Video
10 Placement Cell  Video
11 Cancer Project Video
12 E-Procurement  Video
13  Project Management System Video
14 knowledge-based community sharing system  Video
15 Offer-Bazar  Video
16 Online-E-Gas Video
17 Income-Tax-Return-Processing  Video
18 Online Staff Leave Management Video
19 Employee-Expense-Management-system Video
20 Exam Seating Arrangement System Video
21 Color Hunt Gaming project Video
22 Online Form Request Video
23 Electronic-Veg-Market Video
24 Puyo Puyo (game project)  Video
25 Magic Bounce Ball  (game project)  Video
26 Satvara Matrimony Video
27 Query Handler  Video
28 Grade Processing System  Video
29 AES–Photo Encryption  Video
30 Image Enhancement  Video
31 Paradarshia Corruption Free Economy  Video
32 Implementation Of Floyd’s Algorithm Video
33 Atm Location Search Video
34 E-Farming Video
35 Time Table Management System Video
36 Admin Mall  Video
37 Bulls-Eye-Quiz Video
38 Smarter Work Management System Video
39 Online Grievance Redressal System Video
40 Real Estate Magicbricks Video
41 Apartment Management System Video
42 Medical shop Management System  Video
43 Security Mail Communicator Video
44 Feedback Analysis Of interviews Video
45 Intelligent Hospital System Video
46 Tender Management System TMS Video
47 Virtual Learning Environment (VLE)  Video
48 Online Loan Application  Video
49 Retail Purchase & Tracking System Video
50 Opinion Mining For Social Networking Sites  Video
51 Project Information System Video
52 Student Friendly College Management System Video
53 Online Book Store Video
54 Sentimental Analysis For Mobile Networks Video
55 Report Generation System Video
56 Feedback Information System Video
57 Health Prediction Management System Video
58 Online Book Review Management System  Video
59 Suspicious Email Detection System  Video
60 Student Monitoring System  Video
61 Online College magazine  Video
62 Sports Event Management System  Video
 63 Restaurant Management System Video
64 Online House Rental Management Video
65 Online Food Ordering & Service Video
66 Online Course Management System Video
67  Online Cab Booking System Video
68  Online College Voting System  Video
69  Cluster Analysis and Disease Mapping Video
70  College Feedback System Video
71 Result Analysis System Video
72 E Plastic System Video
73 E-Banking System Video
74 Assignments and Materials System Video
75 Vehicle Management System Video
76 Recipe Management System Video
77 Online Event Attendance Video
78 Online Parking System Video
79 E-Auction Video
80 Telecom Services Video
81 Airline Reservation System Video
82 E-Waste Application Video
83 Exam Invigilation System Video
84 Library Management System Video
85 Patient Follow Up Video
86 Event Management System Video
87 Career Information System Video
88 E-Gas Sewa Application Video
89  Student Attendance Management System Video
90  Office Level Student Information System Video
91  Online Pharmacy System Video
92  Online Recruitment System Video
93  Credit Card Fraud Detection Video
94  Smart General Library Video
95  Venue Booking System Video
96  A Secure Two-Factor Authentication Scheme Video
97  Selection of Effective Clouds for Data Hosting Services Video
98 Career Analysis System Video
99 Student Performance with graph & Academic Project work Reporting System Video
100 Wedding Event Planner  Video
101 Travel Rating and Exploring System Video
102 Performance Evaluation System Adoption of Opinion Mining Information Video
103 Online Marketplace Video
104 Uni Watch – Web Video
105 Training & Placement Cell Video
106 File Security System Video
107 Social Networking Site Video
108 Campus Recruitment System (Training & Placement) Video
109 Farmers Buddy Video
110 Event Organization System Video
111 Online Doctor Appointment Video
112 Online Survey System Video
113 Secure Web Application for Managing Auction System Video
114 Identification of Diabetes Video
115 College Placements & Assistance Video
116 Online College Bus Record Supervising System Video
117 Online E-Ticket System Video
118 Online E-Voting System Video
119 Student & Faculty Interaction Outside the Classroom Video
120 Automated Retail Management System Video
121 Dynamic Media Management Video
122 Electronic Highway for Singers Video
123 College Election System Video
124 E Police Application Video
125 Student Performance Forecasting Video
126 College Bus Tracking System Video
127 Performance Monitoring in Virtual Organizations Video
128 Review-Based Rating Prediction Video
129 Automation of Exam Invigilation System Video
130 Fast Detection of Transformed Data Leaks Video
131  Employee Tracking System Video
132 College Sentimental Analysis Video
133 Personality Prediction System Through CV Analysis Video
134 Analysis of Users Behaviour in Structured E-Commerce Websites Video
135 Image Encryption and Decryption using BlowFish Video
136 Resource Maintenance and Management Video
137 Watermarking Video
138 Monitoring Fake Product Reviews Video
139 College Bus Facility System Video
140 Software Piracy Prevention Video
141 Tour Guide Video
142 Local Vendor Review System Video
143 Multi-Level Marketing Video
144 Secure File Sharing Video
145 Water Distribution and Management System Video
146 Citizen Card System Video
147 Collaborative Online Tutorial System Video
148 Online Entertainment Portal Video
149 Secure Web Portal for Real Estate & Property Management Video
150 Agile Management System Video
151 Book Repository Management System Video
152 Frame It Video
153 Voice to Text Converter Java Project Video
154 Purchasing Management System Video
155 Telangana Public Services Video
156 Analysis of Persuasive Text Passwords Video
157 Project Review Automation Video
158 Easy Search Guide (Malls) Video
159 Food Wastage Management System Video
160 Food Ordering System Video
161 Stack Management Video
162 Courier Service System Video
163 Campus Recruitment System Video
164 Vehicle Rental Management System Video
165 Automation of Timetable Generation System Video
166 Online Gas Management System Video
167 Obsessive Compulsive Disorder Video
168 Online Leave Management System Video
169 Image Steganography using LSB Video
170 File Tracking System Video
171 Electronic Voting System Video
172 Dynamic Analysis vulnerability to Provide Security In Clouds Video
173 Health Care Logistics Video
174 Car Store Video
175 E-Fuel – Online Fuel Booking Video
176 Hour Wise Lecturers Tracking Video
177 Multi-Hospital System – Online Doctor Appointment Video
178 E – Voters Application Video
179 Repository Application Video
180 Student Information Chatbot System Video
181 Student Help Desk Video
182 Online Student Mentoring System Video
183 Placement Information System Video
184 Hostel Management System Video
185 News Report Video
186 Dance Studio Video
187 Passenger Vehicle Management System Video
188 Automatic Question paper Framer Video
189 Development of Learning Management System Video
190 Online Bouquet Store Video
191 E Approval System Video
192 Online University Voting System Video
193 Automatic Exam Seating Arrangement System Video
194 Advanced Query Management System Video
195 Urban Spoon Video
196 Development of Online College Yearbook Video
197 Predicting user behavior through sessions using the web Mining Video
198 Digital WaterMarking Techniques Video
199 Age Group Classification in Social Networks using Deep Learning Video
200 Securing data in Image & Audio Files using Steganography Technique Video
201 Computerized Examination Management System Video
202 Scalable Architecture for Multi-User Encrypted SQL Operations Video
203 Mental Disorder Detection on Social Networks Video
204 Resource-aware hybrid scheduling algorithm in the heterogeneous distributed computing Video
205 Secure File Storage on Cloud using Hybrid Cryptography ( AES, DES, RSA) Video
206 Data Mining for Sales Prediction in Tourism Industry Video
207 A Secure Approach For Data Hiding Using Visual Cryptography (Image Split, Encryption and Decryption) Video
208 Classification and Detection of Abusive and Insulting Content in Social Media Video
209 Data Security In Cloud Computing Using Two Way Handshake Method Based On Token Management Video
210 Web Application For Conducting University Examination Video
211 Student Performance Prediction via Online Learning Behaviour Analytics Video
212 Faculty Management System Video
213 Online Medicine Donation System Portal Video
214 Indian Wildlife Java Project Video
215 Employee Attendance Monitoring System Video
216 House tax Billing System Video
217 Online Meeting With Clients Video
218 Online Voting System Video
219 Construction Management System Video

 JAVA Projects (Non-IEEE, Web Based, Window Based) – 2018

S.No Project Name Demo
1. Ad Express Management System  Video
2. Finance Management System  Video
3. Credit Card Approval System  Video
4. Computer Telephony Integration System  Video
5. Computer to Computer Learning System  Video
6. Conversation Portal  Video
7.  Logic Gates Java Project  Video
8. Crime File Management  Video
9. Hotel Management System  Video
10. Automotive price Aggregator  Video
11. Blood Donors Symbiosis  Video
12. College Fest Organizer  Video
13. College Management Information System  Video
14. Communication System  Video
15. Computerization of Bluebook/ Online Quiz  Video
16. Computerized Mobile Store Management System  Video
17. Digital Signature  Video
18. Hotel Management System  Video
19. Multi Banking System  Video
20. Digital Tunes  Video
21. Optimal service pricing for a cloud cache  Video
22. Library Management System  Video
23. Crime Records Management System  Video
24. Insurance Management System  Video
25. Friends Meeting Point  Video
26. Student Management System  Video
27. Travel & Tourism Management System  Video
28. E-Compiler for Java with Security Editor  Video
29. Stock Analyzer  Video
30. E-Shopping  Video
31. E-Voting System  Video
32. Enterprise Scheme Planner and Monitoring System  Video
33. E School  Video
34. E Wheelz  Video
35. Congestion Control Using Network Based Protocol  Video
36.  Car Pooling System Java Project  Video
37. Country Cargo and Express Couriers  Video
38. E-Classifieds  Video
39. Distributed Account Management for Prepaid Mobile Services  Video
40. Car Collection for Sale  Video
41. Bug and Component System  Video
42. Bug Tracker System Video
43. Coach Management System  Video
44. Auto Spare parts Java Project Video
45. College Library Record Application  Video
46. Consignment Tracking Services  Video
47. Activity Management System  Video
48. Audio Stenography  Video
49. CRM for Airline Industry  Video
50. Error Tracking System  Video
51. Exam Suite System  Video
52. File Security System  Video
53. Fetch Hard – Component Retrieval System of a PC Video
54. Bug Tracking for Improving Software Reliability  Video
55. Cyber Cafe Management  Video
56.  RSS Feed Reader  Video
57. Ezee Mail System Video
58. Gateway to Gateway Protocol Video
59. Database Manager Video
60. Human Resource Management System Video
61. Image Enhancement Technology Video
62. Image Steganography  Video
63. Increasing Efficiency in Wireless Network Video
64. Image Transport Protocol ITP Video
65. Instant Messenger Video
66. Interest Calculation Video
67. Intra Communication System  Video
68. Inventory Analyzer Video
69. Inventory Management System Video
70. Issue Tracking System Video
71. JChat Video
72. Job Miller  Video
73. Defect Tracking System Video
74. Audio Cryptography System  Video
75. Product Service Management System  Video
76. Auto Mobile Store and Service  Video
77. Ambulance Service Provide  Video
78. Automatic Database Schema Generation  Video
79. An Intelligent Network Backup  Video
80. Digital Image Processing System  Video
81. Knowledge Storm  Video
82. Emergent Request Dispatcher  Video
83. E-Zest Resorts for U  Video
84. Monitoring Online Tests through Data Visualization  Video
85. Data Transmission Using Multi-Tasking-Sockets Video
86. Doctor Patient Tracker  Video
87. Data Hiding in Audio Files  Video
88. Mobile Service Provider Operations Portal  Video
89.  Online Doctor  Video
90. Multi User Chat System Video
91. Network Routing System  Video
92. Online Examination  Video
93. Automation of Interview Scheduling Process  Video
94. Library Management System (Standalone application)  Video
95. Mobile Station Java Project  Video
96. Lending Tree System  Video
97. Library Management  Video
98. VAT Information System  Video
99. Material Management and Information System  Video
100. Government in Action  Video
101. Online Payment Service  Video
102. Order Processing System for Student Music Store
103. Pesticides Information System  Video
104. Property Management System
105. Resource Out-Sourcing  Video
106. Resource Planner  Video
107. Resource Supervision Management  Video
108. SDLC Management System  Video
109. Secured Data Transmission  Video
110. Shopping Cart
111. Online Shopping Cart  Video
112. Simulation of Ant colony Algorithm  Video
113. Speed Age Courier System  Video
114. Traffic Controller System  Video
115. Vehicle Management System  Video
116. Virtual Information System for Audit Group
117. E School  Video
118. Work to Worker Services to Unorganized Sector  Video
119. Broad walk Dealers Network
120. College Administrator Tool/ College Enrollment System  Video
121. College Interact
122. College Management Tool
123. Comparable Entity Mining from Comparative Questions  Video
124. Complaint Management System
125. Computer Retail Store and Maintenance
126. Computerized Examination Management Tool
127. Concurrent Train Simulation  Video
128. Congestion Control Using Network Based Protocol
129. Corporate BPO Solution Management
130. Corporate Leave Management System  Video
131. Corporate Recruitment System (CRS)
132. Cyber Shopping  Video
133. Data Centric Knowledge Management System (DCKMS)  Video
134. Event Tracker
135. DHL Courier System
136. Distributed DBA  Video
137. Distribution Business Automation System  Video
138. EAMCET Mock Counseling  Video
139. Face Identification  Video
140. EzHotels  Video
141. Graphic Media Player  Video
142. Employee Transaction Scenario
143. Hospital Management System  Video
144. Hostel Management Information System  Video
145. FAQ-O-Matic System  Video
146. Get Your Campus
147. Internet Banking  Video
148. Multi-Sensor Railway Track Geometry Surveying System  Video
149. Online Examination
150. Webs Eye
151. Stenography Using Image, Audio & Video  Video
152. Visa Processing Information System  Video
153. University Admission System
154. Telecom Connection System
155. Medi Tracker
156. Travel Management System
157. Online Railway Reservation System
158. Airline Reservation  Video
159. Travel Desk Management System
160. Alumni Information Database  Video
161.  Remote Desktop Administration  Video
162. Health Center Management system  Video
163. Payroll System
164. Self-Diagnosis with Advanced Hospital Management Video
165. 108 – Public Health Emergency Services
166. Water Marking
167. Intranet Chatting  Video
168. Online Banking  Video
169. Net Banking
170. Gateway Of Business Portfolio
171. Distributors Channel Management System
172. Online Doctor
173. Online Mobile Recharge Video
174. Patient Management System
175. Online Order Processing System (AJAX Enabled)
176. Virus Information System
177. Peer to Peer File Sharing Program  Video
178. An Agent Based Intrusion Detection, Response and Blocking using signature method in Active Net  Video
179. Telecom Business Information System
180. Online Telephone Management System
181. Online Tourism Guide Video
182. Online Taxicab Service
183. Online Registration For Voter Card
184. Safe Internet  Video
185. Mobility Management Approaches for Mobile IP Networks  Video
186. Local Service Center
187. Reseller Management System
188. Re-Ordering Of Packets Using Retransmission Timer
189. Online Crime Investigation
190. Revenue Collection and Recovery Services
191. E-education Video
192. Exam Branch Management System  Video
193. Home Improvement System  Video
194. Value Added Sales Tax Information System
195. E dues (E Billing System)  Video
196. Content Management System  Video
197. Train Information System  Video
198. Enterprise Resource Information System  Video
199. Global Interactive Solutions  Video
200. Global Communication Media
202. Hotel Management System Video
204. Retail-Management-System Video
205. Painting Application Video
206. Social Health Care Record Video
207. Reversible Watermarking Video
208. Audio Cryptography System Video
209. Monitoring Online Tests through Data Visualization Video
210. Alumni Management System Video
211. Product Service Management System Video
212. ATM Location System Video
213. Work in Progress Application Video
214. Chores Made Easy Video
215. E-Procurement Video
216. Emotion Detection Video
217. Institutional Infrastructural Information System Video
218. Placement Cell Video
219. Project Management System Video
220. Query Handling Video
221. Timetable Generation System Video
222. Online Staff Leave Management Video
223. PLACE Personal Learning Assistance Center Video
Posted on

Office Administration System VB.Net Project

Office Administration is campus administration software that manages college automation. This reduces the manpower requirement, cost, and waste of time.

Office Administration takes care of academic and administrative requirements on campus. Office Administration helps to maintain a paper-free administration. The software generates various certificates based on each module. Only the administrator has the right to use this software. This ensures more security and safety.

Office Administration automation software is content-rich, easy to use and has a user-friendly interface for easy navigation, and takes campus management to the next level.

Office Administration Project

This Office Administration maintains information using Common Application or another form, Maintain Academic/Educational Data, Maintain Personal/Family Data, Maintain and retrieve student information using unique ID for all students. Create custom reports. Maintain School Index Factors and minimum high school performance requirements for admission purposes.

We can generate and issue Certificates to Students / Employees by their ID no. The Certificates for Student is the Bonafide Certificate, Custodian Certificate, Expenses Certificate, and Transfer Certificate. The Certificates for Employee are OD Form, Experience Certificate, Leave Application, Salary cum Service Certificate, and Experience Certificate.

The preamble of the Project

OFFICE ADMINISTRATION software provides the facility to provide to maintain the data about Students (marks, fees, and personal details) and Employees (Salary and personal details) as well as College (Infrastructure and Bank details).

The objective of the project:

The project is intended to achieve the following objectives

  • Generate certificates dynamically just by providing Userid  to Administrator
    •  Maintain all the details of student and employee details
    • The details of all the students and employees have to be clearly maintained
    • i.e., each person  is provided with a unique username and password
    • Verification and validation of Administrator username and password are performed strictly.

Office Administration Software

PROBLEM DEFINITION 

Previous methods:

The following methods are Used:

The existing “OFFICE ADMINISTRATION” software can’t  maintain the Student details, Employee details, and College Details for Students it can manage marks details for every year and semester wise, Fee details, and Personal information, for an Employee it can’t  manage Salary, Experience details, and Personal information and for College it can’t manage Infrastructure, Bank details, etc on the  paper

Project approach motivation of the project:

                        The proposed system “OFFICE ADMINISTRATION” is the module of the main “OFFICE ADMINISTRATION” project. Here in this project, we provide paper-free work to end-user who uses this application by generating certificates just by providing the ID number and required details. After generating the certificate it asks the user “Do you need one more certificate”.

Conclusion and Future Enhancement 

Conclusion:

            The proposed system “Office Administration” is the module of the main “Office Administration”  with this we can provide paper-free work to the end-users compared to the previously existing “Office Administration” system.

Future Developments:

  • Provide multiple user interfaces
  • Support for large database
  • SQL  for database

Download the complete Office Administration System VB.Net Project Source code, report.

Posted on

JobSeek Web Application in Java

As we have implemented “JOBSEEK”  some of the new technologies will be needed for this change.

Proposed system is implemented using following hardware & software:

PROPOSED SYSTEM:

We developed the JOBSEEK software in HTML, JAVA SCRIPT, JAVA and MS Access:-

Activity Diagram for Placement Agency

The following are the advantages:-

1)      The system is user friendly.

2)      Efficient traceability.

3)      Data modification can be done very easily.

4)      Easy maintenance.

5)      No data redundancy.

6)      Less time consuming.

7)      Data is secure.

8)      Employee gets jobs easily.

JobSeek Webapplication

DATABASE DESIGN

Login Master:-

Description: This table stores the information details of   user id & password

Primary Key: User id

Data:

Attribute Type Description Width Constraints
User id Number User Id 50 Primary Key
Password Text User Password Na 50

  User Master:-

Description: This table stores the information details of    user

Primary Key: Id

Data:

Attribute Type Description Width Constraints
Userid Number Uers Id 50 Primary Key
Fname Number Uers first name 50
Mname Number UserMiddle name 50
Lname Number User Last name 50
Adds Number User adds 50
City Number User City name 50
State Number User State name 50
Pincode Number Pincode 50
Country Text County name 50
Phno Number Users PhnoNumber 50
Email Text User Email id 50
Dob Number User Date of  Birth 50
Sex Text Users Sex 50
Expt Number  No of Experiences   in year 50
Category Text User  Category 50
Location Text Users Location 50
Edlevel Text Education 50
Edstream Number User    Stream 50
Univ Text Users unversity 50
KeySkill Text Users skills 50

Comp Master:- 

Description: This table stores the information details of company

Primary Key: Id

Data:

Attribute Type Description Width Constraints
Compid Integer Company Id 50 Primary Key
CompName Text ComanyName 50
CompCategory Text Company Category 50
Adds Text Company address 50
Pincode Integer Company Pincode 50
Phone Integer Company phone number 50
Fax Integer Company Fax number 50
Url Integer Company Url 50
Emailid Text Company Email id 50
Nojob Text Number of job requied for company 50
Skillreq Text Skill requied 50
Categorytype Text Category  type 50
Jobdesc Text Job description 50
Pname Text Person name 50
Pdesig Text Person Designation 50
ptelephone Integer PersonTelephone number 50
Pemailid Integer Person email id 50
Compdese Text Company description 50
Indusry Text 50
Comptype Text Company type 50
Noemp Integer Number of employee required 50
Posted on

Team Crew Management Project in .Net

Scope :

Team crew management is similar to job portal management system developed in asp.net and sql server/ms access database.

There are two types of users.

  • Normal users who can apply for teams and company admin who can create teams and recruit members.
  • Users can register and login in the system. They can create and edit their profiles.
  • Company admin can create team and recruit members.
  • User can view teams and apply for teams.
  • Company can search for users and users can search for various companies.

Module Description:

Registration :

This Page is used when user first time wants to use the system.user has to first register in to the system and then he/she can use the system.in this case, user has to provide his/her details like user name,first name,last name and password that user wants to use while using the system. Both company and normal user have to register to use the system

Login :

This Page is used when user has registered into the system and wants to use the system.

In this case, user has to provide valid user name and password .after providing valid user name and password,system allows user to use the system.

Create Profile :

Both company admin and user need to create their profiles after they login. User can view company’s details and apply for teams. Company can view user’s details and approve him for team.

Create Team:

Company admin create teams as per requirement. Details for team are provided. Number of members for team is also specified.

Apply For Team :

User can view various company and teams available. User can apply for any team if it has a vacancy.

Search:

User can search various companies,Teams and other user to get information

Data Dictionary

  • Company Login
  • User LoginCompany Login Screenshot
  • Company
  • User
  • Team
  • Team Details
  • Vacancy
  • User Request

Output Screens:

  • Registration
  • Login
  • User Homepage
  • Company Homepage
  • Add New Team
  • Apply For Team
  • Edit Team
  • View User Details
  • View Company Details
  • View Team Details
  • View Request Status
  • Search Company
  • Search User
  • Change Password
  • Company Usage History
  • User History

Team Crew Management Login

[php]
View User Request for Team
using System;
using System.Web.Administration;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;</code>

namespace TeamCrewManagment
{
public partial class getuserReq : System.Web.UI.Page
{
string sql = null;
string constr = "Data Source=.\\SQLEXPRESS;AttachDbFilename=\\Team.mdf;Integrated Security=True;User Instance=True";
protected void Page_Load(object sender, EventArgs e)
{
try
{
sql = "select * from userreq where status like(‘Pending’)";
SqlConnection con = new SqlConnection(constr);
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader dr = null;

dr = cmd.ExecuteReader();
//lbluserid.DataBinding = dr;
drplist.DataSource = dr;
drplist.DataTextField = "userid";
drplist.DataValueField = "userid";
drplist.DataBind();
con.Close();
// lbluserid.Text = dr.GetSqlString(0);
//lbluserid.;

}
catch (Exception er)
{
lbl4.Text = "1"+er.Message;
}

}

protected void drplist_SelectedIndexChanged(object sender, EventArgs e)
{
}

protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
{
sql = "select * from userreq where userid=’" + drplist.SelectedValue + "’";
SqlConnection con = new SqlConnection(constr);
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
lbluserid.Text = ds.Tables[0].Rows[0].ItemArray[0].ToString();
txtSpeciality.Text = ds.Tables[0].Rows[0].ItemArray[1].ToString();
lblteamid.Text = ds.Tables[0].Rows[0].ItemArray[2].ToString();
Session["TT"] = lblteamid.Text;
con.Close();
}

protected void RadioButtonList1_SelectedIndexChanged(object sender, EventArgs e)
{

}
string leader = null;
int memno = 0;
int cnt=0;
public void inc()
{
string qury = "select count(teamid) from teammem where teamid=’"+lblteamid.Text+"’";
sql = "select teammember from team where teamid=’" + lblteamid.Text + "’";
SqlConnection ssc = new SqlConnection(constr);
ssc.Open();
SqlCommand sscmd = new SqlCommand(sql, ssc);
SqlDataAdapter ssda = new SqlDataAdapter(sscmd);
DataSet ssds = new DataSet();
ssda.Fill(ssds);
memno = int.Parse(ssds.Tables[0].Rows[0].ItemArray[0].ToString());
sscmd = new SqlCommand(qury, ssc);
ssda = new SqlDataAdapter(sscmd);
ssds = new DataSet();
ssda.Fill(ssds);
cnt = int.Parse(ssds.Tables[0].Rows[0].ItemArray[0].ToString());

}
string up;
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
inc();
SqlConnection con;
SqlCommand cmd;
DataSet ds;
SqlDataAdapter da;
if (memno &gt;= cnt)
{
try
{
if (RadioButtonList1.SelectedValue.Equals("Accept"))
{
up="update userreq set status=’"+RadioButtonList1.SelectedValue+"’ where userid=’"+lbluserid.Text+"’";
sql = "select teamleader from teammem where teamid=’" + lblteamid.Text + "’";

con = new SqlConnection(constr);
con.Open();
cmd = new SqlCommand(sql, con);

ds = new DataSet();
da = new SqlDataAdapter(cmd);
int cal = da.Fill(ds);
leader = ds.Tables[0].Rows[0].ItemArray[0].ToString();
if (cal &gt; -1)
{
cmd = new SqlCommand(up, con);
ds = new DataSet();
da = new SqlDataAdapter(cmd);
da.Fill(ds);
insertData();

}
}
if (RadioButtonList1.SelectedIndex == 1)
{
con = new SqlConnection(constr);
con.Open();
up = "update userreq set status=’" + RadioButtonList1.SelectedValue + "’ where userid=’" + lbluserid.Text + "’";
cmd = new SqlCommand(up, con);
ds = new DataSet();
da = new SqlDataAdapter(cmd);
da.Fill(ds);
}
}
catch (Exception oo)
{
lbl4.Text = oo.Message;
}
}
else
{
RadioButtonList1.SelectedIndex = 1;
Label6.Visible = true;
Label6.Text = "Team is Overflowing";
}
}
public void insertData()
{
lbl4.Text = leader;

sql = "insert into [teammem] values (‘" + replaceSingleQuote(lblteamid.Text) + "’,’" + replaceSingleQuote(leader) + "’,’" + replaceSingleQuote(lbluserid.Text) + "’)";
SqlConnection scon = new SqlConnection(constr);
scon.Open();
SqlCommand scmd = new SqlCommand(sql, scon);
DataSet sds = new DataSet();
SqlDataAdapter sda = new SqlDataAdapter(scmd);
int ff=sda.Fill(sds);
if (ff &gt; -1)
{
Response.Redirect("compHome.aspx");
}
}
public static String replaceSingleQuote(String fsQuote)
{
fsQuote = fsQuote.Trim();
int liStartingIndex = fsQuote.IndexOf("’", 0);
int liNextIndex = 0;
int liEvenIndex = 0;
while (liStartingIndex != -1)
{
liNextIndex = fsQuote.IndexOf("’", liStartingIndex + 1);
if (liNextIndex == -1 || liNextIndex != liStartingIndex + 1)
{ /*for qoute counted in bunch */
if (liEvenIndex % 2 == 0)
{ /* to insert single quote if quote count is odd */
fsQuote = fsQuote.Insert(liStartingIndex, "’");
}
liEvenIndex = 1;
}
if (liNextIndex == liStartingIndex + 1)
{ /* to increment value to be used at the time of inserting quote */
liEvenIndex++;
}
liStartingIndex = liNextIndex;
}
return fsQuote;
}

}
}

[/php]