Interview FAQs

1. Data Source: It can be a database, text file, excel spread sheet or an XML file.

2. Data Provider: A set of libraries that is used to communicate with data source. Eg: SQL data provider for SQL, Oracle data provider for Oracle, OLE DB data provider for access, excel or mysql.

3. SQL Connection: It establishes connection.

4. SQL Command: It allows to manipulate database by executing stored procedure or sql statements.

5. SQL DataReader: It provides a forward-only, read-only, connected recordset.

6. DataSet: dataset is a disconnected, in-memory representation of data. It can contain multiple data table from different database.

7. SQL DataAdapter: It populates dataset from data source. It contains a reference to the connection object and opens and closes the connection automatically when reading from or writing to the database.

8. DataView: It provides a means to filter and sort data within a data table.

9. Disconnected Data Source: Ado.net makes the connection to the database server only when it needs to do a transaction and disconnects once the transaction is over (similar to an http connection over the internet). This greatly reduces the network traffic.

10. Strongly Typed Dataset Object: Strongly typed Dataset object allows you to create early-bound data retrieval expression. It is faster than late-bound data retrieval expression.

ASP.Net is a server side scripting technology that enables scripts (embedded in web pages) to be executed by an Internet server.

1. ASP.Net is a Microsoft Technology
2. ASP stands for Active Server Pages
3.ASP.Net is a program that runs inside IIS
4.IIS (Internet Information Services) is Microsofts Internet server

1. An ASP.Net file is just the same as an HTML file
2. An ASP.Net file can contain HTML, XML, and scripts
3. Scripts in an ASP.Net file are executed on the server
4. An ASP.Net file has the file extension ".aspx"
1. When a browser requests an HTML file, the server returns the file
2. When a browser requests an ASP.Net file, IIS passes the request to the ASP.Net engine on the server
3. The ASP.Net engine reads the file, line by line, and executes the scripts in the file
4. Finally, the ASP.Net file is returned to the browser as plain HTML.
The Page_Load event is one of many events that ASP.Net understands. The Page_Load event is triggered when a page loads, and ASP.Net will automatically call the subroutine Page_Load, and execute the code inside it.
The Page_Load subroutine runs EVERY time the page is loaded. If you want to execute the code in the Page_Load subroutine only the FIRST time the page is loaded, you can use the Page.IsPostBack property. If the Page.IsPostBack property is false, the page is loaded for the first time, if it is true, the page is posted back to the server (i.e. from a button click or by AutoPostBack of any server control on a form).

1. Page.IsPostBack = false means page is loaded first time.
2. Page.IsPostBack = true means result of round trip (PostBack).

The Hashtable object contains items in key/value pairs. The keys are used as indexes, and very quick searches can be made for values by searching through their keys.

Items are added to the Hashtable with the Add() method.

The SortedList object contains items in key/value pairs. A SortedList object automatically sort the items in alphabetic or numeric order.

Items are added to the SortedList with the Add() method. A SortedList can be sized to its final size with the TrimToSize() method.

The Repeater control is used to display a repeated list of items that are bound to the control. The Repeater control may be bound to a database table, an XML file, or another list of items.
The DataList control is, like the Repeater control, used to display a repeated list of items that are bound to the control. However, the DataList control adds a table around the data items by default. The DataList control may be bound to a database table, an XML file, or another list of items.
PreviousDisplaying 11 of 46Next
Need Help? Contact Us.

Log in


Forgot password?


New User