Date Range Validation in AJAX CalendarExtender Control using ASP.Net Range Validator

In this article I will explain how to implement Range Validation in ASP.Net AJAX Control Toolkit CalendarExtender Control.

 
<form id="form1" runat="server">
    <asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
   
    <asp:TextBox ID="txtDate" runat="server" ReadOnly = "true"></asp:TextBox>
    <br />
    <asp:RangeValidator runat="server" ID="RangeValidator1" Type="Date" ControlToValidate="txtDate" MaximumValue='09/20/2011' MinimumValue="09/01/2011"
    ErrorMessage="Date should be between 09/01/2011 and 09/20/2011" Display="Dynamic" />
   
    <cc1:CalendarExtender ID = "Calender1" runat = "server" TargetControlID = "txtDate"></cc1:CalendarExtender>
    <br />
    <asp:Button ID="Button1" runat="server" Text="Submit" />
</form>

Above you will notice that I have an ASP.Net TextBox Control txtDate for which I have specified AJAX Control Toolkit CalendarExtender Control Calender1.

Also I have specified ASP.Net RangeValidator Control RangeValidator1 for the TextBox txtDate. This range validator will throw error when the selected date does not fit in the specified range.

In order to make the Range Validator work for the Dates. You need to specify the following paramaters

Type – Specifies that the range validations are for Dates.

MinimumValue – Specifies the minimum value of the range.

MaximumValue - Specifies the minimum value of the range.

 

Screenshot

ASP.NET AJAX Calendar Extender – Tips and Tricks

ASP.NET AJAX Calendar Extender – Tips and Tricks

The CalendarExtender is an ASP.NET AJAX control that is associated with a TextBox control. When the user clicks on the TextBox, a client-side Calendar control pops up. The user can then set a date by clicking on a day, navigate months by clicking on the left and right arrow and perform other such actions without a postback. In this article, we will see some tips and tricks that can be applied to a CalendarExtender control. If you are new to the CalendarExtender control, you can check out some information about it over here.

I assume you have some basic experience developing ASP.NET Ajax applications and have installed theASP.NET Ajax Library and ASP.NET Control Toolkit. As of this writing, the toolkit version is Version 1.0.20229 (if you are targeting Framework 2.0, ASP.NET AJAX 1.0 and Visual Studio 2005) and Version 3.0.20229 (if targeting .NET Framework 3.5 and Visual Studio 2008).

All the tips shown below have been created using Version 3.0.20229 (targeting .NET Framework 3.5 and Visual Studio 2008).

Tip 1: How to display and hide a Calendar on the click of a Button

If you want to popup a Calendar on the click of a button, you can use set the PopupButtonID of the CalendarExtender to the ID of the button. In this case, we will be using an ImageButton as shown below:

<asp:ImageButton runat="Server" ID="ImageButton1" ImageUrl="~/Images/Icon1.jpg"AlternateText="Click here to display calendar" />

<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

<cc1:CalendarExtender ID="CalendarExtender1" runat="server"

TargetControlID="TextBox1" PopupButtonID="ImageButton1"/>

If you are using an earlier version of the toolkit, you may observe that the ImageButton causes a postback when you click on it again, to close the Calendar. To avoid the postback, use a HTML Image Control instead of the Server side Image Control as shown below:

<img alt="Icon" src="/Images/Icon1.jpg" id="Image1" />

<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

<cc1:CalendarExtender ID="CalendarExtender1" runat="server"

TargetControlID="TextBox1" PopupButtonID="Image1"/>

Note: In case you are clicking on the textbox to open the calendar, then in earlier versions of the toolkit, the calendar would not hide automatically when the user clicked anywhere outside the Calendar control. However this was fixed in the later versions. In fact, in the latest version, the Calendar hides automatically when a date is selected.

If for some reason you are facing issues with the Calendar not hiding automatically, make sure that you have the latest version of the AJAX Control Toolkit.

Tip 2: How to Add a CalendarExtender to a GridView

If you want to add a CalendarExtender to a GridView, use a template field with a TextBox and CalendarExtender as shown below:

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

<asp:ScriptManager ID="ScriptManager1" runat="server" />

<div>

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"DataKeyNames="CategoryID"

DataSourceID="SqlDataSource1" ShowFooter="true" AllowPaging="True"AllowSorting="True">

