An Efficient Use of Intellisense through ASP.NET in SQL Reporting On Webpage
Journal Title: International Journal for Research in Applied Science and Engineering Technology (IJRASET) - Year 2015, Vol 3, Issue 6
Abstract
Database systems are designed to manage large bodies of information. Management of data involves both defining structures for storage of information and providing mechanisms for the manipulation of information. In addition, the database system must ensure the safety of the information stored, despite system crashes or attempts at unauthorized access. If data are to be shared among several users, the system must avoid possible anomalous results. Because information is so important in most organizations, computer scientists have developed a large body of concepts and techniques for managing data. In database we can write queries to extract data. But in our research we used stored procedures for better efficiency. The efficiency increases when we use stored procedure as they are stored in executed form and we run the report they give output but in case of query they executed everytime we run the report. The main purpose of this research is to help in report generation when we fetch data from database to view in the form of report. In the normal scenario when we want to generate report then there may be some parameters on the basis of which we fetch data. Without parameter the report is generated for the whole data at a time. Generally if we want to select data in parameter and the list of data is very large may be in thousands then at that time we have to first search the whole list to find that data. It will become very difficult and time consuming task for us to find the required data. By using this tool and technique which we have done in research we provide intellisense in searching which makes it easier to search. We just need to type alphabet of the required parameter and it will give you all the results related to that alphabet. Normally we can generate reports in SQL server data tool but by using Asp.net we can see or generate report on the webpage. This will help to display the report publically on the webpage.
Authors and Affiliations
Ankur Sharma, Rachna Dahiya
Keywords
Related Articles
- EP ID EP21003
- DOI -
- Views 215
- Downloads 5
Classification of River Water Quality Using Irrigation Indices – A Case Study of River Godavari
Rapid industrialization and growth of population put enormous pressure on water resources of the country. Because of inadequate surface water, the demand for ground water has increased. Eighteen ground water samples wer...
PLC Based Industrial Conveyor Automation and Monitoring
The paper presents the automatic segregation and directing of the materials using PLC. The materials on the conveyor belt are destined to different stages of manufacturing. The idea is to automate the process of conveyo...
Water Monitoring System for Hydroponics Agriculture
Hydroponics is a concept which is a part of hydro culture and is a method of growing plants in water , without soil using only the mineral nutrient solutions. The nutrients in hydroponics system can be from fish waste,...
Comparison of Vibration Performance of Modified Tuned Liquid Damper and Friction Damper
Structural response control with various forms of dampers have been a core area of study which was adopted to mitigate various natural hazards like wind and earthquake. Passive auxillary dynamic vibration absorbers have...
Parametric Study on Behaviour of Box Girder Bridges with Different Shape Based On Torsion
The present study focus on the behaviour of box Girder Bridge with different shape by keeping the span length constant. The bridge is modelled and analysed in SAP Bridge 2000 version 14. The cross section of the superst...