Monday, August 13, 2012

Export to CSV File

Code Snippet
  1. <%@ Page Language="C#" %>
  2.  
  3. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
  4.     "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  5. <html xmlns="http://www.w3.org/1999/xhtml" >
  6. <head>
  7.     <title>Export To CSV</title>
  8. <script runat="server">
  9.     public static void ExportCSV(System.Data.DataTable data, string fileName)
  10.     {
  11.         try
  12.         {
  13.             HttpContext context = HttpContext.Current;
  14.  
  15.             context.Response.Clear();
  16.             context.Response.ContentType = "text/csv";
  17.             context.Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName + ".csv");
  18.  
  19.             //rite column header names
  20.             for (int i = 0; i < data.Columns.Count; i++)
  21.             {
  22.                 if (i > 0)
  23.                 {
  24.                     context.Response.Write(",");
  25.                 }
  26.                 context.Response.Write(data.Columns[i].ColumnName);
  27.             }
  28.             context.Response.Write(Environment.NewLine);
  29.             //Write data
  30.             foreach (System.Data.DataRow row in data.Rows)
  31.             {
  32.                 for (int i = 0; i < data.Columns.Count; i++)
  33.                 {
  34.                     if (i > 0)
  35.                     {
  36.                         context.Response.Write(",");
  37.                     }
  38.                     context.Response.Write(row[i].ToString());
  39.                 }
  40.                 context.Response.Write(Environment.NewLine);
  41.             }
  42.             context.Response.End();
  43.         }
  44.         catch (Exception ex)
  45.         {
  46.  
  47.         }
  48.  
  49.     }
  50.     
  51.     
  52.      private System.Data.DataTable CreateDataTable()
  53.     {
  54.         System.Data.DataTable dataTable = new System.Data.DataTable("Employee");
  55.  
  56.         dataTable.Columns.Add(new System.Data.DataColumn("ID", typeof(int)));
  57.         dataTable.Columns.Add(new System.Data.DataColumn("Name", typeof(string)));
  58.         dataTable.Columns.Add(new System.Data.DataColumn("Address", typeof(string)));
  59.  
  60.         System.Data.DataRow dataRow;
  61.  
  62.         dataRow = dataTable.NewRow();
  63.         dataRow["ID"] = "1";
  64.         dataRow["Name"] = "sandeep";
  65.         dataRow["Address"] = "Ncode";
  66.         dataTable.Rows.Add(dataRow);
  67.  
  68.         return dataTable;
  69.     }
  70.  
  71.      protected void btnExportDataTableToCSV_Click(object sender, EventArgs e)
  72.      {
  73.          ExportCSV(CreateDataTable(), "FileName");
  74.      }
  75.  
  76. </script>
  77.  
  78. </head>
  79. <body>
  80.  
  81.     <h3>FileUpload.SaveAs Method Example</h3>
  82.  
  83.     <form id="Form1" runat="server">
  84.  
  85.        <asp:Button ID="btnExportDataTableToCSV" runat="server" OnClick="btnExportDataTableToCSV_Click" Text="Export DataTable to CSV" />
  86.  
  87.     </form>
  88.  
  89. </body>
  90. </html>

Ajax Editor Validation

Code Snippet
  1. <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default5.aspx.cs" Inherits="Default5" %>
  2.  
  3. <%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit.HTMLEditor"
  4.     TagPrefix="cc1" %>
  5.  
  6. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  7.  
  8. <html xmlns="http://www.w3.org/1999/xhtml">
  9. <head id="Head1" runat="server">
  10.     <title></title>
  11.  
  12.  
  13.     <script type="text/javascript">
  14.         function Validation() {
  15.             var text = document.getElementById('txt1').value;
  16.             if (text == "") {
  17.                 alert('Name Cannot be empty');
  18.                 document.getElementById('txt1').focus();
  19.                 return false;
  20.             }
  21.  
  22.             test()
  23.         }
  24.  
  25.         function test() {
  26.             var a = $find("Editor1");
  27.             var value = a.get_content();
  28.             if (value == "") {
  29.                 $get("result").innerHTML = "Editor's content is empty";
  30.                 alert('Editor Cannot be empty');
  31.                
  32.                 return false;
  33.             }
  34.         }
  35.  
  36.  
  37.     </script>
  38.  
  39.  
  40. </head>
  41. <body>
  42.     <form id="form1" runat="server">
  43.     <div>
  44.         <asp:ScriptManager ID="ScriptManager1" runat="server" />
  45.  
  46.         Name:<asp:TextBox ID="txt1" runat="server"></asp:TextBox>
  47.         <br />
  48.  
  49.         <cc1:Editor ID="Editor1" runat="server" Width="300" Height="300" ValidationGroup="Editor" />
  50.         <br />
  51.         <span id="result"></span>
  52.         <br />
  53.         <asp:Button ID="Button1" runat="server" Text="Submit" OnClientClick="return Validation();"
  54.             CausesValidation="true" ValidationGroup="Editor" />
  55.     </div>
  56.     </form>
  57. </body>
  58. </html>

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>

