Difference between Gridview,Datalist and Repeater In asp.Net

Difference between DataList and Repeater

DataList

Repeater

Rendered as Table.

Template driven.

Automatically generates columns from the data source.

This features is not supported.

Selection of row is supported.

Selection of row is not supported.

Editing of contents is supported.

Editing of contents is not supported.

You can arrange data items horizontally or vertically in DataList by using property RepeatDirection.

This features is not supported.

Performance is slow as compared to Repeater

This is very light weight and fast data control among all the data control.

Difference between GridView and Repeater

GridView

Repeater

It was introduced with Asp.Net 2.0.

It was introduced with Asp.Net 1.0.

Rendered as Table.

Template driven.

Automatically generates columns from the data source.

This features is not supported.

Selection of row is supported.

Selection of row is not supported.

Editing of contents is supported.

Editing of contents is not supported.

Built-in Paging and Sorting is provided.

You need to write custom code.

Supports auto format or style features.

This has no this features.

Performance is very slow as compared to Repeater.

This is very light weight and fast data control among all the data control.

Difference between GridView and DataList

GridView

DataList

It was introduced with Asp.Net 2.0.

It was introduced with Asp.Net 1.0.

Built-in Paging and Sorting is provided.

You need to write custom code.

Built-in supports for Update and Delete operations.

Need to write code for implementing Update and Delete operations.

Supports auto format or style features.

This features is not supported.

RepeatDirection property is not supported.

You can arrange data items horizontally or vertically in DataList by using property RepeatDirection.

Doesn’t support customizable row separator.

Supports customizable row separator by using SeparatorTemplate.

Performance is slow as compared to DataList.

Performance is fast is compared to GridView.

Using user control in asp.net C#

How to create User Control in ASP.Net

User control is powerful functionality of ASP.NET. With the help of the user control you can reuse the Design as well as code in the application. Developing User control is similar to developing form in ASP.NET. User control is created in markup file with .ascx extension.

<%@ Page Language="C#"%>

<!--First Step. You need to register the user control which you are using, here src is the path to the user control, tagName and tagPrefix are just text to declare the user control in the form-->

<%@ Register src="UserLogin.ascx" tagname="UserLogin" tagprefix="uc1" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head id="Head1" runat="server">

    <title>How To Make User Controls In ASP.NET</title>

    <script language="C#" runat="server">

        public void Page_Load(Object sender, EventArgs e)

        {

            //Print the time when the page loaded initially

            Response.Write("The Page Loaded at: " + DateTime.Now.ToLongTimeString());

        }

    </script>

    <style type="text/css">

    .button

    {

      border-radius:4px 4px 4px 4px;

      height:30px;

      padding:5px;

      font-size:14px;

      background-color:#6ca21e;

      color:#FFFFFF

    }

    body

    {

      background-color:#32373a;

      color:#FFFFFF;

    }

    #mainBody

    {

      background-color:#FFFFFF;

      height:100%;

      color:#32373a;

    }

    .UCHelp

    {

        height:150px;margin-top:20px;

        font-weight:bold;

    }

    .UserControlDiv

    {

        width:250px;margin:20px;padding:30px;border:1px solid Gray;background-color:#fdd136;

    }

    </style>

</head>

<body>

    <form id="form1" runat="server">

    <div id="mainBody">

        <h1>

            How To Make User Controls In ASP.NET

        </h1>

       

        <!-- Declaring the User control first time. The format is {tagprefix}:{tagname} which are defined above -->

        <uc1:UserLogin ID="UserLogin1" runat="server" />

       

        <div class="UCHelp">

        A user controls differs from an ASP.NET Web page in these ways:

            <ul>

                <li>

                    File name extension for a user control is .ascx.

                </li>

                <li>

                    ASP.NET uses @ Page directive, whereas user control contains an @ Control directive that defines configuration and other properties.

                </li>

                <li>

                    User controls cannot run as stand-alone files. Instead, you must add them to ASP.NET pages, as you would any control.

                </li>

                <li>

                    The user control does not have html, body, or form elements in it. These elements must be in the hosting page.

                </li>

            </ul>

        </div>

       

        <!-- Again reusing the same user controls, shows how it can be reused, so we can again declare the user control.-->

        <uc1:UserLogin ID="UserLogin2" runat="server" />

       

    </div>

    </form>

</body>

</html>

Introduction to HTTP Handlers

What is HTTP handler: Every request into an ASP.NET application is handled by a specialized component known as an HTTP handler. The HTTP handler is the most important ingredient while handling ASP.NET requests.


HttpHanlder is the low level Request and Response API to service incoming Http requests. All handlers implement the IHttpHandler interface. There is no need to use any extra namespace to use it as it contains in the System.Web namespace. Handlers are somewhat analogous to Internet Server Application Programming Interface (ISAPI) extensions.


