COMPLETE ASP NET TUTORIAL

Monday, August 27, 2012

Javascript Form Validation

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default6.aspx.cs" Inherits="Default6" %>
<!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 formValidator() {
            // Make quick references to our fields
            var firstname = document.getElementById('firstname');
            var addr = document.getElementById('addr');
            var zip = document.getElementById('zip');
            var state = document.getElementById('state');
            var username = document.getElementById('username');
            var email = document.getElementById('email');
            // Check each input in the order that it appears in the form!
            if (isAlphabet(firstname, "Please enter only letters for your name")) {
                if (isAlphanumeric(addr, "Numbers and Letters Only for Address")) {
                    if (isNumeric(zip, "Please enter a valid zip code")) {
                        if (madeSelection(state, "Please Choose a State")) {
                            if (lengthRestriction(username, 6, 8)) {
                                if (emailValidator(email, "Please enter a valid email address")) {
                                    return true;
                                }
                            }
                        }
                    }
                }
            }
            return false;
        }
        function notEmpty(elem, helperMsg) {
            if (elem.value.length == 0) {
                alert(helperMsg);
                elem.focus(); // set the focus to this input
                return false;
            }
            return true;
        }
        function isNumeric(elem, helperMsg) {
            var numericExpression = /^[0-9]+$/;
            if (elem.value.match(numericExpression)) {
                return true;
            } else {
                alert(helperMsg);
                elem.focus();
                return false;
            }
        }
        function isAlphabet(elem, helperMsg) {
            var alphaExp = /^[a-zA-Z]+$/;
            if (elem.value.match(alphaExp)) {
                return true;
            } else {
                alert(helperMsg);
                elem.focus();
                return false;
            }
        }
        function isAlphanumeric(elem, helperMsg) {
            var alphaExp = /^[0-9a-zA-Z]+$/;
            if (elem.value.match(alphaExp)) {
                return true;
            } else {
                alert(helperMsg);
                elem.focus();
                return false;
            }
        }
        function lengthRestriction(elem, min, max) {
            var uInput = elem.value;
            if (uInput.length >= min && uInput.length <= max) {
                return true;
            } else {
                alert("Please enter between " + min + " and " + max + " characters");
                elem.focus();
                return false;
            }
        }
        function madeSelection(elem, helperMsg) {
            if (elem.value == "Please Choose") {
                alert(helperMsg);
                elem.focus();
                return false;
            } else {
                return true;
            }
        }
        function emailValidator(elem, helperMsg) {
            var emailExp = /^[\w\-\.\+]+\@[a-zA-Z0-9\.\-]+\.[a-zA-z0-9]{2,4}$/;
            if (elem.value.match(emailExp)) {
                return true;
            } else {
                alert(helperMsg);
                elem.focus();
                return false;
            }
        }
    </script>
</head>
<body onsubmit='return formValidator()'>
    <form id="form1" runat="server">
    <table border="0">
        <tr>
            <td>
                First Name:
            </td>
            <td>
                <input type='text' id='firstname' />
            </td>
        </tr>
        <tr>
            <td>
                Address:
            </td>
            <td>
                <input type='text' id='addr' />
            </td>
        </tr>
        <tr>
            <td>
                Zip Code:
            </td>
            <td>
                
                <input type='text' id='zip' />
            </td>
        </tr>
        <tr>
            <td>
                State:
            </td>
            <td>
                <select id='state'>
                    <option>Please Choose</option>
                    <option>AL</option>
                    <option>CA</option>
                    <option>TX</option>
                    <option>WI</option>
                </select>
            </td>
        </tr>
        <tr>
            <td>
                Username(6-8 characters):
            </td>
            <td>
                <input type='text' id='username' />
            </td>
        </tr>
        <tr>
            <td>
                Email:
            </td>
            <td>
                <input type='text' id='email' />
            </td>
        </tr>
        <tr>
            <td>
                <input type='submit' value='Check Form' />
            </td>
        </tr>
    </table>
    </form>
</body>
</html>


Output:

Monday, August 13, 2012

SQL Write CASE STATEMENT IN WHERE CONDITION

Write CASE STATEMENT IN WHERE CONDITION
--------------------------------------------
create table Billings (
     BankerID           INTEGER,
     BillingNumber      INTEGER,
     BillingDate        datetime,
     BillingTotal       INTEGER,
    TermsID            INTEGER,
     BillingDueDate     datetime ,
    PaymentTotal       INTEGER,
     CreditTotal        INTEGER
 );
 GO
 
 INSERT INTO Billings VALUES (1, 1, '2005-01-22', 165, 1,'2005-04-22',123,321);
 INSERT INTO Billings VALUES (2, 2, '2001-02-21', 165, 1,'2002-02-22',123,321);
 INSERT INTO Billings VALUES (3, 3, '2003-05-02', 165, 1,'2005-04-12',123,321);
 INSERT INTO Billings VALUES (4, 4, '1999-03-12', 165, 1,'2005-04-18',123,321);
 INSERT INTO Billings VALUES (5, 5, '2000-04-23', 165, 1,'2005-04-17',123,321);
 INSERT INTO Billings VALUES (6, 6, '2001-06-14', 165, 1,'2005-04-18',123,321);
 INSERT INTO Billings VALUES (7, 7, '2002-07-15', 165, 1,'2005-04-19',123,321);
 INSERT INTO Billings VALUES (8, 8, '2003-08-16', 165, 1,'2005-04-20',123,321);
 INSERT INTO Billings VALUES (9, 9, '2004-09-17', 165, 1,'2005-04-21',123,321);
 INSERT INTO Billings VALUES (0, 0, '2005-10-18', 165, 1,'2005-04-22',123,321);
 