Friday, August 10, 2012

Javascript From Date Less Than Current Date Validation


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

<!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>Untitled Page</title>
<script type="text/javascript">

function dateValidation() {

var obj = document.getElementById("<%=txtfrom.ClientID%>");
var day = obj.value.split("/")[1];

var month = obj.value.split("/")[0];
var year = obj.value.split("/")[2];


////todate
var obj2 = document.getElementById("<%=txtto.ClientID%>");
var day2 = obj2.value.split("/")[1];

var month2 = obj2.value.split("/")[0];
var year2 = obj2.value.split("/")[2];



if ((day < 1 || day > 31) || (month < 1 && month > 12) && (year.length != 4)) {

alert("Invalid Format"); return false;
}

else {

var dt = new Date(year, month - 1, day);
var today = new Date();

var dt2 = new Date(year2, month2 - 1, day2);
var today2 = new Date();

if ((dt.getDate() != day) || (dt.getMonth() != month - 1) || (dt.getFullYear() != year) || (dt < today)) {

//alert("Invalid from Date");
alert("From Date cannot be less than Current date");
return false;
}

if ((dt2.getDate() != day2) || (dt2.getMonth() != month2 - 1) || (dt2.getFullYear() != year2) || (dt2 < today2)) {
alert("To Date cannot be less than Current date");
// alert("Invalid to Date");
return false;
}

if(dt > dt2) {
alert("Start date can not greater than End date.");
return false;
}

// CompareDate(txtfrom, txtto);

}

}


function CompareDate(txtfrom, txtto) {
var From = txtfrom.value;
var To = txtto.value;
var strSplitFrom = From.split('/')
var myDateFrom = new Date();
myDateFrom.setFullYear(strSplitFrom[2], strSplitFrom[1] - 1, strSplitFrom[0]);
var strSplitTo = To.split('/')
myDateTo = new Date();
myDateTo.setFullYear(strSplitTo[2], strSplitTo[1] - 1, strSplitTo[0]);
if (myDateFrom > myDateTo) {
alert("Start date can not greater than End date.");
txtfrom.focus();
return false;
}
else {
return true;
}
}
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
<p><b>DD/MM/YEAR Format</b></P>
From Date<asp:TextBox ID="txtfrom" runat="server"></asp:TextBox>
<br/>
To Date
<asp:TextBox ID="txtto" runat="server"></asp:TextBox>
<br/>
<asp:Button ID="Button1" runat="server" Text="Click" OnClientClick="return dateValidation()" />
</div>
</form>
</body>
</html>

Wednesday, May 2, 2012

DropDownList FindByText

Default.aspx
---------------
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <asp:DropDownList ID="ddl1" runat="server">
    <asp:ListItem>One</asp:ListItem>
    <asp:ListItem>Two</asp:ListItem>
    <asp:ListItem>Three</asp:ListItem>
    </asp:DropDownList>
    </div>
    </form>
</body>
</html>
Default.aspx.cs
---------------
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class Default3 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        ListItem item = ddl1.Items.FindByText("Three");
        if (item != null)
        {
            item.Selected = true;
        }
    }
}



output:
--------


Wednesday, March 7, 2012

Autofocus Controls when Posted Back

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