Each incoming HTTP request received by ASP.NET is ultimately processed by a specific instance of a class that implements IHTTPHanlder. IHttpHanlderFactory provides the infrastructure that handles the actual resolution of URL requests to IHttpHanlder instances. In addition to the default IHttpHandlerFactory classes provided by ASP.NET, developers can optionally create and register factories to support rich request resolution.

Examples: ASP.NET uses different HTTP handlers to serve different file types. For example, the handler for web Page creates the page and control objects, runs your code, and renders the final HTML.

ASP.NET default handlers: 

1. Page Handler (.aspx) - Handles Web pages
2. User Control Handler (.ascx) - Handles Web user control pages
3. Web Service Handler (.asmx) - Handles Web service pages
4. Trace Handler (trace.axd) - Handles trace functionality

Why we need to create our own HTTP Handler: Sometime we need to avoid ASP.NET full page processing model, which saves lot of overheads, as ASP.NET web form model has to go through many steps such as creating web page objects, persisting view state etc. What we are interested into is to develop some low level interface that provides access to objects like Request and Response but doesn't use the full control based web form model discussed above.

Examples:

1. Dynamic image creator - Use the System.Drawing classes to draw and size your own images.
2. RSS - Create a handler that responds with RSS-formatted XML. This would allow you to add RSS feed capabilities to your sites.
3. Render a custom image,
4. Perform an ad hoc database query,
5. Return some binary data.

These examples extend the ASP.NET architecture but bypass the web-page model. The result is a leaner, more efficient component.

Where HTTP handlers are defined: All HTTP handlers are defined in the <httpHandlers> section of a configuration file which is nested in the <system.web> element.

<httpHandlers>
<add verb="*" path="trace.axd" validate="true" type="System.Web.Handlers.TraceHandler"/>
<add verb="*" path="*.config" validate="true" type="System.Web.HttpForbiddenHandler"/>
<add verb="*" path="*.cs" validate="true" type="System.Web.HttpForbiddenHandler"/>
<add verb="*" path="*.aspx" validate="true" type="System.Web.UI.PageHandlerFactory"/>
</httpHandlers>

1. Trace.axd : this handler is meant for rendering HTML page with a list of all the recently collected trace output, and this is handled by TraceHandler
2. .config: Handled by HttpForbiddenHandler
3. .cs: Handled by HttpForbiddenHandler
4. .aspx: Handled by PageHandlerFactory, which isn't a HTTP handler rather it's a class that will create the appropriate HTTP handler.

What is HTTP module: Help in processing of page request by handing application events , similar to what global.asax does. A request can pass through many HTTP modules but is being handled by only one HTTP handlers.



Use of HTTP Modules:

1. ASP.NET uses HTTP modules to enable features like caching, authentication, error pages etc.
2. <add> and <remove> tags can be used to add and inactive any http module from <httpmodule> section of a configuration file.

<httpModules>
<add name="OutputCache" type="System.Web.Caching.OutputCacheModule"/>
<add name="Session" type="System.Web.SessionState.SessionStateModule"/>
<add name="WindowsAuthentication"
type="System.Web.Security.WindowsAuthenticationModule"/>
<add name="FormsAuthentication"
type="System.Web.Security.FormsAuthenticationModule"/>
</httpModules>

Note: 

1. HTTP handler plays same role what ISAPI extension
2. HTTP module plays same role what ISAPI filters does.

How to write custom HTTP handler:

Step 1: What all we need to know before writing handlers

There are two type of handler you actually can make

1. Synchronous handler , which implement IHttpHandler interface
2. Asynchronous handler, which implement IHttpAsyncHandler. With asynchronous handlers additional requests can be accepted, because the handler creates a new thread to process each request rather than using the worker process

Further these Interfaces require us to implement the ProcessRequest method and the IsReusable property. 

1. The ProcessRequest method handles the actual processing for requests made.
   ASP.NET calls this method when a request is received. It's where the HTTP handlers perform all the processing. You can access the intrinsic ASP.NET objects (such as Request, Response, and Server) through the HttpContext object that's passed to this method.
    
2. Boolean IsReusable property specifies whether your handler can be pooled for reuse (to increase performance) or whether a new handler is required for each request.
   After ProcessRequest() finishes its work, ASP.NET checks this property to determine whether a given instance of an HTTP handler can be reused. If it returns true, the HTTP handler object can be reused for another request of the same type current. If it returns false, the HTTP handler object will simply be discarded.

Step 2: Create a ASP.NET web application and name it: SimpleHTTPHanlder

Step 3: Add a class and name it "SimpleHandler"

Step 4: Write below code



Here we are implementing IHttpHandler

Full code look like below
public class SimpleHandler : IHttpHandler    {        #region IHttpHandler Members

        bool IHttpHandler.IsReusable
        {
            get { return true; }
        }

        void IHttpHandler.ProcessRequest(HttpContext context)
        {
            HttpResponse response = context.Response;
            response.Write("<html><body><h1>Wow.. We created our first handler");
            response.Write("</h1></body></html>");
        }