<Columns>

<asp:BoundField DataField="CategoryID" HeaderText="CategoryID"

SortExpression="CategoryID" />

<asp:BoundField DataField="CategoryName" HeaderText="CategoryName"

SortExpression="CategoryName" />

<asp:TemplateField>

<ItemTemplate>

<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

<cc1:CalendarExtender ID="CalendarExtender1" runat="server"TargetControlID="TextBox1"/>

</ItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Data Source=SUPROTIM;Initial Catalog=Northwind;Integrated Security=True"

SelectCommand="SELECT [CategoryID], [CategoryName] FROM [Categories]" >

</asp:SqlDataSource>

</div>

</form>

Tip 3: Enable Year Navigation in CalendarExtender

When the calendar appears, click on the title of the calendar to change the view to Months in the current year. Clicking it again, switches the view to Years, showing 10 years at a time.

If you plan to do this programmatically, here’s some code for you. Use the OnClientShown event and switch the mode using javascript. This tip was shared by one of the Microsoft® support person at the asp.net forums.

<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

<cc1:CalendarExtender ID="CalendarExtender1"

runat="server" TargetControlID="TextBox1" OnClientShown="ChangeCalendarView" />

Then add this to the <head> section

<head runat="server">

<title>CalendarExtender</title>

<script type="text/javascript">

function ChangeCalendarView(sender,args)

{

   sender._switchMode("years", true);          

}

</script>

</head>

Tip 4: Display only the day and month in the CalendarExtender

To select only the day and month without the year, use the Format property of the CalendarExtender and set it to “dd/MM” as shown below:

<cc1:CalendarExtender ID="CalendarExtender1" runat="server" Format="dd/MM"TargetControlID="TextBox1" />

Tip 5: How to Set Culture to work with CalendarExtender

Make sure that the ScriptManager has EnableScriptGlobalization="true" and EnableScriptLocalization="true".

<asp:ScriptManager ID="ScriptManager1" runat="server"

EnableScriptGlobalization="true" EnableScriptLocalization="true" />

Tip 6: How to make sure user does not select a date earlier than today or greater than today

There could be instances where you do not want the user to select a day earlier than the current date. For example: when you are providing the user a form to book tickets, you would not like him to choose an earlier date. To achieve this requirement, use the following javascript code.

Prevent the User from selecting a Date Earlier than today

<head runat="server">

<title>Calendar Extender</title>

<script type="text/javascript">

function checkDate(sender,args)

{

if (sender._selectedDate < new Date())

            {

                alert("You cannot select a day earlier than today!");

                sender._selectedDate = new Date();

// set the date back to the current date

sender._textbox.set_Value(sender._selectedDate.format(sender._format))

            }

}

</script>

</head>

Call the code:

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

<asp:ScriptManager ID="ScriptManager1" runat="server" />

<div>

<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

<cc1:CalendarExtender ID="CalendarExtender1"

runat="server"OnClientDateSelectionChanged="checkDate" TargetControlID="TextBox1" />

</div>

</form>

Select Date Greater than today

In the javascript, just change this line

sender._selectedDate > new Date()

Note: You may argue that the user can still change the date by typing into the textbox or entering an invalid date. Well that can be easily handled using a ValidationControl and is covered in the next tip.

Tip 7: Add validation to the CalendarExtender Control

A simple way to add validation to the Calendar is to add a ValidationControl to the textbox associated with a CalendarExtender. You have two choices:

A. Add an ‘Extender’ to the ValidationControl. To do so, drag and drop a ValidationControl > click on the smart tag of the ValidationControl > choose ‘Add Extender’. From the Extender Wizard, choose ValidatorCalloutExtender. Using this approach makes it extremely easy to discover and attach control extenders to your controls. In VS 2005, you had to do this process manually, by wiring up control extenders.

B. You can choose not to add the Extender.

We will go ahead with option A. We will be adding two ValidationControls to the textbox. The first, a CompareValidator to check if the user does not enter an invalid date (Eg: May 32) and second, a RangeValidator to keep the date range as desired.

Adding CompareValidator

<asp:CompareValidator ID="CompareValidator1" runat="server"

ControlToValidate="TextBox1" Display="Dynamic" ErrorMessage="Invalid Date"

