Sriram's ASP.NET Blog

Load jQuery Asyc

2011-09-02T06:52:00.000-07:00

This is a good javascript plugin that loads jQuery async and runs document.ready after jQuery is loaded and DOM initilized.

http://www.yterium.net/jQl-an-asynchronous-jQuery-Loader

Oops in Javascript - Part -1

2011-08-19T02:35:00.000-07:00

In this post i will show you how to create Classes and object instance in Javascript.

var  myclass = function  (arg) {

console.log("Class initiated" );//Check object is initiated or not

this .arg = arg;

myclass.prototype.myfunc = function  () {

console.log(this .arg);

function  TestOops() {

var  c = new  myclass("obj1" ); //create first instance for myclass

c.myfunc();//prints obj1

var  d = new  myclass("obj2" );//create second instance for myclass

d.myfunc(); //prints obj2

c.myfunc(); //prints obj1

How to create a callback function in Javascript

2011-08-19T01:56:00.001-07:00

function  MyCallback(name, callbakFn) {

if  (typeof  (callbakFn) == 'function' ) {

callbakFn.call(this , name);

function  TestCallback() {

MyCallback('sriram' , function  (arg) {

alert(arg);

});

jQuery Detect Browser

2011-08-18T04:02:00.001-07:00

// Target Firefox 2 and above

if  ($.browser.mozilla && $.browser.version >= "1.8" ) {

// do something

// Target Safari

if  ($.browser.safari) {

// do something

// Target Chrome

if  ($.browser.chrome) {

// do something

// Target Camino

if  ($.browser.camino) {

// do something

// Target Opera

if  ($.browser.opera) {

// do something

// Target IE6 and below

if  ($.browser.msie && $.browser.version <= 6) {

// do something

// Target anything above IE6

if  ($.browser.msie && $.browser.version > 6) {

// do something

jQuery Check element exists

2011-08-18T04:01:00.000-07:00

if ($('#id' ).length) {
// do something
}

toTitleCase jQuery Plugin

2011-08-10T03:45:00.001-07:00

(function  ($) {

$.fn.toTitleCase = function  () {

$(this ).each(function  () {

var  headline = $(this ).text();

$(this'\uc1\u8216?\uc1\u8217?"\uc1\u8220?.@:\\/\\{\\(\\[<>_]+-? *)/g, function  (match, pl, index, title) {

if  (index > 0 && title.charAt(index - 2) !== ":"  && match.search(/^(a(nd?|s|t)?|b(ut|y)|en|for|i[fn]|o[fnr]|t(he|o)|vs?\\.?|via)[ \\-]/i) > -1)

return  match.toLowerCase();

if  (title.substring(index - 1, index +'"_{(\\[]/) > -1)

return  match.charAt(0) + match.charAt(1).toUpperCase() + match.substr(2);

if  (match.substr(1).search(/[A-Z]+|&|[\\w]+[._][\\w]+/) > -1 || title.substring(index - 1, index + 1).search(/[\\])}]/) > -1)

return  match;

return  match.charAt(0).toUpperCase() + match.substr(1);

}));

});

};

})(jQuery);

Source: http://plugins.jquery.com/project/titlecase

Title Case Javascript Extension

2011-08-10T03:42:00.001-07:00

String.prototype.toTitleCase = function  () {

return  this'\uc1\u8216?\uc1\u8217?"\uc1\u8220?.@:\\/\\{\\(\\[<>_]+-? *)/g, function  (match, p1, index, title) {

if  (index > 0 && title.charAt(index - 2) !== ":"  &&

	match.search(/^(a(nd?|s|t)?|b(ut|y)|en|for|i[fn]|o[fnr]|t(he|o)|vs?\\.?|via)[ \\-]/i) > -1)

return  match.toLowerCase();

if  (title.substring(index - 1, index +'"_{(\\[]/) > -1)

return  match.charAt(0) + match.charAt(1).toUpperCase() + match.substr(2);

if  (match.substr(1).search(/[A-Z]+|&|[\\w]+[._][\\w]+/) > -1 ||

	title.substring(index - 1, index + 1).search(/[\\])}]/) > -1)

return  match;

return  match.charAt(0).toUpperCase() + match.substr(1);

});

};

Source: http://individed.com/code/to-title-case/

Simple jQuery Plugin to Clear Dropdownlist options

2011-08-08T23:15:00.000-07:00

$.fn.clearOption = function  () {

var  currentId = $(this ).attr( );

document.getElementById(currentId).options.length = 0;

};

paste this code in a external js file. clear the option element

of a Dropdownlist using the folowing jQuery syntax.

$("#Dropdownlist1" ).clearOption();

Get QueryString value using javascript

2011-07-07T06:42:00.000-07:00

function  getAllQueryString() {

var  vars = [], hash;

var  hashes = window.location.href.slice(window.location.href.indexOf( ) + 1).split( );

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

hash = hashes[i].split( );

vars.push(hash[0]);

vars[hash[0]] = hash[1];

return  vars;

function  getQueryString(name) {

return  getUrlVars()[name];

Get the QueryString using the following Syntax

var  hID = getQueryString( );

How to detect popup blocker in Javascript

2011-07-05T06:33:00.000-07:00

var  sw1 = window.open(urlPath,"windowname"  , settings);

if  (sw1)

sw1.focus();

else

alert("Popup blocker detected" );

Validate Email - No under score or @ after first @

2011-07-01T03:41:00.001-07:00

<script  type="text/javascript">

function  fn_Email_Check(Chartocheck) {

var  rx = /^([A-Za-z0-9_\\-\\.])+\\@([A-Za-z0-9\\-\\.]+[^_@])+\\.([A-Za-z]{2,4})$/;

if  (rx.test(Chartocheck) == false )

return  false ;

else

return  true ;

</script>

Infinite Loop Javascript timer using Recursive function

2011-07-01T03:38:00.001-07:00

<html>

<head>

<script  type="text/javascript">

var  c = 0;

var  t;

var  timer_is_on = 0;

function  timedCount() {

document.getElementById( ).value = c;

c = c + 1;

t = setTimeout("timedCount()" , 1000);

function  doTimer() {

if  (!timer_is_on) {

timer_is_on = 1;

timedCount();

</script>

</head>

<body>

<form>

<input  type="button"  value="Start count!"  onclick="doTimer()">

<input  type="text"  id="txt"  />

</form>

</body>

</html>

Redirect if a page has querystring to same address with out query string.

2011-06-28T05:49:00.000-07:00

Redirect if a page has querystring to same address with out query string.

protected void Page_PreInit(object sender, EventArgs e)
    {
        if (Request.QueryString.Count > 0)
        {
            Response.Redirect(Request.Url.AbsolutePath);
            //Response.Write("AbsolutePath" + Request.Url.AbsolutePath);
            //Response.Write("
AbsoluteUri" + Request.Url.AbsoluteUri);
            //Response.Write("
PathAndQuery" + Request.Url.PathAndQuery);
            //Response.Write("
Query" + Request.Url.Query);
            //Response.Write("test" + Request["test"]);
        }
    }

My First Facebook Application.

2011-06-27T12:42:00.000-07:00

This is my first Facebook application. Developed for my Sister's Store - Just Slawars,Velachery,Chennai.

Please visit the my facebook application at the below url and provide feedback.

http://www.facebook.com/justsalwars.chennai?sk=app_226529810694970

Custom macro datatype for macro properties - Umbraco

2011-06-21T05:35:00.000-07:00

In this post i will teach you how to create a dropdown list for selecting value for Umbraco Macro Properties.Usually for Macro properties we can set only few predefined datatype while adding properties in umbraco admin. In order to have our custom datatype we need to edit Umbraco source. Open Umbraco source code in Visual Studio. Add a new class to umbraco.macroRenderings project with the following code.

using  System;

using  System.Collections.Generic;

using  System.Linq;

using  System.Text;

namespace  umbraco.macroRenderings

class  HotelsDropdown  : System.Web.UI.WebControls.DropDownList , umbraco.interfaces.IMacroGuiRendering

string  _value = string .Empty;

public  string  Value

get  {

string  retVal = string .Empty;

foreach  (System.Web.UI.WebControls.ListItem  i in  base .Items)

if  (i.Selected == true )

retVal = i.Value;

return  retVal;

set  { _value = value ; }

public  bool  ShowCaption

get  { return  true ; }

protected  override  void  OnInit(EventArgs  e)

base .OnInit(e);

for  (int  i = 0; i < 5; i++)

System.Web.UI.WebControls.ListItem  li = new  System.Web.UI.WebControls.ListItem ("test"  + i.ToString());

if  (_value == "test"  + i.ToString())

li.Selected = true ;

this .Items.Add(li);

compile and copy .dll to umbraco bin.

add macro class info to umbraco "cmsMacroPropertyType" table:

Click image to enlarge

add new object type to your macro:

Click image to enlarge

add/embed macro in page or template and set macro property values using the our Dropdown:

Click image to enlarge

Output in editor:

Click image to enlarge

Output in browser:

Click image to enlarge

Validate Email - Javascript

2011-06-15T05:00:00.001-07:00

<script  type="text/javascript">

//Function to validate Email

function  IsValidEmail(email) {

//var exclude=/[^@\\-\\.\\w]|^[_@\\.\\-]|[\\._\\-]{2}|[@\\.]{2}|(@)[^@]*\\1/;

var  exclude = /[^@\\-\\.\\w]|^[_@\\.\\]|[\\._\\-]{2}|[@\\.]{2}|(@)[^@]*\\1/;

var  checkend = /\\.[a-zA-Z]{2,3}$/;

if  ((email.search(exclude) != -1) || (email.search(checkend) == -1)) {

return  false ;

atPos = email.indexOf("@" , 0);

pPos1 = email.indexOf("." , 0);

periodPos = email.indexOf("." , atPos);

pos1 = pPos1;

pos2 = 0;

while  (pos2 > -1) {

pos2 = email.indexOf("." , pos1 + 1);

if  (pos2 == pos1 + 1) {

return  false ;

} else  {

pos1 = pos2;

if  (atPos == -1) {

return  false ;

if  (atPos == 0) {

return  false ;

if  (pPos1 == 0) {

return  false ;

if  (email.indexOf("@" , atPos + 1) > -1) {

return  false ;

if  (periodPos == -1) {

return  false ;

if  (atPos + 1 == periodPos) {

return  false ;

if  (periodPos + 3 > email.length) {

return  false ;

return  true ;

</script>

Javascript function to check for valid characters and invalid characters

2011-06-15T04:56:00.000-07:00

If you want to validate a name feild with only alphabets. you can use below code to validate it.

<script  type="text/javascript">

if  (IsValidChars(document.getElementById( ).value.toLowerCase(), "abcdefghijklmnopqrstuvwxyz" )) {

alert("valid" );

else  {

alert("Invalid Characters" );

//Function to check the valid characters

function  IsValidChars(Char_To_Be_Checked, Valid_Char) {

var  checkStr;

var  checkOK1;

var  allValid;

checkStr = Char_To_Be_Checked;

checkOK1 = Valid_Char;

var  allValid = true ;

for  (m = 0; m < checkStr.length; m++) {

ch = checkStr.charAt(m);

for  (n = 0; n < checkOK1.length; n++) {

if  (ch == checkOK1.charAt(n))

break ;

if  (n == checkOK1.length) {

allValid = false ;

break ;

return  allValid;

//Function to check the invalid characters

function  IsInValidChars(Char_To_Be_Checked, InValid_Char) {

var  checkStr;

var  checkOK1;

var  allValid;

checkStr = Char_To_Be_Checked;

checkOK1 = InValid_Char;

var  allValid = true ;

for  (m = 0; m < checkStr.length; m++) {

ch = checkStr.charAt(m);

for  (n = 0; n < checkOK1.length; n++) {

if  (ch == checkOK1.charAt(n)) {

allValid = false ;

break ;

return  allValid;

</script>

Trim String Using Javascript

2011-06-15T00:13:00.000-07:00

Javascript Trim Member Functions

Use the code below to make trim a method of all Strings. These are useful to place in a global Javascript file included by all your pages.


String.prototype.trim = function() {
 return this.replace(/^\s+|\s+$/g,"");
}
String.prototype.ltrim = function() {
 return this.replace(/^\s+/,"");
}
String.prototype.rtrim = function() {
 return this.replace(/\s+$/,"");
}

Javascript Trim Stand-Alone Functions

If you prefer not to modify the string prototype, then you can use the stand-alone functions below.

 function trim(stringToTrim) {  return stringToTrim.replace(/^\s+|\s+$/g,""); } function ltrim(stringToTrim) {  return stringToTrim.replace(/^\s+/,""); } function rtrim(stringToTrim) {  return stringToTrim.replace(/\s+$/,""); }

Compatibility

The functions above use regular expressions, which are compatible with Javascript 1.2+ or JScript 3.0+. All modern browsers will support this. If you require functions for older versions of Javascript back to version 1.0, try the functions below adapted from the Javascript FAQ 4.16. These strip the following, standard whitespace characters: space, tab, line feed, carriage return, and form feed. The IsWhitespace function checks if a character is whitespace.


function ltrim(str) { 
 for(var k = 0; k < str.length && isWhitespace(str.charAt(k)); k++);
 return str.substring(k, str.length);
}
function rtrim(str) {
 for(var j=str.length-1; j>=0 && isWhitespace(str.charAt(j)) ; j--) ;
 return str.substring(0,j+1);
}
function trim(str) {
 return ltrim(rtrim(str));
}
function isWhitespace(charToCheck) {
 var whitespaceChars = " \t\n\r\f";
 return (whitespaceChars.indexOf(charToCheck) != -1);
}

LINQ to Excel using Dataset or Datatable

2011-06-14T23:37:00.000-07:00

using  System;

using  System.Collections;

using  System.Collections.Generic;

using  System.Data;

using  System.Diagnostics;

using  TWebservice;

using  System.Xml;

using  System.Linq;

using  System.Xml.Linq;

using  System.Web;

using  System.Web.UI;

using  System.Web.UI.WebControls;

using  System.Data.SqlClient;

using  System.Web.Configuration;

using  System.Data.OleDb;

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

//Resturns the excel sheet as Dataset or DataTable

private  DataTable  GetExcel()

DataTable  dataTable;

if  (Cache["ExcelDatas" ] == null )

string  filename = Server.MapPath("~/Common_Inc/Country.xls" );

string  connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;"  + "Data Source="  + filename + ";"  + "Extended Properties=Excel 8.0;" ;

OleDbDataAdapter  dataAdapter = new  OleDbDataAdapter ("SELECT * FROM [citystatecountry]" , connectionString);// [excel sheet name]

DataSet  myDataSet = new  DataSet ();

dataAdapter.Fill(myDataSet, "ExcelInfo" );

dataTable = myDataSet.Tables["ExcelInfo" ];

Cache["ExcelDatas" ] = dataTable;

else

dataTable = (DataTable )Cache["ExcelDatas" ];

return  dataTable;

protected  void  Page_Load(object  sender, EventArgs  e)

if  (!IsPostBack)

//Now we can use LINQ to Dataset to query the data in Excel.

DataTable  dataTable = GetExcel();

var  ExcelDatas = (from  r in  dataTable.AsEnumerable().GroupBy(g => g.Field<string >("Country" )).Select(f => f.First()) select  new  { Country = r.Field<string >("Country" ) }).Distinct();

ddlHomecountry.DataSource = ExcelDatas;

ddlHomecountry.DataTextField = "Country" ;

ddlHomecountry.DataValueField = "Country" ;

ddlHomecountry.DataBind();

Update: This tutorial uses Microsoft.Jet.OLEDB.4.0 provider for returning a Dataset from Excel. There is now a better tool to do it from codeplex. it has even support for 2007 office format. This tool is available at http://exceldatareader.codeplex.com/

Error because of Child Applications reading values from Root web.config

2011-06-11T02:16:00.000-07:00

Error because of Child Applications reading values from Root web.config.

To prevent this add location tag with attribute inheritInChildApplications="false" to root web.config for the part which you do not want to inherit.

[...]
<location inheritInChildApplications="false">
 
  <system.web>
    
  [...]   
 
  system.web>
  
location>
[...]

If the error is caused by HttpHandler in root add validate="false" attribute to the handler which is causing the problem.

<add verb= "GET " path= "CaptchaImage.axd " validate= "false " type= "MSCaptcha.CaptchaImageHandler, MSCaptcha "/>

Invalidate Output Cache when aspx or aspx.cs file changes

2011-06-08T02:24:00.000-07:00

Invalidate Output Cache when aspx or aspx.cs file changes.

To do this add file dependency object to response object.

Set expires header.

Set cache location as server and private(client,proxy).

Generate Etag from file dependency(if you chnage the file
before expire header date - this will load new file
from server) - you must set HttpCacheability .ServerAndPrivate
for Etag to work.

Override Render event to minify HTML output.

This will save bandwidth.

In order to add this functionality

to all the pages i have inherited page class

 and created custom Page class called MyPage.

Complete Code below.

using  System;

using  System.Web.Caching;

using  System.Web.UI;

using  System.Web;

using  System.Reflection;

using  System.IO;

using  System.Text.RegularExpressions;

/// <summary>

/// Summary description for MyPage

/// </summary>

public  partial  class  MyPage  : Page

protected  void  Page_Init(object  sender, EventArgs  e)

string [] fileDependencies;

string  fileDependency1 = Server.MapPath(Request.Url.LocalPath);

string  fileDependency2 = Server.MapPath(Request.Url.LocalPath).Replace(".aspx" ,".aspx.cs" );

fileDependencies = new  string [] { fileDependency1, fileDependency2 };

//Uncomment before going to live.

Response.AddFileDependencies(fileDependencies);

Response.Cache.SetVaryByCustom("browser" );

Response.Cache.SetExpires(DateTime .Now.AddDays(1));

Response.Cache.SetCacheability(HttpCacheability .ServerAndPrivate);

Response.Cache.SetETagFromFileDependencies();

Response.Cache.SetValidUntilExpires(true );

//Override the page Render event to minify HTML output.

protected  override  void  Render(HtmlTextWriter  writer)

TextWriter  output = new  StringWriter ();

base .Render(new  HtmlTextWriter (output));

String  html = output.ToString();

html = Regex .Replace(html, @"\n|\t" , " " );

html = Regex .Replace(html, @">\\s+<" , "><" ).Trim();

html = Regex .Replace(html, @"\\s{2,}" , " " );

writer.Write(html);

if you want to invalidate cache manually. you can use the below method to do the task.

Response.RemoveOutputCacheItem Method (String)

Updatable Views

2011-06-03T04:02:00.001-07:00

You can modify the data of an underlying base table through a view, as long as the following conditions are true:

Any modifications, including UPDATE, INSERT, and DELETE statements, must reference columns from only one base table.
The columns being modified in the view must directly reference the underlying data in the table columns. The columns cannot be derived in any other way, such as through the following:
- An aggregate function: AVG, COUNT, SUM, MIN, MAX, GROUPING, STDEV, STDEVP, VAR, and VARP.
- A computation. The column cannot be computed from an expression that uses other columns. Columns that are formed by using the set operators UNION, UNION ALL, CROSSJOIN, EXCEPT, and INTERSECT amount to a computation and are also not updatable.
The columns being modified are not affected by GROUP BY, HAVING, or DISTINCT clauses.
TOP is not used anywhere in the select_statement of the view together with the WITH CHECK OPTION clause.

The previous restrictions apply to any subqueries in the FROM clause of the view, just as they apply to the view itself. Generally, the Database Engine must be able to unambiguously trace modifications from the view definition to one base table. For more information, see Modifying Data Through a View.
If the previous restrictions prevent you from modifying data directly through a view, consider the following options:

INSTEAD OF Triggers
INSTEAD OF triggers can be created on a view to make a view updatable. The INSTEAD OF trigger is executed instead of the data modification statement on which the trigger is defined. This trigger lets the user specify the set of actions that must happen to process the data modification statement. Therefore, if an INSTEAD OF trigger exists for a view on a specific data modification statement (INSERT, UPDATE, or DELETE), the corresponding view is updatable through that statement. For more information about INSTEAD OF triggers, see Designing INSTEAD OF Triggers.
Partitioned Views
If the view is a partitioned view, the view is updatable, subject to certain restrictions. When it is needed, the Database Engine distinguishes local partitioned views as the views in which all participating tables and the view are on the same instance of SQL Server, and distributed partitioned views as the views in which at least one of the tables in the view resides on a different or remote server.
For more information about partitioned views, see Creating Partitioned Views.

XML parsing failed - Opera

2011-05-29T23:52:00.000-07:00

This mostly occurs with ASP.NET as it sets content type for opera as application/xhtml+xml.This error occurs in opera if you have any unescaped html special characters in aspx page Eg: & instead of & . Validate your page using W3C validator for any page errors. If it occurs for a existing large scale website. go ahead and fix it using browser config file hack.You will face this issue if you add browser config files from codeplex to detect mobile devices such as http://mdbf.codeplex.com.
In order to over come this issue. You need to set content type to text/html.
The best way to fix this issue is to add following code to .browser config file for opera in App_Browser file.

<capability name="preferredRenderingMime" value="text/html" />
<capability name="preferredRenderingType" value="html32" />
<capability name="SupportsXhtmlRendering" value="false" />

Delegates and events:

2011-05-16T04:32:00.000-07:00

Delegates and events:

Handle or Subscribe to ASP.NET Controls events from UserControl in ASPX Page.

Step 1:

Create a usercontrol having a textbox and button control

Search Catalogue by Points <br><br>

<asp:Panel ID="Panel1" runat="server" DefaultButton="btnSubmit">

<input type="text" name="Text1" size="4" maxlength="6" ID="Text1" runat="server"/>

<asp:Button ID="btnSubmit" runat="server" Text="Go"

OnClientClick="javascript:return clickherego(this.form);"

style="color:White;background-color:#75bde9;border-style:None;width:25px;height:20px;font-size:10px;font-family:verdana"

onclick="btnSubmit_Click"/> </asp:Panel>

Explanation:

DefaultButton="btnSubmit" in panel control will trigger btnSubmit button click when user presses enter key or return key in Mac.

Step 2:

Inherit EventArgs Class to Pass values to Event Handler. This will enable us to get the user control textbox values in ASPX page.

public class NavEventArgs : EventArgs

{

private int _text;

public int SearchText

{

get { return _text; }

}

public NavEventArgs(int searchtext)

{

this._text = searchtext;

}

Step 3:

Create an event in UserControl1.ascx.cs file

private bool _goClicked;

public bool GoClicked

{

get { return _goClicked; }

set { _goClicked = value; }

}

private int _text1value;

public int Text1Value

{

get { return _text1value; }

set { _text1value = value; }

}

public delegate void NavEventHandler(object sender, NavEventArgs e );

public event NavEventHandler GoButtonClicked;

Step 4:

Fire the GoButtonClicked event in submit button clicked event.

protected void btnSubmit_Click(object sender, EventArgs e)

{

GoClicked = true;

Text1Value = Convert.ToInt32(Text1.Value);

Text1.Value = string.Empty;

if (GoButtonClicked != null)

{

//this value can be accessed using e.SearchText in EventHandler

NavEventArgs e1 = new NavEventArgs(Text1Value);

//Fire the event

GoButtonClicked(this, e1);

}

Entire UserControl1.ascx.cs file

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

public partial class dinning_navigation : System.Web.UI.UserControl

{

private bool _goClicked;

public bool GoClicked

{

get { return _goClicked; }

set { _goClicked = value; }

}

private int _text1value;

public int Text1Value

{

get { return _text1value; }

set { _text1value = value; }

}

public delegate void NavEventHandler(object sender, NavEventArgs e );

public event NavEventHandler GoButtonClicked;

protected void Page_Load(object sender, EventArgs e)

{

GoClicked = false;

Text1.Attributes.Add("onkeydown", "if(event.keyCode== 13){document.getElementById('" + btnSubmit.UniqueID + "').click();}");

}

protected void btnSubmit_Click(object sender, EventArgs e)

{

//Response.Redirect("search_result.aspx?text=" + Text1.Value);

GoClicked = true;

Text1Value = Convert.ToInt32(Text1.Value);

Text1.Value = string.Empty;

if (GoButtonClicked != null)

{

NavEventArgs e1 = new NavEventArgs(Text1Value);

GoButtonClicked(this, e1);

}

public class NavEventArgs : EventArgs

{

private int _text;

public int SearchText

{

get { return _text; }

}

public NavEventArgs(int searchtext)

{

this._text = searchtext;

}

Step 5:

Handle GoButtonClicked event in ASPX

Step 5.1:

Add the user control to EventsTest.aspx page

<%@ Register Src="dinning_navigation.ascx" TagName="dinning_navigation" TagPrefix="uc1" %>

<uc1:dinning_navigation ID="Dinning_navigation1" runat="server" OnGoButtonClicked="dinning_navigation_GoButtonClicked" />

Step 5.2:

Event Handler for GoButtonClicked. Now OnGoButtonClicked event will automatically showed by Intellisense in visual studio. dinning_navigation_GoButtonClicked is the EventHandler name I have given.

OnGoButtonClicked="dinning_navigation_GoButtonClicked"

Step 5.3:

EventHandler for GoButtonClicked event in EventsTest.aspx.cs file.

protected void dinning_navigation_GoButtonClicked(object sender, NavEventArgs e)

{

FillGrid4GoButtonClicked(e.SearchText);

GridView1.PageIndex = 0;

GridView1.DataBind();

}

2011-05-16T03:47:00.000-07:00

Step 1:Create an XML

<RedeemNonStayRequest>
    <Email></Email>
    <MembershipNo></MembershipNo>
    <ItemCode></ItemCode>
    <Description></Description>
    <Comments></Comments>
    <MailingAddress></MailingAddress>
    <Landmark></Landmark>
</RedeemNonStayRequest>

Step 2:Create XLST

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl">
    <xsl:param name="pEmail"></xsl:param>
    <xsl:param name="pMembershipNo"></xsl:param>
    <xsl:param name="pItemCode"></xsl:param>
    <xsl:param name="pDescription"></xsl:param>
    <xsl:param name="pComments"></xsl:param>
    <xsl:param name="pMailingAddress"></xsl:param>
    <xsl:param name="pLandmark"></xsl:param>
    <xsl:template match="/">
        <Table border="1" cellspacing="0" cellpadding="1">
          <tr>
            <td align="center" style="FONT-WEIGHT: bold;FONT-SIZE: 10px;COLOR: #666666;LINE-HEIGHT: 15px; FONT-FAMILY: Verdana;TEXT-DECORATION: none">Taj Advantage Plus Redeem Request</td>
          </tr>
            <tr>
                <td align="center">
                    <table width="500px" style="FONT-WEIGHT: bold;FONT-SIZE: 10px;COLOR: #666666;LINE-HEIGHT: 15px; FONT-FAMILY: Verdana;TEXT-DECORATION: none">

                        <xsl:apply-templates select ="//Email"></xsl:apply-templates>
                        <xsl:apply-templates select="//MembershipNo"></xsl:apply-templates>
                        <xsl:apply-templates select="//ItemCode"></xsl:apply-templates>
                        <xsl:apply-templates select="//Description"></xsl:apply-templates>
                        <xsl:apply-templates select="//Comments"></xsl:apply-templates>
                        <xsl:apply-templates select="//MailingAddress"></xsl:apply-templates>
                        <xsl:apply-templates select="//Landmark"></xsl:apply-templates>
                    </table>
                </td>
            </tr>
        </Table>
    </xsl:template>
    <xsl:template match='Email'>
        <tr>
            <td style='text-align:right'>
                Email
            </td>
            <td style='text-align:left'>
                <xsl:value-of select='$pEmail'/>
            </td>
        </tr>
    </xsl:template>
    <xsl:template match='MembershipNo'>
        <tr>
            <td style='text-align:right'>
                Membership No
            </td>
            <td style='text-align:left'>
                <xsl:value-of select='$pMembershipNo'/>
            </td>
        </tr>
    </xsl:template>
    <xsl:template match='ItemCode'>
        <tr>
            <td style='text-align:right'>
                Item Code
            </td>
            <td style='text-align:left'>
                <xsl:value-of select='$pItemCode'/>
            </td>
        </tr>
    </xsl:template>
    <xsl:template match='Description'>
        <tr>
            <td style='text-align:right'>
                Description
            </td>
            <td style='text-align:left'>
                <xsl:value-of select='$pDescription'/>
            </td>
        </tr>
    </xsl:template>
    <xsl:template match='Comments'>
        <tr>
            <td style='text-align:right'>
                Comments
            </td>
            <td style='text-align:left'>
                <xsl:value-of select='$pComments'/>
            </td>
        </tr>
    </xsl:template>
    <xsl:template match='MailingAddress'>
        <tr>
            <td style='text-align:right'>
                Mailing Address
            </td>
            <td style='text-align:left'>
                <xsl:value-of select='$pMailingAddress'/>
            </td>
        </tr>
    </xsl:template>
    <xsl:template match='Landmark'>
        <tr>
            <td style='text-align:right'>
                Landmark
            </td>
            <td style='text-align:left'>
                <xsl:value-of select='$pLandmark'/>
            </td>
        </tr>
    </xsl:template>
</xsl:stylesheet>

Step 3:

Add these namespaces

using System.IO;
using System.Xml;
using System.Xml.Xsl;
using System.Text;
using System.Web.Mail;

Step 4:

Add the following code to send mail using XLST template

private void SendMail()
    {
        XmlDocument xDoc = new XmlDocument();
        xDoc.Load(Server.MapPath("EmailFormat.xml"));
        XslCompiledTransform xct = new XslCompiledTransform(true);
        xct.Load(Server.MapPath("EmailFormat.xslt"));

        //add arguments for placeholders in xlst(ie. substitute the values in XLST before send the email)
        XsltArgumentList xArgs = new XsltArgumentList();
        xArgs.AddParam("pEmail", "", txtEmailID.Text);
        xArgs.AddParam("pMembershipNo", "", txtMemID.Text);
        xArgs.AddParam("pItemCode", "", lblCode.Text);
        xArgs.AddParam("pDescription", "", lbldesc.Text);
        xArgs.AddParam("pComments", "", txtComments.Text);
        xArgs.AddParam("pMailingAddress", "", txtMailingAddress.Text);
        xArgs.AddParam("pLandmark", "", txtLandMark.Text);

        //process the xlst in memory using StringWriter
        StringWriter mailbody = new StringWriter();

        //transform it
        xct.Transform(xDoc, xArgs, mailbody);

        //send mail now
        MailMessage mm = new MailMessage("From addess","To address");
        mm.Subject = "Mail Subject";

        //transformed output from stringwriter stream
        mm.Body = mailbody.ToString();

        //HTML is very important
        mm.IsBodyHtml = true;
        SmtpClient cli = new SmtpClient("SMTP servere IP address");
        cli.Send(mm);
        objMail.Body = mailbody.ToString();
        SmtpMail.Send(objMail);
        Response.Redirect("Thankyou.aspx");
    }

Update part of a string in sql server

2011-05-16T03:32:00.000-07:00

Update part of a string in sql server

update mylinkstable set LinksUrl=replace(LinksUrl,'Promotions.html','Special-Offers.html')

Open Response.Redirect url in a new window

2011-05-05T05:17:00.000-07:00

ASP Button code:

Add OnClientClick="return NewWindow();"

Javascript:

function NewWindow()
{

document.forms[0].target = "_blank";

}

Change target attribute of Form tag to blank using javascript.

C# Code:

Now add Response.Redirect to Button Click event handler.

This will open the new url in the new window

Create Customing Paging Links for ASP.NET Page

2011-03-01T21:46:00.001-08:00

    private void Paging(DataView dv)
    {
        int totalPages = dv.Count / maxrow;
        int remainder = dv.Count % maxrow;
        //Response.Write(totalPages + "
" + remainder);
        if (remainder > maxrow && remainder!= 0)
        {
            totalPages += totalPages;
        }
        for(int i=1;i<=totalPages;i++)
        {
        HtmlAnchor lnkPage = new HtmlAnchor();
        lnkPage.HRef = this.Page.AppRelativeVirtualPath + "?" + this.Page.ClientQueryString.Replace(Session["page"].ToString(), "Page=" + i.ToString());
        lnkPage.Attributes.Add("class", "paging");
        lnkPage.InnerText = i.ToString();
        //Pager is a PlaceHolder
        pager.Controls.Add(lnkPage);
        }

    }

Run a Scheduled Task in ASP.NET

2011-01-05T03:46:00.000-08:00

The Timer class, found in the System.Threading namespace, is a wonderfully useful, but less well-known class in the .NET Framework, at least for Web developers. Once created, the Timer will invoke the specified callback on a thread from the ThreadPool at a configurable interval. This means you can set up code to execute without an incoming request to your ASP.NET application, an ideal situation for background processing. You can do work such as indexing or sending e-mail in this background process too.

Source: http://msdn.microsoft.com/hi-in/magazine/cc163854%28en-us%29.aspx

Reset sa Password in SQL Server

2011-01-04T05:08:00.001-08:00

1. Login to Server Management Studio using Windows Authentication

2. Click New Query

3. Enter the following

GO
ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master]
GO
USE [master]
GO
ALTER LOGIN [sa] WITH PASSWORD=N'NewPassword' MUST_CHANGE
GO

Load Usercontrol Dynamically in WebForm by Dynamically invoking any Constructor of the user control

2010-12-31T05:05:00.000-08:00

We can Programmatically load a UserControl to a WebForm using the following code.

Add a place holder(eg:MyPlaceHolder) control to .aspx page

Write the follwing code to Code-Behind File(.aspx.cs)

UserControl MyUserControl = Page.LoadControl("UserControl1.ascx") as UserControl;
MyPlaceHolder.Controls.Add(accordionUserControl);

The problem with above approach is LoadControl() function returns instance of UserControl by calling Default Constructor of the UserControl.When we have more than one Constructor. We cannot use LoadControl() function. Below is the solution to this problem.

create a new function called LoadUserControl() function. This function accepts two parameters.

1. Url to UserControl
2. Params Object[]
3.Returns instance of UserControl

The params keyword lets you specify a method parameter that takes an argument where the number of arguments is variable.

Code:

protected UserControl LoadUserControl(string UserControlPath, params object[] constructorParameters)
{

List constParamTypes = new List();

//Get the Type of Params passed and save it ti List
foreach (object constParam in constructorParameters)
{
constParamTypes.Add(constParam.GetType());
}

//Load user control using the url supplied
UserControl ctl = Page.LoadControl(UserControlPath) as UserControl;

// Find the relevant constructor
ConstructorInfo constructor = ctl.GetType().BaseType.GetConstructor(constParamTypes.ToArray());

//And then call the relevant constructor
if (constructor == null)
{
throw new MemberAccessException("The requested constructor was not found on : " + ctl.GetType().BaseType.ToString());
}
else
{
constructor.Invoke(ctl, constructorParameters);
}

// Finally return the fully initialized UserControl
return ctl;
}

Now use the following code in Code-Behind File to load UserControl Dynamically using Any Constructors

UserControl MyUserControl = LoadUserControl("/Reservation/Accordion.ascx", url, lstItem,cssEnabled, pnl);
MyPlaceHolder.Controls.Add(accordionUserControl);

Minify HTML Output of an ASPX Page Before Sending it to Client

2010-12-31T03:37:00.000-08:00

We can Minify HTML Output of an ASPX Page Before Sending it to Client by Overriding the page Render event.

protected override void Render(HtmlTextWriter writer)
{
TextWriter output = new StringWriter();
base.Render(new HtmlTextWriter(output));
String html = output.ToString();
html = Regex.Replace(html, @"\n|\t", " ");
html = Regex.Replace(html, @">\s+<", "><").Trim();
html = Regex.Replace(html, @"\s{2,}", " ");
writer.Write(html);
}

But the problem with the above code is that we need to add it to Code-Behind of all .aspx page.
This event can not be overriden in Master Page and that is not a strong OOP concept too.

The better solution is to Create our own Page Class(eg: MyPageClass) by Inheriting from System.Web.UI.Page and Put the above code in it. Now inherit all Code-Behind files(.aspx.cs) from our own Page Class(eg: MyPageClass). Complete Code is given below.

//Custom Page Class - Put this in App_Code Folder

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Reflection;
using System.IO;
using System.Text.RegularExpressions;

///

/// Summary description for MyPageBase
///

public class MyPageBase : System.Web.UI.Page
{

public MyPageBase()
{
//Constructor code here
}

//Override the page Render event for HTML Output Minification. This event can not be overriden in Master Page and that is not a strong OOP concept too.
protected override void Render(HtmlTextWriter writer)
{
TextWriter output = new StringWriter();
base.Render(new HtmlTextWriter(output));
String html = output.ToString();
html = Regex.Replace(html, @"\n|\t", " ");
html = Regex.Replace(html, @">\s+<", "><").Trim();
html = Regex.Replace(html, @"\s{2,}", " ");
writer.Write(html);
}
}

Inherit the .aspx.cs File from MyPageBase class

using System;
using System.Data;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Text;
using System.Text.RegularExpressions;
using System.Globalization;
using System.Xml;
using System.Xml.Linq;

public partial class Default : MyPageBase
{

protected void Page_Load(object sender, EventArgs e)
{

}

}

In my next post i will teach how to do this using Plug-n-Play HttpModule

Save Custom Exceptions to ELMAH Log

2010-12-27T06:48:00.000-08:00

Call the following method to Save Custom Exceptions to Log

Elmah.ErrorSignal.FromCurrentContext().Raise(new ApplicationException("Invalid Username or Password"));

2010-10-23T18:35:00.000-07:00

Introduction

In this article,i will teach you how to use SQL Server Comapact Edition 4.0 CTP1 with ASP.NET Dynamic Data website.

ASP.NET Dynamic Data provides a framework that enables you to quickly build a functional data-driven application, based on a LINQ to SQL or Entity Framework data model. Full CRUD (create, read, update, and delete) operations are supported. The ASP.NET Dynamic Data site includes filtering by foreign keys and Boolean fields; foreign keys are automatically converted to their friendly names. Smart validation is automatically available, which provides validation based on database constraints for nullable fields, data type, and field length.

Background

In order to under stand this article. You need to know about how to create ADO.NET Entity Data Model for Sql CE 4.0. I highly recommend you read my article 'ADO.NET Entity Data Model For SqlServer CE 4.0 CTP1' for more information about creating Entity Data Model for Sql CE 4.0 Database.

Solution:

Step 1:

Create a new ASP.NET Dynamic Data Entities WebApplication Project.

Step 2:

Create a new SQL CE 4 Database using Microsoft Web Matrix.

Step 3:

Create Entity Data Model for SQL CE 4 Database using EdmGen2.exe command line tool.
The tool can be downloaded from http://code.msdn.microsoft.com/EdmGen2

Open command prompt and Goto the folder containing EdmGen2.exe . Type the following commands in the order below


EdmGen2 /ModelGen "Data Source= C:\SQLCEWebApp\App_Data\Database1.sdf" System.Data.SqlServerCe.4.0 Database1





EdmGen2 /FromEdmx Database1.edmx





EdmGen2 /Validate Database1.edmx





EdmGen2 /ViewGen cs Database1.edmx





EdmGen2 /CodeGen cs Database1.edmx

Step 4:

Add the SQL CE database and .EDMX file to project by select Add Exsting Item option.

Step 5:

Now open Global.asax file and look for a Commented line below

//DefaultModel.RegisterContext(typeof(YourDataContextType), new ContextConfiguration() { ScaffoldAllTables = false });

Step 6:

Now uncomment the above line and replace the YourDataContextType with the DataContext Class name from Database1.Designer.cs file and Change ScaffoldAllTables = true.

DefaultModel.RegisterContext(typeof(Database1Model.Database1Entities ), new ContextConfiguration() { ScaffoldAllTables = true});

Thats it!!!! Now you have a Full CRUD Website in a matter of seconds.

ADO.NET Entity Data Model For SqlServer CE 4.0 CTP1

2010-10-23T10:43:00.000-07:00

Introduction

In this tutorial we will create an ADO.NET Entity Data model for Sql Server CE 4.0 CTP1.As of now Visual Studio 2010 or Visual Web Developer 2010 Express do not have design time support for creating an Entity Data model for Sql server CE 4.0 CTP1. So we will be using some of the free tools available to create an Entity Data Model that can be used in Visual Studio.

Advantage of Using SqlServer CE 4.0 CTP1

No Database Installation Required
Database file is stored on disk.
Can be used in shared hosting.
Easy migration to SqlServer.

Since SqlServer CE 4.0 CTP1 is a go-live release. We can start coding now and can go-live when final version is released.

Background

In this tutorial we will be using Microsoft Web Matrix and EdmGen2.exe a command-line tool to create Entity Data Model.

Project

First create a new web application project in visual studio named SQLCEWebApp and save it to location C:\SQLCEWebApp\ . Do not forget to uncheck the option Create Directory for solution.

Now we need to add sqlce 4.0 database to our project. Unfortunately visual studio does not provide support for creating Sql Ce 4.0 Database. So we will use Microsoft WebMatrix for creating Sql Ce 4.0 Database.

Create a new website using Microsoft WebMatrix. Goto WebMatrix-> Site From Template->Empty Site . Give a name for site(eg:SQLCE4.0) and click OK.

Now click the database tab in Web Matrix and Create a new Database and tables.

Next we need to copy the newly created database to the App_Data folder of our SQLCEWebApp project in Visual Studio 2010. In order to use SqlServer CE 4.0 database in our ASP.NET appliaction we need to add reference to two DLL's(System.Data.SqlServerCe.dll, System.Data.SqlServerCe.Entity.dll). These DLLs will be located in C:\Program Files\Microsoft SQL Server Compact Edition\v4.0\Private folder. Sql Server Compact Edition 4.0(Sql CE 4.0 CTP1) will be automatically installed when you install Web Matrix.

Next we need to create ADO.NET Entity Data Model for Sql CE 4.0 CTP1. But Visual Studio 2010 does not provide design time support for Creating Entity Data Model for Sql CE 4.0 databases. So we will use a Tool called EdmGen2.exe . This tool can be downloaded from http://code.msdn.microsoft.com/EdmGen2

Next Unzip the downloaded project file to C:\ EdmGen2 folder. Open the solution file(EdmGen2.sln) using Visual Studio 2010. Build the project to get EdmGen2.exe . This file will be located in C:\ EdmGen2\bin\Debug\ folder. Now we can use this command line tool to Generate the Entity Data Model for Sql CE 4.0 Database.

Open command prompt and Goto the folder containing EdmGen2.exe (eg: C:\ EdmGen2\bin\Debug\ ) . Type the following commands in the order below

EdmGen2 /ModelGen " Data Source= C:\SQLCEWebApp\App_Data\Database1.sdf" System.Data.SqlServerCe.4.0 Database1

EdmGen2 /FromEdmx Database1.edmx

EdmGen2 /Validate Database1.edmx

EdmGen2 /ViewGen cs Database1.edmx

EdmGen2 /CodeGen cs Database1.edmx

The folllowing files will be generated for you in same folder (eg: C:\ EdmGen2\bin\Debug\ ). Navigate to this folder using Windows Explorer.

Database1.edmx - This file is responsible for showing Table Design in Visual Studio
Database1.cs - This is the class file that contains the properties and methods to interact with the database
Database1.msl, Database1.ssdl - Metadata files

Next, Copy the Database1.edmx and Database1.cs to your SQLCEWebApp project using Add Existing Item option. A new Database1.Designer.cs file will be automatically created by Visual Studio for you underDatabase1.edmx . Replace all the code inside the Database1.Designer.cs file with code from our EdmGen2.exe generate Database1.cs file. Now delete the Database1.cs file. Otherwise we will get a compiler error. Then navigate to C:\SQLCEWebApp\obj\Debug\ using Windows Explorer create a new folder named "edmxResourcesToEmbed" without double qoutes. Now copy the 3 files(Database1.csdl,Database1.msl, Database1.ssdl ) to "edmxResourcesToEmbed" folder.

Come back to Visual Studio. Add the following connection string to web.config.

<add name="Database1Entities" connectionString="metadata=res://*/Database1.csdl|
res://*/Database1.ssdl|res://*/Database1.msl;provider=System.Data.SqlServerCe.4.0;
provider connection string=&quot;Data Source=|DataDirectory|\Database1.sdf;
Persist Security Info=True&quot;" providerName="System.Data.EntityClient"/>

Thats it!!!! Now you can start coding your LINQ queries againt Sql CE 4.0 the same way as querying againt Sql Server. Happy Coding!!!!!

Summary

It is very easy to create entity data model for Sql CE 4.0 using the WebMatrix and EdmGen2.exe.

In my next tutorial I will teach you how to use dynamic data with Sql CE 4.0.

Update 1 table with data from another using values from table 2

2010-08-01T22:28:00.000-07:00

Update 1 table with data from another using values from table 2

UPDATE table1, table2
SET table1.xyz = table2.xyz,
    table1.abc = table2.abc,
    table1.zamboni = table2.zamboni
WHERE table1.id = table2.id

2010-07-22T04:37:00.000-07:00

Protect html files using form authentication:

1.) follow the guide found here ( http://msdn2.microsoft.com/en-us/library/ms998360.aspx ) to configure the login page and default.aspx page

2.) configure .htm, .asp. etc. etc. extensions to use the same filter as a standard .aspx page:

a.) right click on your virtual directory --> properties

b.) find the virtual directories tab for IIS 5.0 or the Home directories tab for IIS 6.0 and click "Configuration"

c.) find the .aspx extension, double click, and copy the path to aspnet_isapi.dll, the path being found in the executable text area

d.) click "add" under the "application configuration" window and paste the path to aspnet_isapi.dll inf the executable text area

f.) type ".htm" (without the quotes) in the extension text area (this can be replace with any file extension eg: asp/html)

e.) while still in the "add/edit application extension mapping" window click the "limit to" radio button and type "GET,HEAD,POST,DEBUG"

f.) ensure that the "script engine" radio button is selected but not the "verify the file exists" radio button

3.) add the following to the script.web heading in web.config file for the directory:

<httpHandlers>
<add verb="GET, HEAD, POST, DEBUG" path="*.htm" type="System.Web.UI.PageHandlerFactory"/>
<add verb="GET, HEAD, POST, DEBUG" path="*.html" type="System.Web.UI.PageHandlerFactory"/>
<add verb="GET, HEAD, POST, DEBUG" path="*.asp" type="System.Web.UI.PageHandlerFactory"/>
</httpHandlers>

note: add any other extensions that were configuration in the application configuration window

4.) find the "compilation: section of the web.config file and ensure it looks like the following:

<compilation debug="false" strict="false" explicit="true">
<buildProviders>
<add extension=".htm" type="System.Web.Compilation.PageBuildProvider" />
<add extension=".asp" type="System.Web.Compilation.PageBuildProvider" />
<add extension=".html" type="System.Web.Compilation.PageBuildProvider" />
</buildProviders>
</compilation>

5.) Go grab a coffee, you're done!

Proper Case SQL Function

2010-06-23T06:47:00.000-07:00

create function ProperCase(@Text as varchar(8000))

returns varchar(8000)

as

begin

   declare @Reset bit;

   declare @Ret varchar(8000);

   declare @i int;

   declare @c char(1);

   select @Reset = 1, @i=1, @Ret = '';

   while (@i <= len(@Text))

    select @c= substring(@Text,@i,1),

               @Ret = @Ret + case when @Reset=1 then UPPER(@c) else LOWER(@c) end,

               @Reset = case when @c like '[a-zA-Z]' then 0 else 1 end,

               @i = @i +1

   return @Ret

end

Simple GridView Grouping with out helper class or Custom GridView Control

2010-04-20T07:29:00.000-07:00

In my previous post i used GNet GridView Control for acheiving Grouping.
In this post i will teach you how to acheive the same using ASP.NET GridView Control.

Type the following code in ASPX Page:


<asp:GridView ID="GridView1" runat="server" ShowHeader="false"

ShowFooter="false" AllowPaging="true" AutoGenerateColumns="false"

GridLines="None" PagerSettings-Mode="Numeric"

PagerSettings-Position="TopAndBottom" PagerStyle-HorizontalAlign="Right"

PagerStyle-Fore                                   

Page PagerStyle-CssClass="GridPager" OnRowDataBound="GridView1_RowDataBound"

OnPageIndexChanging="GridView1_PageIndexChanging" >

<Columns>                                                   

<asp:TemplateField>

<ItemTemplate>

<table>

<tr>

<td align="center" class="innercircle_text" valign="top" width="488">

<table width="445" border="0" class="innercircle_text" cellspacing="1" cellpadding="2"

id="Table15">                                               




//Here the Group header
<tr id="GridViewPointsHeader" runat="server">

<td align="center" class="innercircle_text" bgcolor="#F1ECDC" colspan="2" style="height: 25px">

<font><b><font size="2">

<asp:Label ID="lblTitlePoints" runat="server" ></asp:Label>

Points </font></b></font>

</td>

</tr>



<tr>

<td class="innercircle_text" valign="top" style="padding-top: 15px; width: 205px;">

<asp:Image ID="rewardImg" runat="server" AlternateText='<%# DataBinder.Eval(Container.DataItem,"image_path") %>'  Width="200" Height="220" BorderWidth="0"/></td>

<td align="center" class="innercircle_text" bgcolor="#ffffffff" valign="top">

<table width="98%" height="220px" border="0" cellspacing="0" cellpadding="0" class="bodytext"

id="Table16">

<tr valign="top">

<td colspan="2" class="innercircle_text" height="120" valign="top">

<p class="innercircle_text">

<b>

<%# DataBinder.Eval(Container.DataItem,"points") %>

Points:

<%# DataBinder.Eval(Container.DataItem,"item_name") %>

</b>

</p>

<p class="innercircle_text">

<%# DataBinder.Eval(Container.DataItem,"item_desc") %>

</p>

</td>

</tr>

<tr>

<td class="innercircle_text">

Item Code:<%# DataBinder.Eval(Container.DataItem,"Item_Code") %>

</td>

<td class="innercircle_text" align="right" width="65%">

<a href="javascript:MM_openBrWindow('redeem_gift.asp?itemcode=<%# DataBinder.Eval(Container.DataItem,"Item_Code") %>&desc=<%# DataBinder.Eval(Container.DataItem,"points") %> Points:<%# Server.UrlEncode(DataBinder.Eval(Container.DataItem,"item_name").ToString()) %>','','scrollbars=no,resizable=no,width=500,height=590,left=230,right=200,top=130')"

class="prim">Redeem your Reward Points</a> <a href="javascript:void(0)">

<img src="top.gif" width="10" height="10" border="0" alt="top of page"></a></td>

</tr>

</table>

</td>

</tr>

<tr height="12">

<td style="width: 205px">



</td>

</tr>



</table>

</td>

</tr>



</table>

</ItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

And then type the follwing code in Code Behind File(ie,ASPX.CS) File

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
string title;
HtmlTableRow GridViewPointsHeader = (HtmlTableRow)e.Row.FindControl("GridViewPointsHeader");
Label titleLabel = (Label)e.Row.FindControl("lblTitlePoints");
string strval = ds.Tables[0].Rows[e.Row.DataItemIndex]["points"].ToString().Trim();
if (e.Row.DataItemIndex == 0)
{

title = ds.Tables[0].Rows[e.Row.DataItemIndex]["points"].ToString().Trim();
titleLabel.Text = ds.Tables[0].Rows[e.Row.DataItemIndex]["points"].ToString();
GridViewPointsHeader.Visible = true;


}
else
{
title = ds.Tables[0].Rows[e.Row.DataItemIndex - 1]["points"].ToString().Trim();
if (title == strval)
{
GridViewPointsHeader.Visible = false;
}
else
{
titleLabel.Text = ds.Tables[0].Rows[e.Row.DataItemIndex]["points"].ToString();
GridViewPointsHeader.Visible = true;
}
}

Now you will get a nice GridView Grouping without any Helper Class or 3rd Party controls.

How to add Text or Server Controls(eg:Label) to GridView Pager

2010-04-19T04:15:00.000-07:00

Add the below code to add any Text or Any other controls to GridView Pager.

The code below adds a simple bar in between numbers and it look like this "|"

I used ZNet GridView for getting 700 Points group header.

Code:

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Pager)
{
TableCell sortCell = new TableCell();
sortCell.Text = "Page ";

Table tbl = (Table)e.Row.Cells[0].Controls[0];
foreach (TableCell mycells in tbl.Rows[0].Cells)
{

if (mycells.Controls[0] is Label)
{
Label lbl1 = new Label();
lbl1.Text = "|";

Label lbl2 = (Label)mycells.Controls[0];

mycells.Controls.Add(lbl2);
mycells.Controls.Add(lbl1);
}
else if (mycells.Controls[0] is LinkButton)
{
Label lbl = new Label();
lbl.Text = "|";

LinkButton lnk = (LinkButton)mycells.Controls[0];

mycells.Controls.Add(lnk);
mycells.Controls.Add(lbl);
}

}
tbl.Rows[0].Cells.AddAt(0, sortCell);

}
}