.NET questiones

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Arpita123
    New Member
    • Jan 2008
    • 1

    .NET questiones

    1. What is the difference between connected and disconnected way of connection and which one is more advavtagious?

    2.If we open a connection, is it necessary to close the connection?Why?

    3.What is the function of ASAX?

    4.In .NET what is the function of XML?

    5.What is the Function of CSS?

    6.What is the function of ExecuteNonQuery ?

    Platform-.NET 2003
  • dip_developer
    Recognized Expert Contributor
    • Aug 2006
    • 648

    #2
    Originally posted by Arpita123
    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.........y our 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(Assyncrono us Javascript And XML)
    .....whenever you submit a webpage the whole page with all its information is submitted to the server........i f 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......y ou 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..........n ot the full page........you r 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.c om/xml/default.asp

    5.What is the Function of CSS?
    Ans : CSS (Cascading Style Sheets) is extremely useful for designing controls in .NET........sup pose you have 100 textboxes in you project......yo u 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.......yo u 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.

    Comment

    Working...