1. List out the different types of applications that can be created on .net?
.Net offers closely related but distinguishable suites of tools for building windows or web applications. Both are based on the premises that many application have user interfaces centered on interacting with the user through form and controls, such as buttons, list boxes, text, and so forth
2. What are the advantages in using a dataset?
Dataset is a subset of the entire database catched on your machines without a continuous connection to the database-disconnected architecture which reduce burden on the database server which may help your application scale well.
3. Define relational database?
A database is a repository of data. A relational database organizes your data into tables. Consider the north wind database provided with Microsoft SQL server and Microsoft access.
4. What are the advantages of ADO.NET?
The significant advantage to disconnecting your data architecture from your database. The biggest advantage is that your application, whether running on the web or on a local machine, will create a reduced burden on the database server which may help your application to scale well. A disconnected architecture is resource frugal.
5. What is declarative reference integrity?
Relational database use declarative reference integrity to establish constraints on the relationship among the various tables.
This helps avoid two types of mistakes.
First, you can’t enter a record with an invalid customer ID
Secondly, you can’t delete a customer record it that customerID is used in any order. The integrity of your data and its relationship is thus protected.
6. Define Data Adapter?
The dataset is an abstraction of relational data base.ADO.NET uses a data Adapter as a bridge between the dataset and data source, which is the underlying database.dataAdapter provides the Fill () method to retrieve data from the database and populate the dataset.
7. Define Data Reader?
The data reader provides connected, forward-only, read-only access to a Collection of tables. By executing either a SQL statement or stored procedures. Datareader is a lightweight object.
8. What are the advantages of web applications?
Ø They can be accessed from any browser that can connect to the server.
Ø Update can be made at the server
Ø You can achieve better performance by building a desktop application.
9. What is the step to create windows application?
First open visual studio and file ----->new ----> project.
In project window, create a new c# windows application and name it sharpwindowsform.
10. Differentiate between data reader and dataset?
The actually uses a data reader to populate itself. A data reader is lean, mean access methods that return results as soon as they are available, rather than for the whole of the query to be populated into a dataset.
11. How to implement the copy button event.
Now that you can check the files and pick the target directory,you are ready to handle the copy button-click event.The very first thing you need to do is to get a list of which files were selected .
12. What is ADO.NET?
ADO.NET looks very similar to ADO,its predecessor.they differences are that ADO.NET is native to .NET and that it is primarily a disconnected data architecture.data is retrieved from a database and cached on your local machine.
13. Define normalization.
Normalization not only makes your use of the database more efficient,but also it reduces the likelihood of data corruption.if you kept the customer’s name in both the customer table and the order table,you would run the risk that a change in one table might not be reflected in the order table.by keeping only the customerID in order,you are free to chage the address in customers,and the change is automatically reflected for each order.
14. Define SQL.
The most popular language for querying and manipulating database is SQL, usually pronounced ―Sequel‖.SQL is a declarative language,as opposed to a procedural language.the heart of SQL is query.query is statement that return a set of record from the database.
15. Define ADO.NET object model.
The ADO.NET object model is rich,but at its heart it is a fairly straightforward set of classes.the most important of these is dataset.the dataset represent a subset of the entire database,cached on your machine without a continous connection to the database.
16. Define DBCommand.
The DBCommand object allows you to send a command to the database.often these objects are implicitly create when you create a dataadapter, but you can explicitly access these object.
17. Define DBConnection.
The DBConnection objects represent a connection to data source. This connection can be shared among different command object.
18. Define Data tables and data columns.
The data table has a number of public properties, including the columns connection, which returns the data columns connection object .each data column object represent a column in a table.
19. Define rows.
Data table’s rows collection returns a set of rows for that table. use this collection to examine the results of queries against the database, iterating through the rows to examine each record in turn.
20. What are the advantages of ADO.NET model?
Highly efficient, but to be effective the dataset must be a robust subset of the database, capturing not just a few rows from a single table, but also a set of tables with all metadata necessary to represent the relationship and constraints of the original database.
21. Name the techniques used for reading and writing the XML Data.
XmlTextReader textReader = new XmlTextReader(―c:\\books.xml‖); XmlTextWriter textWriter = new XmlTextWriter(―c:\\myxmlfile.xml‖,null);
22. Distinguish between XML and ADO.net.
Ø ADO.NET is its ability to convert the data stored in the data source in XML.
Ø In native mode, record tables are stored as XML documents where schema and data are treated as distinct and replaceable elements.
Ø The ADO native storage format for the recordset is the Advanced Data Table Gram(ADTG)file format.