Learn Dotnet

View State and Hidden Field

2013-11-25T08:25:00.002+05:30

View State and Hidden Field

The View State is client state mechanism in the ASP.Net statement management. The view state is control it will be used to maintain the state of the control across the posted back to the server.

The view state of a page is, by default, placed in a hidden form field named __VIEWSTATE.

Every time it needs to encryption and decryption (serialize and deserialize across the post backs).

The view state can be enabled by setting the property called EnableViewState="true/false".

It can be set in the machine config/ web config/ page directives/ control level.

By default it is false. The view state also can store the data using the key and value combination. The data will be serialized and stored in the hidden control you can view the source code page and find the hidden control with _viewstate.

Drawbacks: - Increase the page payload (when you have grid with many rows then everything has to be loaded and retain again with serialize and deserilize) - Additional overhead while serialize and deserialize. - Increase the memory allocation on the server.

The HiddenField control provides you with a way to store information in the page without displaying it. For example, you might store a user-preference setting in a HiddenField control. To put information into a HiddenField control, you set itsValue property to the value you want to store between postbacks. As with any other Web server control, the information in a HiddenField control is available during postback. The information is not persisted outside the page. The ASP.Net Hiddenfield will be created like this. That HTML hidden field will be defined like this. If you want to assign the value from the server side then hidName.Value = "Testing";

Difference Between For and Foreach loop

2013-08-17T14:32:00.001+05:30

For

1. If you want to access object by Index then use for loop.
2. To use For loop you must have know that how many times loop repeated.

Foreach

1. if you want to iterate object then use foreach loop.
2. in for each no need to know about total loop repeating.

Performance wise for loop is faster then foreach.

Implementing Zoom functionality in asp.net

2012-12-07T16:54:00.003+05:30

Zoom functionality in asp.net

1. Write the Below code in the <head> Tag
<script type="text/javascript">
        function BrowserZoomPluse() {
           nzoom = parseInt(divTest.style.zoom) + 30 + '%';
            divTest.style.zoom = nzoom ;
        }
        function BrowserZoomMinuse() {
            nzoom = parseInt(divTest.style.zoom) - 10 + '%';
            divTest.style.zoom = nzoom ;
        }
        function ResetZoom() {
            nzoom = parseInt(divTest.value);
            divTest.style.zoom = '100%';
        }
    </script>
2. Add the below Code inside the <body> tag
<div id="divTest" style="zoom: 100%">
        <div class="textsize">
         <a href="javascript:void(0);" onclick="BrowserZoomPluse();">
                Zoom + </a>
                 <a href="javascript:void(0);" onclick="BrowserZoomMinuse();">
                Zoom - </a>
            <a href="javascript:void(0);" onclick="ResetZoom();">
               Reset </a>
        </div><br />

</div>
3. Run the Page and click on Zoom In ,Zoom Out and Reset

Note: zoom works on chrome ,safari and IE .

Difference between Layered Architecture and N-Tier Architecture

2012-09-24T12:23:00.003+05:30

Layered Architecture vs N-Tier Architecture

Layered Architectural Style

Layers are the separation of code or you can say organize your come.

Layers may be residing in same computer (1 tier) or in separate computer (N- Tier). In the Application each layer communicates with other layer.

For example, normally in the application following layer is defined

Presentation Layer (UI)

· Business Layer

· Data Access Layer

N-Tier Architectural Style

In the N-Tier each layer can be deployed on separate computer. In N-Tier application is logically separated into minimum three layers. Each layer is responsible for specific functionality.

Example in Web application security is important so the business layer is deployed behind firewall, and presentation layer is on separate network.

Advantages of a layered architecture:

Layered architecture provides flexibility, maintainability, and scalability.

Layered architecture parallel team works on different part of application.

Layered architecture is loosely coupled.

Disadvantages of a layered architecture:

Performance is slower because extra overhead.

Conditional CSS or browser based CSS

2012-09-10T15:15:00.003+05:30

Conditional CSS or browser based CSS

1. Browser for CSS

· 'IE' - Internet Explorer

· 'Gecko' - Gecko based browsers (Firefox, Camino etc)

· 'Webkit' - Webkit based browsers (Safari, Chrome, Shiira etc)

· 'SafMob' - Mobile Safari (iPhone / iPod Touch)

· 'Opera' - Opera's browser

· 'IEMac' - Internet Explorer for the Mac

· 'Konq' - Konqueror

· 'IEmob' - IE mobile

· 'PSP' - Playstation Portable

· 'NetF' - Net Front

2. Condition - arithmetic operator

· lt - Less than

· lte - Less than or equal to

· eq - Equal to

· gte - Greater than or equal to

· gt - Greater then

Example:

Conditional CSS syntax

[if IE] - Used if the browser is IE

[if Gecko] - Used if the browser is not Firefox

[if IE 5] - Used if browser is IE 5

[if lte IE 6] - Used if the browser is IE 6 or less (IE 5, IE 4 etc)

