Sanjeet Pandey

 Explain the difference between Server control and HTML control. Answer: Server events Server control events are handled in the server whereas HTML control events are handled in the page. State management Server controls can maintain data across requests using view state whereas HTML controls have no such mechanism to store data between requests. Browser detection Server controls can detect browser automatically and adapt display of control accordingly whereas HTML controls can’t detect browser automatically. Properties Server controls contain properties whereas HTML controls have attributes only.

 Explain the components of web form in ASP.NET Answer: Server controls The server controls are Hypertext Markup Language (HTML) elements that include a runat=server attribute. They provide automatic state management and server-side events and respond to the user events by executing event handler on the server. HTML controls These controls also respond to the user events but the events processing happen on the client machine. Data controls Data controls allow to connect to the database, execute command and retrieve data from database. System components System components provide access to system-level events that occur on the server.  Describe in brief .NET Framework and its components. Answer: .NET Framework provides platform for developing windows and web software. ASP.NET is a part of .Net framework and can access all features implemented within it that was formerly available only through windows API. .NET Framework sits in between our application progra...

Great ability develops and reveals itself increasingly with every new assignment.

Ability will never catch up with the demand for it.

SQL SQL JOIN The JOIN keyword is used in an SQL statement to query data from two or more tables, based on a relationship between certain columns in these tables. Tables in a database are often related to each other with keys. A primary key is a column (or a combination of columns) with a unique value for each row. Each primary key value must be unique within the table. The purpose is to bind data together, across tables, without repeating all of the data in every table. Eg.  SELECT column_name(s) FROM table_name1 INNER JOIN table_name2 ON table_name1.column_name=table_name2.column_name The SQL UNION Operator The UNION operator is used to combine the result-set of two or more SELECT statements. Notice that each SELECT statement within the UNION must have the same number of columns. The columns must also have similar data types. Also, the columns in each SELECT statement must be in the same order. SQL UNION Syntax SELECT column_name(s) ...