Skip to main content

Posts

Showing posts from May, 2010

Concept of web parts

Web part is a window of information inside webpage which can be edited, closed, minimised and dragged by the end user. We can say web part is providing the customization to the end user. Costomization can be,

You can add or remove the control from the web page.
Users can modify or edit the appearence of the window control
Cantrol can be dragged into the different position of the web page.

Different web part manager
The web part manager manages all the webpart on a web page. Its not visible, but it control evey operation of the web control from back ground. web part manager can be operated in different modes( Browse, display, edit, catalog, connect ).
      In browse mode we can not edit or drag the web part. In this mode we can only minimize and close the web part.
Code:- Dim wpManager as new webpartmanager
                   wpManager.Displaymode= WebpartManager.BrowseDisplayMode
In Design Mode we can drag and dropcontrols between webpart. Editor zone will provide this funcationality
In…

Data base questions Continue....

Cursors
      SQL statements are good for set at a time operations. So it is good for for handling a group of data. But there are scenarios when you want to update a row depending upon a some specific criteria, like loop through the rows and update the row. This time we are using cursors
There are different steps to create cursors
1.Declare
2.Open
3.Fetch
4.Operation
4.Close and deallocate.

Difference between delete and truncate statements?
Delete is data manipulation language
Truncate is  data definition language
Truncate Cannot be rollnacked while delete can be
Can not use trancate on a table referenced be foreign key
Delete table sysntax logs the delete, truncate table does not log any information but it logs information about deallocation of data page of table.
Delete can have criteria while truncate can not
Trucate reset the identity of the table, while delete do not reset the identity.

Some Database questions

Normalization Normalization is a set of rules used for the design of database tables and table are meant to be connected through relation ship. This set of rules are know as normalization. Normalization will avoid the repetitive entries, reduces the storage space, will avoid the need to restructure the table to accommodate new data. By doing the normalization you can increase the speed and flexibility of queries, summaries etc.
First normal form Data must be broken into the smallest unit as possible and should not contain any repetitive group of fields.
ID      Name                 Pet1   Pet2     Hours  Days  TotalHours/Week 1       Adarsh Soman    Cat    Cat2      5         5        25
Here name can be broken as first name and last name and pet repeating. So based on the first normal form the table will become as
ID      First Name      LastName  Pet    Hours  Days  TotalHours/Week 1        Adarsh           Soman       Cat       5         5        25
Second Normal Form
Each non key field shou…