1. What is the difference between connected and disconnected way of connection and which one is more advavtagious?
Ans : If u maintain a continuous connection with your database server the unnecessary traffic overload will be there.........your database server can be connected with hundreds or thousands of clients and
if all are connected then the traffic will be huge...better connect your database whenever you need to
insert or fetch data...isn't it???
2.If we open a connection, is it necessary to close the connection?Why?
Ans : It is not necessary...but it is
recommended.......bacause maintaining a connection means continuous flow of data between two machines.....
3.What is the function of ASAX?
Ans : It is not ASAX....it is
AJAX(Assyncronous Javascript And XML)
.....whenever you submit a webpage the whole page with all its information is submitted to the server........if you dont redirect the webpage to some other page then the same page
loads again with all its controls and informations.........
suppose you have a webpage with loads of controls......you have a
DropDownList which you want to populate with the
Name of States of a selected
Country .......whenever you submit the page to
Select the corresponding State names the whole page will be submitted and loads again with the populated
DropDownList ........its totally useless.....
AJAX is a technology which will let you submit only the relevant portion of your web page..........not the full page........your program gets
faster through AJAX......
4.In .NET what is the function of XML?
Ans : XML (
Extensible Markup Language )has nothing special relevance in .NET......on a whole XML 's primary purpose is to facilitate the sharing of structured data across different information
systems, particularly via the Internet.
see this.....
www.w3schools.com/xml/default.asp
5.What is the Function of CSS?
Ans : CSS
(Cascading Style Sheets) is extremely useful for designing controls in .NET........suppose you have 100 textboxes in you project......you want a specific style(Font/Forecolour/BackColour etc) for these textboxes........you dont have to specify the styles in the code or through the
Properties window.......you just Create a CSS file and make your own style class with your needed attributes.......all you have to do is give the classname of your textboxes to that CSS class name.....
by doing so you will experience a lot of advantage whenever you need to change the style of your 100 textboxes............... just change the CSS........the change effect will be shown for all the controls immediately.........
but keep in mind that
CSS is not fully compatible to all browsers.......it is Browser dependant
6.What is the function of ExecuteNonQuery?
Ans : ExecuteNonQuery executes a
Transact-SQL statement against the provided connection and returns the
number of rows affected.