DECLARE @BANKERID varchar(100)
Set @BANKERID = 'test'
SELECT BankerID,BillingNumber, BankerID * (SELECT COUNT(BankerID) FROM Billings) 
FROM Billings
WHERE     
BANKERID = CASE(@BANKERID)
  WHEN 'test' THEN 1
 -- WHEN 2 THEN 2
 END 
AND BillingNumber = 2
------------------------------------------------------------------------------------------------------
DECLARE @BANKERID varchar(100)
Set @BANKERID = 'test'
SELECT BankerID,BillingNumber, BankerID * (SELECT COUNT(BankerID) FROM Billings) 
FROM Billings
WHERE    
 BillingNumber = 2 AND
 
 @BANKERID =
CASE @BANKERID
  WHEN 'test' THEN 'test'
 -- WHEN 2 THEN 2
 END 
 
 
 --------------------------------------------------------------------------------------------------------
 
 DECLARE @BANKERID varchar(100)
Set @BANKERID = 'test'
SELECT @BANKERID,BankerID,BillingNumber, BankerID * (SELECT COUNT(BankerID) FROM Billings) 
FROM Billings
WHERE    
 BillingNumber = 2 AND
 
 @BANKERID =
CASE @BANKERID
  WHEN 'test' THEN 'test'
 -- WHEN 2 THEN 2
 END

Export to CSV File

Code Snippet
 <%@ Page Language="C#" %>
 
<!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>
    <title>Export To CSV</title>
<script runat="server">
    public static void ExportCSV(System.Data.DataTable data, string fileName)
    {
        try
        {
            HttpContext context = HttpContext.Current;
 
            context.Response.Clear();
            context.Response.ContentType = "text/csv";
            context.Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName + ".csv");
 
            //rite column header names
            for (int i = 0; i < data.Columns.Count; i++)
            {
                if (i > 0)
                {
                    context.Response.Write(",");
                }
                context.Response.Write(data.Columns[i].ColumnName);
            }
            context.Response.Write(Environment.NewLine);
            //Write data
            foreach (System.Data.DataRow row in data.Rows)
            {
                for (int i = 0; i < data.Columns.Count; i++)
                {
                    if (i > 0)
                    {
                        context.Response.Write(",");
                    }
                    context.Response.Write(row[i].ToString());
                }
                context.Response.Write(Environment.NewLine);
            }
            context.Response.End();
        }
        catch (Exception ex)
        {
 
        }
 
    }
    
    
     private System.Data.DataTable CreateDataTable()
    {
        System.Data.DataTable dataTable = new System.Data.DataTable("Employee");
 
        dataTable.Columns.Add(new System.Data.DataColumn("ID", typeof(int)));
        dataTable.Columns.Add(new System.Data.DataColumn("Name", typeof(string)));
        dataTable.Columns.Add(new System.Data.DataColumn("Address", typeof(string)));
 
        System.Data.DataRow dataRow;
 
        dataRow = dataTable.NewRow();
        dataRow["ID"] = "1";
        dataRow["Name"] = "sandeep";
        dataRow["Address"] = "Ncode";
        dataTable.Rows.Add(dataRow);
 
        return dataTable;
    }
 
     protected void btnExportDataTableToCSV_Click(object sender, EventArgs e)
     {
         ExportCSV(CreateDataTable(), "FileName");
     }
 
</script>
 
</head>
<body>
 
    <h3>FileUpload.SaveAs Method Example</h3>
 
    <form id="Form1" runat="server">
 
       <asp:Button ID="btnExportDataTableToCSV" runat="server" OnClick="btnExportDataTableToCSV_Click" Text="Export DataTable to CSV" />
 
    </form>
 
</body>
</html>
 

Ajax Editor Validation

Code Snippet
 <%@ 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>
 

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>

Pages

COMPLETE ASP NET TUTORIAL

Monday, August 27, 2012

Javascript Form Validation

Monday, August 13, 2012

SQL Write CASE STATEMENT IN WHERE CONDITION

Export to CSV File

Ajax Editor Validation

Ajax Editor Validation

Blogger templates

Blogger news

Blogroll

Blog Archive

Labels