Operator="DataTypeCheck" Type="Date">

</asp:CompareValidator>

<cc1:ValidatorCalloutExtender ID="CompareValidator1_ValidatorCalloutExtender"

runat="server" Enabled="True" TargetControlID="CompareValidator1">

</cc1:ValidatorCalloutExtender>

Adding RangeValidator – We will restrict the user to select a date range starting from today to 15 days from now.

<asp:RangeValidator ID="RangeValidator1" runat="server"

ControlToValidate="TextBox1" ErrorMessage="RangeValidator"

Type="Date">

</asp:RangeValidator>

<cc1:ValidatorCalloutExtender ID="RangeValidator1_ValidatorCalloutExtender"

runat="server" Enabled="True" TargetControlID="RangeValidator1">

</cc1:ValidatorCalloutExtender>

In the code behind of your page, add this code

C#

protected void Page_Load(object sender, EventArgs e)

    {

        RangeValidator1.MinimumValue = System.DateTime.Now.ToShortDateString();

        RangeValidator1.MaximumValue = System.DateTime.Now.AddDays(15).ToShortDateString();

    }

VB.NET

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)

            RangeValidator1.MinimumValue = System.DateTime.Now.ToShortDateString()

            RangeValidator1.MaximumValue = System.DateTime.Now.AddDays(15).ToShortDateString()

End Sub

Well those were some tips associated with the CalendarExtender. As future versions of the toolkit are released, we should be hopeful that there will exist easier ways, of achieving the functionality discussed in this article. I hope this article was useful and I thank you for viewing it.

Asynchrous Save

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="AsynchrousSave.aspx.cs" Inherits="DUMMY_AsynchrousSave" %>
<!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'>
        function GetMessage() {
            PageMethods.Message(OnGetMessageSuccess, OnGetMessageFailure);
        }
        function OnGetMessageSuccess(result, userContext, methodName) {
            alert(result);
        }
        function OnGetMessageFailure(error, userContext, methodName) {
            alert(error.get_message());
        }
    </script>
</head>
<body>
    <form id="form1" runat="server">
    <asp:ScriptManager ID='ScriptManager1' runat='server' EnablePageMethods='true' />
    <div>
    <input type='submit' value='Get Message' onclick='GetMessage();return false;' />
    </div>
    
    </form>
</body>
</html>

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 DUMMY_AsynchrousSave : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
    }
    [System.Web.Services.WebMethod]
    public static string Message()
    {
        string Output = string.Empty;
        try
        {
            UserDetail objUserDetail = new UserDetail();
            objUserDetail.Id = Guid.NewGuid();
            objUserDetail.FirstName = "FirstName";
            objUserDetail.LastName = "LastName";
            objUserDetail.Email = "test@test.com";
            UserDetailProvider.Save(objUserDetail);
            Output = "Message Successfull";
        }
        catch (Exception ex)
        {
            Output = "Message Not Successfull";
        }
        return Output;//"Hello from the server-side World!";
    }
}

Ajax Editor Validation

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default5.aspx.cs" Inherits="Default5" %>

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit.HTMLEditor"
    TagPrefix="cc1" %>

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

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
    <title></title>


    <script type="text/javascript">
        function Validation() {
            var text = document.getElementById('txt1').value;
            if (text == "") {
                alert('Name Cannot be empty');
                document.getElementById('txt1').focus();
                return false;
            }

            test()
        }

        function test() {
            var a = $find("Editor1");
            var value = a.get_content();
            if (value == "") {
                $get("result").innerHTML = "Editor's content is empty";
                alert('Editor Cannot be empty');
               
                return false;
            }
        }


    </script>


</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:ScriptManager ID="ScriptManager1" runat="server" />

        Name:<asp:TextBox ID="txt1" runat="server"></asp:TextBox>
        <br />

        <cc1:Editor ID="Editor1" runat="server" Width="300" Height="300" ValidationGroup="Editor" />
        <br />
        <span id="result"></span>
        <br />
        <asp:Button ID="Button1" runat="server" Text="Submit" OnClientClick="return Validation();"
            CausesValidation="true" ValidationGroup="Editor" />
    </div>
    </form>
</body>
</html>

PopUp window