[if gt IE 6] - Used if the browser is IE 6 or grater

How to use it

1. <!--[if IE]>

.backTable

{

margin-top: -185px!important;

}

<![endif]-->

2. <!--[if IE]>

<![endif]-->

3. <style>

.backTable td span

{

display:none;

position:absolute;

margin-top:-175px;

-webkit-margin-before:-185px;

margin-left:100px;

}

.icon

{

display: -moz-inline-box;

}

</style>

Note: webkit,Gecko etc does not support all style. Please find out supported style.

How to refresh parent page on close of popup window by toolbar close button

2012-09-10T10:29:00.003+05:30

How to refresh parent page on close of popup window by toolbar close button

1. Create a Page default.aspx

<!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 runat="server">
    <title></title>
    <script type="text/javascript">
        //Method is used for Open a Url in Popup window.
        function openPopup() {
            open('Default2.aspx', "Page", "status=1, width=350, height=150, top=300, left=500,location=no,resizable=yes,scrollbars=1,toolbar=no,directories=no,status=no,menubar=no");
        }
    </script>
</head>
<body>
    <form id="form1" runat="server">
    <a href="javascript:openPopup()">Open Popup Window</a>

    </form>
</body>
</html>

2. Create pop window page default2.aspx

<!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 runat="server">
    <title></title>
    <script type="text/javascript">
         window.onbeforeunload = function () {
             window.opener.location.href = window.opener.location.href;
         }
    </script>

</head>
<body>
    <form id="form1" runat="server">
    This is a Test Page

    </form>
</body>
</html>

Display multiple marker point on Google Map with same location or same Longitude,Latitude

2012-08-30T16:27:00.002+05:30

Display multiple marker point on Google Map with same location or same Longitude, Latitude

<!DOCTYPE html>
<html>
<head>
    <title>Google Map</title>

<style type="text/css">
    #map_canvas
    {
        height: 450px;
        width: 980px;
    }
    .infowindow
    {
        font-size: 12px;
        width: 200px !important;
        font-family: verdana;
    }
    @media print
    {
        #map_canvas
        {
            height: 950px;
        }
    }
</style>

<script src="http://maps.google.com/maps/api/js?v=3.7&sensor=false" type="text/javascript"></script>

<script src="JS/oms.min.js" type="text/javascript"></script>
<script type="text/javascript">
    window.onload = function () {

        var mapOptions = {
            //zoom: 5,
            //set maximum zoom level
            maxZoom: 6,
            center: new google.maps.LatLng(37.09024, -95.712891),
            mapTypeId: google.maps.MapTypeId.ROADMAP
        };

        var gm = google.maps;
        var map = new gm.Map(document.getElementById('map_canvas'), mapOptions);

        var iw = new gm.InfoWindow();
        var oms = new OverlappingMarkerSpiderfier(map,
        { markersWontMove: true, markersWontHide: true });

        var usualColor = 'FF776B';
        var spiderfiedColor = 'ffee22';
        var iconWithColor = function (color) {
            return 'http://chart.googleapis.com/chart?chst=d_map_xpin_letter&chld=pin|+|' +
          color + '|000000|ffff00';
        }
        var shadow = new gm.MarkerImage(
        'https://www.google.com/intl/en_ALL/mapfiles/shadow50.png',
        new gm.Size(37, 34), // size - for sprite clipping
        new gm.Point(0, 0), // origin - ditto
        new gm.Point(10, 34) // anchor - where to meet map location
      );

        oms.addListener('click', function (marker) {

            iw.setContent(marker.desc);
            iw.open(map, marker);
        });
        oms.addListener('spiderfy', function (markers) {

            for (var i = 0; i < markers.length; i++) {
                markers[i].setIcon(iconWithColor(spiderfiedColor));
                markers[i].setShadow(null);
            }
            iw.close();
            //set bubble collapse or not
            oms.keepSpiderfied = true;
        });
        oms.addListener('unspiderfy', function (markers) {

            for (var i = 0; i < markers.length; i++) {
                markers[i].setIcon(iconWithColor(usualColor));
                markers[i].setShadow(shadow);
            }
        });

        var bounds = new gm.LatLngBounds();
        for (var i = 0; i < window.mapData.length; i++) {
            var datum = window.mapData[i];
            var loc = new gm.LatLng(datum.lat, datum.lon);
            bounds.extend(loc);
            var marker = new gm.Marker({
                position: loc,
                title: datum.h,
                map: map,
                icon: iconWithColor(usualColor),
                shadow: shadow
            });
            marker.desc = datum.d;
            oms.addMarker(marker);
        }
        map.fitBounds(bounds);

        // for debugging/exploratory use in console
        window.map = map;
        window.oms = oms;
    }
</script>

