26/07/2011
24/07/2011
Why State Management ?
In traditional web programming information associated with the web page and with controls of page will be lost between post-backs.
Ex:-when user enters some text in text box (or) mark a check-box (or) selected an item in combo-box,that information(changes) will be lost in the round trip from client/browser to server.
To overcome this Asp.net Introduced severel methods to store data on the client-browser/server and retrieve from client-browser/server.
23/07/2011
| Job Posted | Company | Location | Position | Eligibility | Last Date | DETAILS |
|---|---|---|---|---|---|---|
| 20/8/11 | cognizant | All over India | Multi postions | B.E/B.Tech/B.Sc | 29/8/11 | Register |
| 8/8/11 | SoftSol | Hyderabad | Exp(1-2 Yrs) | B.E/B.Tech | ASAP | Register |
| 8/8/11 | cognizant | All over india | Freshers(2011) | BCA/BSC/MSC | 12/8/11 | Register |
| 8/8/11 | HCL | All over india | Freshers(2011) | B.E/M.Tech/MCA/B.Sc | ASAP | Register |
22/07/2011
Asp.net useful Tips
1)Use informative ALT attribute for every graphical representation(PNG files,JPEG files) to show who cant view these graphical representations.
21/07/2011
Difference between Dispaly:none and Visibility:hidden
Display : None Removes the
Visibility : Hidden Hides the element but it still takes up space in the document therefore affecting the layout.
Difference between APP_Code & APP_Data folders in ASP.Net ?
- App_code folder contains all .cs/.vb files and they will compile automatically when ever you change anything in the files within. code present in App_code folder is automatically referenced by asp.net web application.
- App_data folder is used to store files that can be used as database files(.mdf/xml files) .It will be created automatically when a new website is created.Developers use this folder for storing database used by Asp.net application.
Does dotnet support multiple inheritance?
- c# and vb does not support multiple inheritance.
- They supports only multiple interface inheritance.
How to delete duplicate rows from tables with no primary key!
Ans) Use SET ROWCOUNT value
Ex:- SET ROWCOUNT 2
DELETE FROM table_name WHERE somecolumn1=somecolumnvalue
SET ROWCOUNT 0
Imagine a table having 3 similar rows.The above delete statement executes 2 times deleting the extra 2 rows.Dont forget to set ROWCOUNT to 0 after succesfull query execution.
Ex:- SET ROWCOUNT 2
DELETE FROM table_name WHERE somecolumn1=somecolumnvalue
SET ROWCOUNT 0
Imagine a table having 3 similar rows.The above delete statement executes 2 times deleting the extra 2 rows.Dont forget to set ROWCOUNT to 0 after succesfull query execution.
17/07/2011
INDEX Statement
- Indexes are used to search/query the data from the table, without reading the entire table.
- Allows the application to find the data fast from database thereby increasing the query speed.
16/07/2011
DROP,DELETE & TRUNCATE
DROP:- Tables,Databases,Indexes can be easily removed using DROP Statement.
EX:-DROP TABLE table-name
Deletes table completely from database.
similarly DROP INDEX index-name
DROP DATABASE database-name
EX:-DROP TABLE table-name
Deletes table completely from database.
similarly DROP INDEX index-name
DROP DATABASE database-name
12/07/2011
What is a cookie ?
Cookie is a piece of information stored in the client computer/Browser which is limited to 4k in size.
Advatanges:-
There are 2 types of cookies
Advatanges:-
- very simple to implement
- Browser automatically arranges cookies stored for multiple sites
- It stores cookie data in simple text format,so its not secure.
- cookie size limited to 4 kb
- No. of cookies stored by browser are limited to 20.some allow 300,when a new cookie comes old one will be discarded,
There are 2 types of cookies
- Non-persistent(Temporary) cookies
- Persistent(Permanent) cookies
What is View State ?
View State is a technique used by asp.net webpage to persist changes to state of a webform between postbacks.
View state of page is by default stored in hidden form field named _viewstate.
ADVANTAGES:-
View state of page is by default stored in hidden form field named _viewstate.
ADVANTAGES:-
- Automatic retention of page and control state
- server resources not required.(View state can also be stored in server side.)
- The values in view state are compressed and hashed
- view state increases the page size since it is stored in the page itself.
- Although view state stores data in hashed format they can be tampered.
06/07/2011
What is the advantage of SET NOCOUNT ON ?
- Use Nocount at the begining of all your Stored procedures,Functions and Triggers
This intensifies when we have many operations(Insert,Update,Delete) in a stored procedure.That means each operation returns internal message within the stored procedure execution cycle.
Polymorphism
OverLoading and OverRiding are both examples of Polymorphism.
OVERLOADING -- Its a mechanism in which we can have 2 or more methods with same name.Thinking how,its possible using different parameter datatypes or different number of parameters or different order of parameters.
- OverRiding is Dynamic Polymorphism(executed at runtime)
- OverLoading is Static Polymorphism(executed at compile time)
OVERLOADING -- Its a mechanism in which we can have 2 or more methods with same name.Thinking how,its possible using different parameter datatypes or different number of parameters or different order of parameters.
Subscribe to:
Posts (Atom)