Default.aspx
----------------
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>User Form</title>
    <link href="StyleSheet.css" rel="stylesheet" type="text/css" />
    <script language="javascript" type="text/javascript">
      function win_open()
      {
        window.open("search.aspx","","menubar=no,status=no,scrollbars=yes,resizable=no,toolbar=no,top=180,left=250,width=600,height=400");
      }
      
      function doc_clr()
      {
        document.getElementById("txtuname").value="";
        document.getElementById("txtfname").value="";
        document.getElementById("txtlanme").value="";
        document.getElementById("txtmail").value="";
        document.getElementById("txtmobile").value="";
        document.getElementById("txtcity").value="";
      }
    </script>
</head>
<body>
    <form id="form1" runat="server">
        <asp:ScriptManager ID="ScriptManager1" runat="server" />
        <table width="100%" cellpadding="4" cellspacing="1" border="0">
         <tr><td>
            <table width="740px" cellpadding="4" cellspacing="1" border="0" align="center" style="border:solid 1px #bfd2d8;">
              <tr><td colspan="2" class="th">User Information</td></tr>
              <tr>
               <td class="td1">User Name</td>
               <td class="td2"><asp:TextBox ID="txtuname" runat="server" MaxLength="10"></asp:TextBox></td>
              </tr>
              <tr>
               <td class="td1">First Name</td>
               <td class="td2"><asp:TextBox ID="txtfname" runat="server" MaxLength="20"></asp:TextBox></td>
              </tr>
              <tr>
               <td class="td1">Last Name</td>
               <td class="td2"><asp:TextBox ID="txtlanme" runat="server" MaxLength="20"></asp:TextBox></td>
              </tr>
              <tr>
               <td class="td1">Email</td>
               <td class="td2"><asp:TextBox ID="txtmail" runat="server" MaxLength="40"></asp:TextBox></td>
              </tr>
              <tr>
               <td class="td1">Mobile</td>
               <td class="td2"><asp:TextBox ID="txtmobile" runat="server" MaxLength="10"></asp:TextBox></td>
              </tr>
              <tr>
               <td class="td1">City</td>
               <td class="td2"><asp:TextBox ID="txtcity" runat="server" MaxLength="10"></asp:TextBox></td>
              </tr>
              <tr>
                <td colspan="2" style="text-align:center;">
                  <asp:Button ID="btnSearch" runat="server" CssClass="btn" Text="Search" OnClientClick="win_open()" CausesValidation="false" Width="60px" /> &nbsp;&nbsp;
                  <asp:Button ID="btnclear" runat="server" CssClass="btn" Text="Clear" OnClientClick="doc_clr()" CausesValidation="false"/> &nbsp;&nbsp;
                  <asp:Button ID="btnSave" runat="server" Text="Save" CssClass="btn" /> &nbsp;&nbsp;
                  <asp:Button ID="btnDelete" runat="server" Text="Delete" CssClass="btn" CausesValidation="false" />
                </td>
              </tr>
            </table>
         </td></tr>
        </table>
    </form>
</body>
</html>
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------
search.aspx
------------
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="search.aspx.cs" Inherits="search" %>
<!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>Search</title>
    <link href="StyleSheet.css" rel="stylesheet" type="text/css" />
    <script language="javascript" type="text/javascript">
     
      function CalltoParent(user)
      {
        if(window.opener!=null){
          if(window.opener.document.getElementById('txtuname')!=null){
             var uval=user.parentNode.parentNode;
             window.opener.document.getElementById('txtuname').value = uval.childNodes[0].childNodes[0].innerText;
             window.opener.document.getElementById('txtfname').value = uval.childNodes[1].childNodes[0].innerText;
             window.opener.document.getElementById('txtlanme').value = uval.childNodes[2].childNodes[0].innerText;
             window.opener.document.getElementById('txtmail').value = uval.childNodes[3].childNodes[0].innerText;
             window.opener.document.getElementById('txtmobile').value = uval.childNodes[4].childNodes[0].innerText;
             window.opener.document.getElementById('txtcity').value = uval.childNodes[5].childNodes[0].innerText;
             window.opener.document.getElementById('btnSave').value = "Update";
             window.close();
          }
          return true;	
        }
      }
    </script>