</head>
<body>
    <table>
       <tr>
            <td>
                
                <table >
                    <tr>
                        <td class="map">
                            <div id="map_canvas">
                            </div>
                            <asp:HiddenField ID="hfcluster" runat="server"></asp:HiddenField>
                        </td>
                    </tr>
                </table>
            </td>
        </tr>
    </table>
    <script type="text/javascript">
        // randomize some overlapping map data -- more normally we'd load some JSON data instead
        var baseJitter = 2.5;
        var clusterJitterMax = 0.1;
        var rnd = Math.random;
        var data = [];
        //store the Longitude,Latitude,TotalNoOfRecords for same Longitude Latitude,Address
        var loc = document.getElementById("hfcluster").value;
        var langlatarray = loc.split("|");

        for (var i = 0; i < langlatarray.length; i++) {
            var arrlanglat = langlatarray[i].toString().split("%");
            //Get Longitude
            var baseLon = arrlanglat[0];
            //Get Latitude
            var baseLat = arrlanglat[1];
            //Get TotalNoOfRecords
            var totalcount = arrlanglat[2];
            //Get Address example <div class='infowindow'> Address on click of marker point</div>
            var address = arrlanglat[3];
            var clusterJitter = clusterJitterMax * rnd();
            for (var j = 0; j < totalcount; j++) data.push({
               // lon: baseLon - clusterJitter + rnd() * clusterJitter,
               // lat: baseLat - clusterJitter + rnd() * clusterJitter,
                   lon: baseLon,
                   lat: baseLat,
                //used fro tooltip
                h: address,
                //used to display the in popup
                d: address
            });
        }
        window.mapData = data;
    </script>
</body>
</html>

Check Session Timeot for Whole Application

2012-08-24T11:19:00.000+05:30

1. Create a BasePage.cs in App_Code and write the following code

        protected void Page_Init(object sender, EventArgs e)
        {
            if (Context.Session != null)
            {
                if (Session.IsNewSession)
                {
                    HttpCookie newSessionIdCookie = Request.Cookies["ASP.NET_SessionId"];
                    if (newSessionIdCookie != null)
                    {
                        string newSessionIdCookieValue = newSessionIdCookie.Value;
                        if (newSessionIdCookieValue != string.Empty)
                        {
                            //This means Session was timed Out and New Session was started
                            Response.Redirect("Home.aspx");
                        }
                    }
                }
            }
        }

2. Inherit this basepage on all the aspx pages such as
using System;
using System.Collections.Generic;
using System.Collections;
using System.Linq;
using System.Linq.Expressions;
using System.Web;
using System.Data;
using System.Web.UI;
using System.Web.UI.WebControls;
using VAS.BLL;
using VAS.DAL;
using VAS.PL;

public partial class _Default: BasePage
{
         ///body
}

About CAML in Sharepoint?

2012-07-24T17:09:00.001+05:30

What is CAML in Sharepoint?

CAML is Collaborative Application Markup Language and is an XML-based query language that is used in SharePoint. CAML is used to querying, build and customize the SharePoint sites.

Writing CAML Query

CAML root element is <Query>. CAML query has 2 parts

1.       Sort  (For sorting use <OrderBy>)

2.        Filter
 (For filter use <Where>)

Basic syntax for CAML query

< [Operator]>
<FieldRef Name=’ [Title]’/><Value Type=’ [Data Type] ‘> [Value] </Value>
</ [Operator]>

Operators in CAML

Logical Operators

And

Comparison Operators

Eq =Equals

Neq =Not equal

Gt=Greater than

Geq =Greater than or equal

Lt =Lower than

Leq =Lower than or equal too

IsNull = is null

IsNotNull = is not null

BeginsWith=Begins with

Contains=Contains

BeginsWith = begins with

DateRangesOverlap= compare the dates

In= value of a list item

Includes= specified field is a Lookup field that allows multiple values

NotIncludes=

Membership= filter based on the type of membership.

Group operator

GroupBy= grouping the data

Example

1 Filter

<Where>

    <Eq>

     <FieldRef Name='Country' />

     <Value Type='Lookup'>India</Value>

  </Eq>

</Where>

2 Sort

<OrderBy>

   <FieldRef Name=''Country' Ascending='False' />

</OrderBy>

Automatically Jquery close alert /dialog box

2012-07-11T16:50:00.002+05:30

Automatically Jquery close alert /dialog box

//Add below html code into body

<asp:Label ID="lblMessage" runat="server" Text="Record Inserted Successfully"></asp:Label>

</div>

//add below code into head

function DisplayPOP() {

var mydiv = $('#dialog1');

mydiv.css('display', 'block');

mydiv.dialog({ autoOpen: false, height: 20, width: 300 });

mydiv.dialog('open');

//send the time

AutoCloseDialogBox(3000);

return false;

}

function AutoCloseDialogBox(WaitSeconds) {

setTimeout(function () { $("#dialog1").dialog("close"); }, WaitSeconds);

}

</script>

How to Encrypt and Decript web.config connection string?

2012-07-04T18:13:00.002+05:30

How to Encrypt and Decript web.config connection string?