<!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>Untitled Page</title>

   

    <script type="text/javascript">
        function keypressed(e) {
            var intKey = (window.Event) ? e.keyCode : e.which;

            if (intKey == 13) {
                document.getElementById('<%=text2.ClientID %>').focus();
                return false;
            }

        }

        function keypressed2(e) {
            var intKey = (window.Event) ? e.keyCode : e.which;
            if (intKey == 13) {

                document.getElementById('<%=text3.ClientID %>').focus();
                return false;

            }
        }

        function keypressed3(e) {
            var intKey = (window.Event) ? e.keyCode : e.which;
            if (intKey == 13) {

                document.getElementById('<%=text4.ClientID %>').focus();
                return false;

            }
        }

        function keypressed4(e) {
            var intKey = (window.Event) ? e.keyCode : e.which;
            if (intKey == 13) {

                document.getElementById('<%=text5.ClientID %>').focus();
                return false;

            }
        }

        function keypressed5(e) {
            var intKey = (window.Event) ? e.keyCode : e.which;
            if (intKey == 13) {

                document.getElementById('<%=text6.ClientID %>').focus();
                return false;

            }
        }

        function keypressed6(e) {
            var intKey = (window.Event) ? e.keyCode : e.which;
            if (intKey == 13) {

                document.getElementById('<%=text7.ClientID %>').focus();
                return false;

            }
        }

        function keypressed7(e) {
            var intKey = (window.Event) ? e.keyCode : e.which;
            if (intKey == 13) {

                document.getElementById('<%=text8.ClientID %>').focus();
                return false;

            }
        }

        function keypressed8(e) {
            var intKey = (window.Event) ? e.keyCode : e.which;
            if (intKey == 13) {

                document.getElementById('<%=text9.ClientID %>').focus();
                return false;

            }
        }

        function keypressed9(e) {
            var intKey = (window.Event) ? e.keyCode : e.which;
            if (intKey == 13) {

                document.getElementById('<%=text10.ClientID %>').focus();
                return false;

            }
        }

        function keypressed10(e) {
            var intKey = (window.Event) ? e.keyCode : e.which;
            if (intKey == 13) {

                document.getElementById('<%=DropDownList2.ClientID %>').focus();
                return false;

            }
        }

        function keypressed11(e) {
            var intKey = (window.Event) ? e.keyCode : e.which;
            if (intKey == 13) {

                document.getElementById('<%=DropDownList1.ClientID %>').focus();
                return false;

            }
        }

        function keypressed12(e) {
            var intKey = (window.Event) ? e.keyCode : e.which;
            if (intKey == 13) {

                document.getElementById('<%=Button1.ClientID %>').focus();
                return false;

            }
        }

        function Validation1() {
            if (document.getElementById('<%=DropDownList1.ClientID %>').value == "Select::") {
                alert('select DropDownList');
                document.getElementById('<%=Button1.ClientID %>').focus();
                return false;
            }
        }
    </script>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <asp:TextBox  onkeypress="return keypressed(event)"  id="text1" runat="server" Width="200px" AutoPostBack="True" TabIndex="1" ></asp:TextBox><br/>
    <asp:TextBox onkeypress="return keypressed2(event)" id="text2" runat="server" Width="200px" TabIndex="2"></asp:TextBox><br/>
    <asp:TextBox onkeypress="return keypressed3(event)" id="text3" runat="server" Width="200px"  TabIndex="3"></asp:TextBox><br/>
    <asp:TextBox onkeypress="return keypressed4(event)" id="text4" runat="server" Width="200px"  TabIndex="4"></asp:TextBox><br/>
    <asp:TextBox onkeypress="return keypressed5(event)" id="text5" runat="server" Width="200px"  TabIndex="5"></asp:TextBox><br/>
    <asp:TextBox onkeypress="return keypressed6(event)" id="text6" runat="server" Width="200px"  TabIndex="6"></asp:TextBox><br/>
    <asp:TextBox onkeypress="return keypressed7(event)" id="text7" runat="server" Width="200px"  TabIndex="7"></asp:TextBox><br/>
    <asp:TextBox onkeypress="return keypressed8(event)" id="text8" runat="server" Width="200px"  TabIndex="8"></asp:TextBox><br/>
    <asp:TextBox onkeypress="return keypressed9(event)" id="text9" runat="server" Width="200px"  TabIndex="9"></asp:TextBox><br/>
    <asp:TextBox onkeypress="return keypressed10(event)" id="text10" runat="server" Width="200px"  TabIndex="10"></asp:TextBox><br/>
     
      <asp:DropDownList ID="DropDownList2" runat="server" AutoPostBack="true" onkeypress="return keypressed11(event)"  TabIndex="11">
        <asp:ListItem>Select::</asp:ListItem>
         <asp:ListItem>TN</asp:ListItem>
          <asp:ListItem>AP</asp:ListItem>
        </asp:DropDownList><br/>

     
     <asp:DropDownList ID="DropDownList1" runat="server" onkeypress="return keypressed12(event)"  TabIndex="12">
        <asp:ListItem>Select::</asp:ListItem>
        </asp:DropDownList><br/>


     <asp:Button ID="Button1" runat="server" OnClientClick="return Validation1();" Text="Button" OnClick="Button1_Click" />
<asp:Label id="lblMsg" runat="server" forecolor="Red" text="* Username must be alphanumeric with no special characters"></asp:Label>
    </div>
    </form>
</body>
</html>




using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class Default18 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Page.IsPostBack)
        {
            WebControl wcICausedPostBack = (WebControl)GetControlThatCausedPostBack(sender as Page);
            int indx = wcICausedPostBack.TabIndex;
            var ctrl = from control in wcICausedPostBack.Parent.Controls.OfType<WebControl>()
                       where control.TabIndex > indx
                       select control;
            ctrl.DefaultIfEmpty(wcICausedPostBack).First().Focus();
        }
    }

    protected Control GetControlThatCausedPostBack(Page page)
    {
        Control control = null;

        string ctrlname = page.Request.Params.Get("__EVENTTARGET");
        if (ctrlname != null && ctrlname != string.Empty)
        {
            control = page.FindControl(ctrlname);
        }
        else
        {
            foreach (string ctl in page.Request.Form)
            {
                Control c = page.FindControl(ctl);
                if (c is System.Web.UI.WebControls.Button || c is System.Web.UI.WebControls.ImageButton)
                {
                    control = c;
                    break;
                }
            }
        }
        return control;

    }

    protected void Button1_Click(object sender, EventArgs e)
    {

    }
}