</head>
<body>
    <form id="form1" runat="server">
      <table width="100%" cellpadding="4" cellspacing="1" border="0">
       <tr>
        <td>
          <table width="60%" cellpadding="4" cellspacing="1" border="0" align="center">
           <tr>
             <td>Name</td>
             <td><asp:TextBox ID="txtname" runat="server"></asp:TextBox></td>
             <td>City</td>
             <td><asp:TextBox ID="txtcity" runat="server"></asp:TextBox></td>
             <td><asp:Button ID="btnsearch" runat="server" Text="Search" OnClick="btnsearch_Click" /></td>
           </tr>
           <tr>
            <td colspan="5">
                <asp:GridView ID="GridView1" runat="server" Visible="False" AutoGenerateColumns="False" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="3" Font-Names="Verdana" Width="540px">
                 <Columns>
                   <asp:TemplateField HeaderText="User Name">
                    <ItemTemplate>
                       <a style="cursor: hand" onmouseover="this.style.textDecoration='underline'" onmouseout="this.style.textDecoration='none'"
                            name="UserName" onclick="javascript:CalltoParent(this)" runat="server"
                            id="uname">
                            <%# DataBinder.Eval(Container.DataItem, "UserName") %>
                        </a>
                    </ItemTemplate>
                   </asp:TemplateField>
                   <asp:TemplateField HeaderText="First Name">
                    <ItemTemplate>
                       <a style="cursor: hand" onmouseover="this.style.textDecoration='underline'" onmouseout="this.style.textDecoration='none'"
                            name="Fname" onclick="javascript:CalltoParent(this)" runat="server"
                            id="fname">
                            <%# DataBinder.Eval(Container.DataItem, "FName") %>
                        </a>
                    </ItemTemplate>
                   </asp:TemplateField>
                   <asp:TemplateField HeaderText="Last Name">
                    <ItemTemplate>
                       <a style="cursor: hand" onmouseover="this.style.textDecoration='underline'" onmouseout="this.style.textDecoration='none'"
                            name="Lname" onclick="javascript:CalltoParent(this)" runat="server"
                            id="lanme">
                            <%# DataBinder.Eval(Container.DataItem, "LName") %>
                        </a>
                    </ItemTemplate>
                   </asp:TemplateField>
                   <asp:TemplateField HeaderText="City">
                    <ItemTemplate>
                       <a style="cursor: hand" onmouseover="this.style.textDecoration='underline'" onmouseout="this.style.textDecoration='none'"
                            name="city" onclick="javascript:CalltoParent(this)" runat="server"
                            id="city">
                            <%# DataBinder.Eval(Container.DataItem, "City") %>
                        </a>
                    </ItemTemplate>
                   </asp:TemplateField>
                   <asp:TemplateField HeaderText="Email" HeaderStyle-CssClass="fls" ItemStyle-CssClass="fls">
                    <ItemTemplate>
                       <a style="cursor: hand" onmouseover="this.style.textDecoration='underline'" onmouseout="this.style.textDecoration='none'"
                            name="mail" onclick="javascript:CalltoParent(this)" runat="server"
                            id="mail">
                            <%# DataBinder.Eval(Container.DataItem, "Email")%>
                        </a>
                    </ItemTemplate>
                   </asp:TemplateField>
                   <asp:TemplateField HeaderText="Mobile" HeaderStyle-CssClass="fls" ItemStyle-CssClass="fls">
                    <ItemTemplate>
                       <a style="cursor: hand" onmouseover="this.style.textDecoration='underline'" onmouseout="this.style.textDecoration='none'"
                            name="mobile" onclick="javascript:CalltoParent(this)" runat="server"
                            id="mobile">
                            <%# DataBinder.Eval(Container.DataItem, "Mobile")%>
                        </a>
                    </ItemTemplate>
                   </asp:TemplateField>
                 </Columns>
                    <FooterStyle BackColor="White" ForeColor="#000066" />
                    <RowStyle ForeColor="#000066" />
                    <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
                    <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
                    <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
                </asp:GridView>
            </td>
           </tr>
          </table>
        </td>
       </tr>
      </table>
    </form>
