ASP.NET 2.0 Interview Preparation Guide

Download PDF

This done by

exec sp_rename 'oldTableName' , 'newTableName'

Use server side for secure validation. Use client side for fast,user friendly validations.

Execute sp_rename 'oldtablename', 'newtableaname'

Yeah Offcourse.Actually Webservices are independent to language. it depends on WSDL and SOAP. so any one can develope the Webservices anddisclose the wsdl and users can cosume the webservices.wsdl and soap both are xml based.. and all languages having xml parsing capability and access to http protocol will be able to work with Webservices

There are 2 types of cookies

Persistent and Non-persistent


there are 2 types they are
1. inmemory cookies
2. persistent cookies

Using Get Accessor

Public ReadOnly property item() as integer Get() Return.item End Get End Property

DisplayMember and ValueMember Properties need to be set.

DataTextField and DataValueField Property neeeds to be set

<asp:TemplateColumn>
<HeaderTemplate >
Somename
</HeaderTemplate>
<ItemTemplate>

<%# DataBinder.Eval(Container, "DataItem.columnname") %>
</ItemTemplate>

</asp:TemplateColumn>

itemCommand

Web Services Description Language

Web service use only three types of protocal. first HTTP-GET,HTTP-POST and SOAP.


Web Services Description Language

Server.Transfer

We use Soap standard to wrap calls to web service.Soap stands for Simple Object Access Protocol

HyperLink Column

Template column

In the target make the column as the key column and run the job.


delete table tablename where rowid not in Select * from tablename group by column name

It depends on your data and the type of operation your doing.

If you need to calculate a value for all the rows or for the maximum rows coming out of the source then go for a connected lookup.Or,if it is not so then go for unconnectd lookup.Specially in conditional case like,we have to get value for a field 'customer' from order tabel or from customer_data table,on the basis of following rule:

If customer_name is null then ,customer=customer_data.ustomer_Id

otherwise

customer=order.customer_name.

So in this case we will go for unconnected lookup

Gridview can display based on various colums avl in an single query or table. Also can customize it while can sort, edit, delete, insert. Datalist is a data bound list control that displays items using templates. Mainly it is all control bound.

DataList is using to list of all data in tree structure GridView is using to list of all value in table format

The main difference is that we can add more control over 1.1 for ex we can do master page,themes and generic classes we use 2.0 it can be comes for to add gridview

Concept of partial classes in .NET 2.0

ControlToValidate property and Text property

This is done explicitly by adding the below code Response.Cookies("Name") = "myCookie"
Response.Cookies("Name").Expires = DateAdd("m", 1, Now());

ErrorMessage and ControlToValidate

By setting the Cookie.Discard property false

cookie.discard=false

You must set the DataSource property and call the DataBind method

1. Object Initialization

2. Load Viewstate Data

3. LoadPostData Processes Postback Data

4. Object Load

5. Raise PostBack Change Events

6. Process Client-Side PostBack Event

7. Prerender the Objects

8. ViewState Saved

9. Render To HTML

10. Disposal