web.config
<connectionStrings>
   <add name="connection" connectionString="data source=localhost;initial catalog=test;uid=sa;pwd=abcxyz"   providerName="System.Data.SqlClient" />
</connectionStrings>

Add Two Button Encrypt and Decript in asp.net and write the code such as
protected void btnEncript_Click(object sender, EventArgs e)
    {
        Configuration config = WebConfigurationManager.OpenMappedWebConfiguration(GetWebConfigMappedPath(), "/");
        ConfigurationSection appSetting = config.GetSection("connectionStrings");
        appSetting.SectionInformation.ProtectSection("DataProtectionConfigurationProvider");
        config.Save();
    }
    protected void btnDecript_Click(object sender, EventArgs e)
    {
        Configuration config = WebConfigurationManager.OpenMappedWebConfiguration(GetWebConfigMappedPath(), "/");
        ConfigurationSection appSetting = config.GetSection("connectionStrings");
        appSetting.SectionInformation.UnprotectSection();
        config.Save();
    }

    private WebConfigurationFileMap GetWebConfigMappedPath()
    {
        string webConfigPath = Server.MapPath("Web.config");
        FileInfo configFile = new FileInfo(webConfigPath);
        VirtualDirectoryMapping virtualpath = new VirtualDirectoryMapping(configFile.DirectoryName, true, configFile.Name);
        WebConfigurationFileMap webconfigMap = new WebConfigurationFileMap();
        webconfigMap.VirtualDirectories.Add("/", virtualpath);
        return webconfigMap;
    }

SharePoint 2007 Object Model

2012-06-25T16:50:00.002+05:30

SharePoint 2007 Object Model

Through SharePoint object model programmatically access the SharePoint data into asp.net or any other server process. To access the SharePoint data we need to add SharePoint Microsoft.SharePoint.dll which is found under

<Installed Drive>:\Program Files\Common Files\Microsoft Shared\web server extensions\12\ISAPI\

SharePoint object model grouped in two categories:

1. Server Architecture

2. Site Architecture

Server Architecture Object Model: The server architecture object model access “Microsoft.SharePoint.Administration” Namespace

1. 1. Farm

a. SPFarm

2. 2. Server

a. SPServer

3. 3. Services

a. SPServices

4. 4. Web Service

a. SPWebService

5. 5. Database Service Instance

a. SPServiceInstance

b. SPDatabaseServiceInstance

6. 6. Web Applications

a. SPWebApplication

b. SPAdministrationWebApplication

7. 7. Content DataBase

a. SPDatabase

b. SPContentDatabase

8. 8. SiteCollection

a. SPSite

Site Architecture Object Model:All Site Architecture objects and collections are available in the “Microsoft.SharePoint” namespace.

1. Site Collection: This collection of sites is known as “Site Collection”.

SPSite object can be instantiated by following methods

· SPSite objSPSite = new SPSite("Site URL");

· SPSite objSPSite = SPContext.Current.Site;

· SPSiteCollection objSiteCollection = objWebApplication.Sites;

int index = 0;

SPSite objSite = objSiteCollection[index];

2. Sub Sites: Each SharePoint website is represented by SPWeb object whether it is a top level website or a sub site. SPWeb object has a Webs property that returns a collection of other SPWeb objects

SPWeb object can be instantiated by following methods

a. SPSite objSPSite = new SPSite("Site URL");

SPWeb myWeb = objSPSite.OpenWeb();

3. 3. List(Each SPList object has members that are used to manage the list or access items in the list)

SPList myList = myWeb.Lists["My First List"];

4. 4. Fields: Each SPField object has members that contain settings for the field

SPList mylist = myweb.Lists.TryGetList("Announcements");

                                               SPField fld = mylist.Fields[SPBuiltInFieldId.Expires];

5. 5. List Item: Represents a single row in the list

SPList myList = myWeb.Lists["My First List"];

SPListItem myListItem = myList.Items[5];

Comparing cursor vs. WHILE loop performance

2012-06-22T16:54:00.001+05:30

Cursors

Cursors are a looping construct built inside the database engine and come with a wide variety of features. Cursors allow you to fetch a set of data, loop through each record, and modify the values as necessary; then, you can easily assign these values to variables and perform processing on these values. Depending on the type of cursor you request, you can even fetch records that you’ve previously fetched.
Because a cursor is an actual object inside the database engine, there is a little overhead involved in creating the cursor and destroying it. Also, a majority of cursor operations occur in tempdb, so a heavily used tempdb will be even more overloaded with the use of cursors.
The types of cursors used are very important in terms of performance. Below is a list of the available cursor types as listed on

FORWARD_ONLY

Specifies that the cursor can only be scrolled from the first to the last row. FETCH NEXT is the only supported fetch option. If FORWARD_ONLY is specified without the STATIC, KEYSET, or DYNAMIC keywords, the cursor operates as a DYNAMIC cursor. When neither FORWARD_ONLY nor SCROLL is specified, FORWARD_ONLY is the default, unless the keywords STATIC, KEYSET, or DYNAMIC are specified. STATIC, KEYSET, and DYNAMIC cursors default to SCROLL. Unlike database APIs such as ODBC and ADO, FORWARD_ONLY is supported with STATIC, KEYSET, and DYNAMIC Transact-SQL cursors.