</body>
</html>
search.aspx.cs
------------------
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 search : System.Web.UI.Page
{
    DataTable dt = new DataTable();
    DataColumn dtcol;
    DataRow dr;
    protected void Page_Load(object sender, EventArgs e)
    {
    }
    protected void btnsearch_Click(object sender, EventArgs e)
    {
        // Here adding DataTable to bind the grid....
        // For dynamic get the search details from DB and bind these details to grid
        bindgrid();
    }
    private void bindgrid()
    {
        makedt();
        GridView1.Visible = true;
        GridView1.DataSource = dt;
        GridView1.DataBind();
    }
    private void makedt()
    {
        dtcol = new DataColumn("UserName");
        dt.Columns.Add(dtcol);
        dtcol = new DataColumn("FName");
        dt.Columns.Add(dtcol);
        dtcol = new DataColumn("LName");
        dt.Columns.Add(dtcol);
        dtcol = new DataColumn("City");
        dt.Columns.Add(dtcol);
        dtcol = new DataColumn("Email");
        dt.Columns.Add(dtcol);
        dtcol = new DataColumn("Mobile");
        dt.Columns.Add(dtcol);
        dr = dt.NewRow();
        dr["UserName"] = "Ram";
        dr["FName"] = "Ram";
        dr["LName"] = "Krishna ";
        dr["City"] = "Hyderabad";
        dr["Email"] = "n.ramakrishna27@gmail.com";
        dr["Mobile"] = "123456";
        dt.Rows.Add(dr);
        dr = dt.NewRow();
        dr["UserName"] = "Naveen";
        dr["FName"] = "Naveen";
        dr["LName"] = "Reddy";
        dr["City"] = "Sec-Bad";
        dr["Email"] = "naveen@yahoo.co.in";
        dr["Mobile"] = "4210";
        dt.Rows.Add(dr);
        dr = dt.NewRow();
        dr["UserName"] = "Raj";
        dr["FName"] = "Raja";
        dr["LName"] = "Shekar";
        dr["City"] = "Banglore";
        dr["Email"] = "raj4u@yahoo.com";
        dr["Mobile"] = "01200";
        dt.Rows.Add(dr);
        dr = dt.NewRow();
        dr["UserName"] = "Suresh";
        dr["FName"] = "Suresh";
        dr["LName"] = "Kumar";
        dr["City"] = "Chennai";
        dr["Email"] = "suri@hotmail.com";
        dr["Mobile"] = "10120";
        dt.Rows.Add(dr);
        dr = dt.NewRow();
        dr["UserName"] = "Ravi";
        dr["FName"] = "Ravi";
        dr["LName"] = "Kumar";
        dr["City"] = "Vizag";
        dr["Email"] = "ravi@gmail.com";
        dr["Mobile"] = "1234";
        dt.Rows.Add(dr);
        dr = dt.NewRow();
        dr["UserName"] = "Shaik";
        dr["FName"] = "Shaik";
        dr["LName"] = "Khan";
        dr["City"] = "Vijayawada";
        dr["Email"] = "shaik@rediff.com";
        dr["Mobile"] = "1234";
        dt.Rows.Add(dr);
        dr = dt.NewRow();
        dr["UserName"] = "Kiran";
        dr["FName"] = "Kiran";
        dr["LName"] = "Kumar";
        dr["City"] = "Hyderabad";
        dr["Email"] = "kiran@yahoo.com";
        dr["Mobile"] = "12453";
        dt.Rows.Add(dr);
        dr = dt.NewRow();
        dr["UserName"] = "Santu";
        dr["FName"] = "Santhosh";
        dr["LName"] = "Reddy";
        dr["City"] = "Hyderabad";
        dr["Email"] = "santu@yahoo.com";
        dr["Mobile"] = "123";
        dt.Rows.Add(dr);
        dr = dt.NewRow();
        dr["UserName"] = "Ashfak";
        dr["FName"] = "Ashfak";
        dr["LName"] = "Khan";
        dr["City"] = "Hyderabad";
        dr["Email"] = "ash@yahoo.com";
        dr["Mobile"] = "123";
        dt.Rows.Add(dr);
        dr = dt.NewRow();
        dr["UserName"] = "Sajju";
        dr["FName"] = "Sajju";
        dr["LName"] = "MD";
        dr["City"] = "Hyderabad";
        dr["Email"] = "sajju@gmail.com";
        dr["Mobile"] = "123";
        dt.Rows.Add(dr);
    }
}

output: -------