        #endregion    }

Step 5: Configuring HTTP handler in configuration file;

We will add our handler in <httpHandlers> section
<httpHandlers>          <add verb="*" path="vishal.nayan" type="MyHttpHandler.SimpleHandler,MyHttpHandler"/></httpHandlers>

Now here we need to understand what these attributes means

1. Verb: indicates whether the request is an HTTP POST or HTTP GET request (use * for all requests).
2. Path : indicates the file extension that will invoke the HTTP handler
3. Type: identifies the HTTP handler class. This identification consists of two portions. First is the fully qualified class name , That portion is followed by a comma and the name of the DLL assembly that contains the class

Step 6: How to run our Handler

Well, visual studio doesn't allow us directly to run the handler, rather we need to run the project first and then explicitly type URL to request for handler, so in our case it is;

http://localhost:3238/myhttphandler/vishal.nayan



Now, can we create HTTPHanlder without configuring web.config file. Well yes. In visual studio we have a new item template to accomplish this. For this we can use the recognized extension .ashx. All requests that end in .ashx are automatically recognized as requests for a custom HTTP handler.



What is leeching: sites that steal bandwidth by linking to resources on your server .i.e. giving an image URL path from their server to your server, so when user tries to access that image, it's actually using your server resources.

Problem Scenario: As stated above, when any request for image is originated from same website then it's ok, but if the request is coming from another website, then there is a potential problem, as it is creating more work for your web server and reducing the bandwidth.

Solution: HTTP handler will refuse to serve the image or they substitute a dummy image if the referrer header indicates that a request originates from another site.

Add a generic handler from existing item and name it ImageHandler.ashx. Write the code below;
public class ImageHandler : IHttpHandler{
        public void ProcessRequest(HttpContext context)
        {
            HttpRequest request = context.Request;
            HttpResponse response = context.Response;

            string imageURL = null;
            // Perform a case-insensitive comparison.            if (request.UrlReferrer != null)
            {
                if(String.Compare(request.Url.Host, request.UrlReferrer.Host,true,CultureInfo.InvariantCulture) ==0)
                {
                    // The requesting host is correct.                    // Allow the image (if it exists).                    imageURL = request.PhysicalPath;
                    if (!File.Exists(imageURL))
                    {
                        response.Status = "Image Not Found";
                        response.StatusCode = 404;
                    }
                    else                    {
                    }
                }
            }
            if (imageURL == null)
            {
                // No valid image was allowed.                // Use the warning image instead.                // Rather than hard-code this image, you could                // retrieve it from the web.config file                // (using the <appSettings> section or a custom                // section).                 imageURL = context.Server.MapPath("~/images/notallowed.gif");
            }
            // Serve the image            // Set the content type to the appropriate image type.            response.ContentType = "image/" + Path.GetExtension(imageURL).ToLower();
            response.WriteFile(imageURL);
        }

        public bool IsReusable
        {
            get            {
                return false;
            }
        }}
Now its time to configure it. For this handler to protect image files, you need to register it to deal with the appropriate file types. Here are the web.config settings that set this up for the .gif and .jpg file types only.
<add verb="*" path="*.gif" type="SimpleHTTPHanlder.ImageHandler,SimpleHTTPHanlder"/><add verb="*" path="*.jpg" type="SimpleHTTPHanlder.ImageHandler,SimpleHTTPHanlder"/>

Now this configuration setting will only allow jpg and gif images, after checking it the request is originating from same website.

So now when we have to request any image , we simple type image URL and we can see that
http://localhost:3238/images/areng.jpg



The one which is not available, is greeted by not found image. Say for this image request which doesn't exists;
http://localhost:3238/images/areds.jpg



So by this HTTP handler for images, we can restrict any request which is not coming from our web site and also increase performance by quicker response time.

Create Data Script in SQL server

Right-click the database , select "Tasks", "Generate Scripts...". As you work through, you'll get to a "Scripting Options" section. Click on "Advanced", and in the list that pops up, where it says "Types of data to script", you've got the option to select Data and/or Schema.

Differences between Sql server 2005, 2008, 2008r2, 2012

Difference between Sql server 2005 and 2008

Difference between Sql server 2008 and 2008r2

Difference between Sql server 2008 and 2012

Difference between Sql server 2005 and 2008

Sr No	SQL Server 2005	SQL Server 2008
1	XML datatype is introduced.	XML datatype is used.
2	Can not encrypt the entire database.	Can encrypt the entire database introduced in 2008.
3	Datetime is used for both date and time.	Date and time are seperately used for date and time
4	No table datatype is included.	Table datatype introduced.
5	SSIS is started using.	SSIS avails in this version.
6	CMS is not available.	Central Management Server(CMS) is Introduced.
7	PBM is not available	Policy based management(PBM) server is Introduced.