STATICDefines a cursor that makes a temporary copy of the data to be used by the cursor. All requests to the cursor are answered from this temporary table in tempdb; therefore, modifications made to base tables are not reflected in the data returned by fetches made to this cursor, and this cursor does not allow modifications.

KEYSETSpecifies that the membership and order of rows in the cursor are fixed when the cursor is opened. The set of keys that uniquely identify the rows is built into a table in tempdb known as the keyset. Changes to nonkey values in the base tables, either made by the cursor owner or committed by other users, are visible as the owner scrolls around the cursor. Inserts made by other users are not visible (inserts cannot be made through a Transact-SQL server cursor). If a row is deleted, an attempt to fetch the row returns an @@FETCH_STATUS of -2. Updates of key values from outside the cursor resemble a delete of the old row followed by an insert of the new row. The row with the new values is not visible, and attempts to fetch the row with the old values return an @@FETCH_STATUS of -2. The new values are visible if the update is done through the cursor by specifying the WHERE CURRENT OF clause.

DYNAMICDefines a cursor that reflects all data changes made to the rows in its result set as you scroll around the cursor. The data values, order, and membership of the rows can change on each fetch. The ABSOLUTE fetch option is not supported with dynamic cursors.

FAST_FORWARDSpecifies a FORWARD_ONLY, READ_ONLY cursor with performance optimizations enabled. FAST_FORWARD cannot be specified if SCROLL or FOR_UPDATE is also specified.
READ_ONLYPrevents updates made through this cursor. The cursor cannot be referenced in a WHERE CURRENT OF clause in an UPDATE or DELETE statement. This option overrides the default capability of a cursor to be updated.
SCROLL_LOCKSSpecifies that positioned updates or deletes made through the cursor are guaranteed to succeed. SQL Server locks the rows as they are read into the cursor to ensure their availability for later modifications. SCROLL_LOCKS cannot be specified if FAST_FORWARD or STATIC is also specified.

OPTIMISTICSpecifies that positioned updates or deletes made through the cursor do not succeed if the row has been updated since it was read into the cursor. SQL Server does not lock rows as they are read into the cursor. It instead uses comparisons of timestamp column values, or a checksum value if the table has no timestamp column, to determine whether the row was modified after it was read into the cursor. If the row was modified, the attempted positioned update or delete fails. OPTIMISTIC cannot be specified if FAST_FORWARD is also specified.

WHILE loops

A WHILE loop is a programming construct that you’re likely familiar with from other programming languages. You define a condition at the beginning of the loop, and iteration will occur so long as this condition remains to be true.
WHILE loops are as easy to use as a cursor, but sometimes these constructs are a little more difficult to read and/or to understand, as a query must occur on the base table(s) that must fetch a single next row. This type of operation is very tricky to do in situations where your underlying base table does not have a primary key column (which it should have).
WHILE loops don’t provide some of the bells and whistles that come with cursors, such as the ability to easily go “backward” in the result set. Although, I’ve never been in a situation in which I did anything other than a straight loop through a result set with a cursor.
One advantage of the WHILE loop is that no objects must be created in memory to facilitate the looping through a set of records as is necessary with a cursor.

What is Abstraction and Encapsulation

2012-06-22T16:48:00.002+05:30

Abstraction:

Hides the implementation details of your methods. Provides a base to variations in the application which can grow over a period of time.

Abstraction is virtual class design.

Before actually defining class, developer will think about what all properties, methods and event will be there in my class.

Example :

public abstract class Automobile

{

//Properties

public int DoorCount { .. }

public string EngineType { .. }

public float Height { .. }

public float GasTankSize { .. }

public float WheelBase { .. }

public float WheelSize { .. }

//Abstract Properties

public abstract string BodyType { get; }

//Methods

public float CalculateFuelEfficiency(int lastMileage);

}

The Automobile class is the interface, in that it defines an interface that classes will derive from. You can't directly instantiate it through new Automobile() because it's not an implementation.
It's important to note the BodyType property. This property is declared abstract, meaning that any derived implementation must override it and return some relevant string.
From the example above, let's say we want a higher level of abstraction

Encapsulation:

Hides the private data elements of the class and exposes only the required things to the clients.
At the time of class definition, developer will think about which should display to end user and which should not.

In Short Abstraction is "Collection of data" and Encapsulation is "Exposure (or grouping) of data in appropriate access specifier".

In this Data is sent to a method, a lot of work goes on using the data, of which you don't know or care about. An output is returned to the caller. That is the process of encapsulation, or information hiding.
Example :
public class MultiLineString
{
private CollectionBase<string> _lines = null;
private bool _allowEmptyLines = false;
private static object _lock = new object();
public bool AllowEmptyLines
{
     get { return _allowEmptyLines; }     set { _allowEmptyLines = value; }
}

public int LineCount
{
   get { return _lines.Count; }
}

public string this[int index]
{
   get { return _lines[index]; }
}
public MultiLineString(string text) : this(text, false) { }
public MultiLineString(string text, bool allowEmptyLines)
{
   _allowEmptyLines = allowEmptyLines;
   _lines = new CollectionBase<string>();
   if (!allowEmptyLines)
   {
     string[] lines = text.Split('\n');
     foreach (string line in lines)
     {
       if (line != null)
         this.Add(line);
       else if (line == '\r' && this.AllowEmptyLines)
         this.Add(string.Empty);
     } } }
public MultiLineString(StringBuilder builder) : this(builder, false) { }
public MultiLineString(
   StringBuilder builder,
   bool allowEmptyLines) : this(builder.ToString(), allowEmptyLines) { }
public void AddLine(string line)
{
   if (!this.AllowEmptyLines && string.IsNullOrEmpty(line))
     throw new ArgumentNullException("line");
   lock (_lock)
   {
     _lines.Add(this.TrimLine(line));
   } }
public void RemoveLine(int index)
{
   lock (_lock)
   {
     _lines.RemoveAt(index);
   }
}
public override string ToString()
{
   string output = string.Empty;
   foreach (string line in lines)
     output += line + "\n";
   return output;
}
private string TrimLine(string line)
{
   return line.Trim(new char[] { ' ', '\t', '\r' });
}}

Why is encapsulation important? Using the above example, it would be really easy to change the underlying source to use a database, XML file, text file, or another data store, without breaking any code that the developer may have created.

Advantages and Disadvantages of LINQ

2012-06-22T16:44:00.004+05:30

Advantages

Quick turn around for development
It is a cleaner and typesafety.
Queries can be dynamically
Tables are automatically created into class
Columns are automatically created into properties
Relationship are automatically appeaded to classes
Lambda expressions are awesome
Data is easy to setup and use
It is checked by the compiler instead of at runtime
It can be debugged easily.
It can be used against any datatype - it isn't limited to relational databases, you can also use it against XML, regular objects.
It can able to query not just tables in a relational database but also text files and XML files.

Disadvantages

No clear outline for Tiers
No good way of view permissions
Small data sets will take longer to build the query than execute
There is an overhead for creating queries
When queries are moved from sql to application side, joins are very slow
DBML concurrency issues
Hard to understand advance queries using Expressions
LINQ sends the entire query to the DB hence takes much network traffic but the stored procedures sends only argument and the stored procedure name. It will become really bad if the queries are very complex.
Preformance is degraded if we don't write the linq query correctly.
If you need to make changes to the way you do data access, you need to recompile, version, and redeploy your assembly

How to use Join with LINQ

2012-06-18T14:57:00.001+05:30

using System;

using System.Linq;

using System.Configuration;

public partial class LINQWithJoin : System.Web.UI.Page

{

TestDataClassesDataContext objDBContext = new TestDataClassesDataContext(ConfigurationManager.ConnectionStrings["TestConnectionString"].ToString());

protected void Page_Load(object sender, EventArgs e)

{

}

protected void btnDisplay_Click(object sender, EventArgs e)

{

var Allcity = from city in objDBContext.City_Tbls join state in objDBContext.State_Tbls on city.State_Id equals state.State_Id

select new

{

CityName=city.Name,

StateName=state.Name

};

GridView1.DataSource = Allcity;

GridView1.DataBind();

}

int above code CityName & StateName works as a alias from city.Name and state.Name

such as in SqlQuery.

How to use SQL Query with LINQ

2012-06-18T14:26:00.000+05:30

Add LINQ to SQL Class from Add New Item Template and name it TestDataClassesDataContext

Add Database table in to TestDataClassesDataContext

Create a TestDataClassesDataContext object into default.aspx.cs page

TestDataClassesDataContext objDBContext = new TestDataClassesDataContext(ConfigurationManager.ConnectionStrings["TestConnectionString"].ToString());

//Bind Gridview using LINQ with Query

// User_Tbls is User_Table(DataBase table) class

var userdetails = from user in objDBContext.User_Tbls select user;

GridView1.DataSource = userdetails;

GridView1.DataBind();

Open only 1 highslide pupup window if use highslide in a gallery (automatically close the already open window)

2012-06-18T12:58:00.000+05:30

1. Open Highslide-full.js or highslide-with-html.js which is used in your project.
Add the below hightailed code in Highslide-full.js or highslide-with-html.js

hs.Outline = function (outlineType, onLoad) {

this.onLoad = onLoad;

this.outlineType = outlineType;

var v = hs.uaVersion, tr;

this.hasAlphaImageLoader = hs.ie && hs.uaVersion < 7;

if (!outlineType) {

if (onLoad) onLoad();

return;

}

hs.init();

this.table = hs.createElement(

'table', {

cellSpacing: 0

}, {

visibility: 'hidden',

position: 'absolute',

borderCollapse: 'collapse',

width: 0

hs.container,

true

);

/****** add this code to generate the Table Unique ID****************/

var key = this.key = hs.expanders.length;

this.table.id="table"+key;

/*******************************/

var tbody = hs.createElement('tbody', null, null, this.table, 1);

this.td = [];

for (var i = 0; i <= 8; i++) {

if (i % 3 == 0) tr = hs.createElement('tr', null, { height: 'auto' }, tbody, true);

this.td[i] = hs.createElement('td', null, null, tr, true);

var style = i != 4 ? { lineHeight: 0, fontSize: 0} : { position : 'relative' };

hs.setStyles(this.td[i], style);

}

this.td[4].className = outlineType +' highslide-outline';

this.preloadGraphic();

};

hs.Expander = function (a, params, custom, contentType) {

if (document.readyState && hs.ie && !hs.isReady) {

hs.addEventListener(document, 'ready', function () {

new hs.Expander(a, params, custom, contentType);

});

return;

}

this.a = a;

this.custom = custom;

this.contentType = contentType || 'image';

this.isHtml = (contentType == 'html');

this.isImage = !this.isHtml;

hs.continuePreloading = false;

this.overlays = [];

this.last = hs.last;

hs.last = null;

hs.init();

var key = this.key = hs.expanders.length;

// override inline parameters

for (var i = 0; i < hs.overrides.length; i++) {

var name = hs.overrides[i];

this[name] = params && typeof params[name] != 'undefined' ?

params[name] : hs[name];

}

if (!this.src) this.src = a.href;

// get thumb

var el = (params && params.thumbnailId) ? hs.$(params.thumbnailId) : a;

el = this.thumb = el.getElementsByTagName('img')[0] || el;

this.thumbsUserSetId = el.id || a.id;

if (!hs.fireEvent(this, 'onInit')) return true;

// check if already open

for (var i = 0; i < hs.expanders.length; i++) {

if (hs.expanders[i] && hs.expanders[i].a == a

&& !(this.last && this.transitions[1] == 'crossfade')) {

hs.expanders[i].focus();

return false;

}

// cancel other

if (!hs.allowSimultaneousLoading) for (var i = 0; i < hs.expanders.length; i++) {

if (hs.expanders[i] && hs.expanders[i].thumb != el && !hs.expanders[i].onLoadStarted) {

hs.expanders[i].cancelLoading();

}

hs.expanders[key] = this;

if (!hs.allowMultipleInstances && !hs.upcoming) {

if (hs.expanders[key - 1]) hs.expanders[key - 1].close();

if (typeof hs.focusKey != 'undefined' && hs.expanders[hs.focusKey])

hs.expanders[hs.focusKey].close();

}

// initiate metrics

this.el = el;

this.tpos = this.pageOrigin || hs.getPosition(el);

hs.getPageSize();

var x = this.x = new hs.Dimension(this, 'x');

x.calcThumb();

var y = this.y = new hs.Dimension(this, 'y');

y.calcThumb();

if (/area/i.test(el.tagName)) this.getImageMapAreaCorrection(el);

this.wrapper = hs.createElement(

'div', {

id: 'highslide-wrapper-' + this.key,

className: 'highslide-wrapper ' + this.wrapperClassName

}, {

visibility: 'hidden',

position: 'absolute',

zIndex: hs.zIndexCounter += 2

}, null, true);

this.wrapper.onmouseover = this.wrapper.onmouseout = hs.wrapperMouseHandler;

if (this.contentType == 'image' && this.outlineWhileAnimating == 2)

this.outlineWhileAnimating = 0;

/*************Automatically close the already open window ********************************************/

if (key > 0) {

var chkid = "highslide-wrapper-";

for (var i = 0; i < key; i++) {

var ctrldiv = document.getElementById(chkid + i);

hs.close(ctrldiv);

}

/*********************************************************/

// get the outline

if (!this.outlineType

|| (this.last && this.isImage && this.transitions[1] == 'crossfade')) {

this[this.contentType + 'Create']();

} else if (hs.pendingOutlines[this.outlineType]) {

this.connectOutline();

this[this.contentType + 'Create']();

} else {

this.showLoading();

var exp = this;

new hs.Outline(this.outlineType,

function () {

exp.connectOutline();

exp[exp.contentType + 'Create']();

}

);

}

return true;

};

What is Sharepoint?

2012-06-14T14:51:00.000+05:30

What is Sharepoint?

SharePoint is a multi-purpose tool designed to cater to web requirements common for most organizations. Sharepoint is developed by Microsoft which is used to companies manage their data which is in the form of documents, emails, contacts, etc. documents, emails, contacts, etc.

Sharepoint Versions

1. SharePoint 2010 (Windows Server 2008 64 bit)
2. Windows SharePoint services 3.0 + MOSS 2007 (Windows Server 2003)
3. Windows SharePoint Services 2.0
4. SharePoint Team Services

Sharepoint 2007 is depend on internet explorer but sharepoint 2010 allow all popular explorer such as IE, Firefox Safari etc.

Generate MS SQL DataBase Script with Data in Sql Server 2008 and Visual Studio 2010

2012-06-13T17:29:00.002+05:30

Generate MS SQL Data Base Script with Data in Sql Server 2008 and Visual Studio 2010

1 1. Open Visual Studio 2010

2 2. Go to Tools->Connect to Data Base

3 3. Open Server Explorer right click on Data Base and select Publish to provider

Click Next and Chose the type of data publish

Click next and finish

Alert message when close the browser

2012-06-11T16:03:00.001+05:30

Alert message when close the browser
<script language="JavaScript" type="text/javascript">
        window.onbeforeunload = confirmExit;
        function confirmExit() {
            return "Are you sure you want to close this page?";
        }
</script>

Stored Procedure with LINQ for Insert

2012-06-11T14:49:00.000+05:30

How to Use Stored Procedure in LINQ for Insert

1. Crate the table for Example "User_Tbl" such as

2. Create the a Web Application

Right click on project ->Add New Item-> select LINQ to SQL Class and give the name to TestDataClasses click on OK under the App_Code Create a file TestDataClasses.dbml with extension .dbml double click on it.

3. Connect To Database in Visual Studio for this go to Tool->Connect To DataBase after connecting you can see all the database objects in Server Explorer.

Drag and Drop the required objects (such as Table, Stored Procedure etc. on TestDataClasses.dbml.

Save the TestDataClasses.dbml now you can get the DB objects in your page the TestDataClasses show such as

Example:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Configuration;

public partial class LinqStoredProcedure : System.Web.UI.Page

{

TestDataClassesDataContext objDBContext = new TestDataClassesDataContext(ConfigurationManager.ConnectionStrings["TestConnectionString"].ToString());

protected void Page_Load(object sender, EventArgs e)

{

}

protected void btnSave_Click(object sender, EventArgs e)

{

int? userId = null;

//Stored procedure To insert the record into Table

objDBContext.procInsertUserDetails(txtUserName.Text.Trim(), txtPassword.Text.Trim(), txtFirstName.Text, txtLastName.Text, txtAddress.Text, txtCity.Text

, txtState.Text, txtZip.Text, txtPhone.Text, txtFax.Text, txtUserEmail.Text, true, DateTime.Now, "admin", ref userId);

objDBContext.SubmitChanges();

}

in the above Example TestDataClassesDataContext is TestDataClasses.dbml file.

2012-06-08T11:27:00.004+05:30

How to ignore duplicate value Error while inserting the record in unique index?

When unique index is created without any option the default option is IGNORE_DUP_KEY = OFF, which means when duplicate values are inserted it throws an error regarding duplicate value.

such as

Msg 2601, Level 14, State 1, Line 9
Cannot insert duplicate key row in object 'dbo.QODT4' with unique index 'Q4_INDEX'.

If option is set with IGNORE_DUP_KEY = ON then the duplicate values are inserted it does not thrown an error but just displays warning.

such as 
(1 row(s) affected)
Duplicate key was ignored.

Learn Dotnet

View State and Hidden Field

View State and Hidden Field

Difference Between For and Foreach loop

Implementing Zoom functionality in asp.net

Difference between Layered Architecture and N-Tier Architecture

Conditional CSS or browser based CSS

Conditional CSS or browser based CSS

How to refresh parent page on close of popup window by toolbar close button

How to refresh parent page on close of popup window by toolbar close button

1. Create a Page default.aspx

2. Create pop window page default2.aspx

Display multiple marker point on Google Map with same location or same Longitude,Latitude

Check Session Timeot for Whole Application

About CAML in Sharepoint?

Automatically Jquery close alert /dialog box

How to Encrypt and Decript web.config connection string?

SharePoint 2007 Object Model

1. Site Collection: This collection of sites is known as “Site Collection”.

SPSite object can be instantiated by following methods

· SPSite objSPSite = new SPSite("Site URL");

· SPSite objSPSite = SPContext.Current.Site;

· SPSiteCollection objSiteCollection = objWebApplication.Sites;

int index = 0;

SPSite objSite = objSiteCollection[index];

SPWeb object can be instantiated by following methods

a. SPSite objSPSite = new SPSite("Site URL");

SPWeb myWeb = objSPSite.OpenWeb();

Comparing cursor vs. WHILE loop performance

Cursors

FORWARD_ONLY

What is Abstraction and Encapsulation

Advantages and Disadvantages of LINQ

How to use Join with LINQ

How to use SQL Query with LINQ

Open only 1 highslide pupup window if use highslide in a gallery (automatically close the already open window)

What is Sharepoint?

Generate MS SQL DataBase Script with Data in Sql Server 2008 and Visual Studio 2010

Alert message when close the browser

Stored Procedure with LINQ for Insert