Nov 2, 2013

Avoid submit event Refresh in Asp.net

'Declare variables for use
    Private _refreshState As Boolean
    Private _isRefresh As Boolean


'Functions to Use
#Region " ISREFRESH "
    Protected Overrides Sub LoadViewState(ByVal savedState As Object)
        Dim AllStates As Object() = savedState
        MyBase.LoadViewState(AllStates(0))
        _refreshState = Boolean.Parse(AllStates(1))
        _isRefresh = _refreshState = Session("__ISREFRESH")
    End Sub

    Protected Overrides Function SaveViewState() As Object
        Session("__ISREFRESH") = _refreshState
        Dim AllStates() As Object = New Object(2) {}
        AllStates(0) = MyBase.SaveViewState
        AllStates(1) = Not (_refreshState)
        Return AllStates
    End Function
#End Region

'Call function in Button Click Event
Protected Sub btnLogin_Click(ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles btnLogin.Click

      If _isRefresh = True Then
            Exit Sub
      End If

End Sub
By No comments:

Aug 19, 2013

How to Save and Retrieve File in SQL Server Table

1.)  Design

Save and Retrieve File in SQL Table :
Select File To Upload :
File ID to Download :

2.) Table
  
ID
FileName
Extension
Content
1
ShowMIS_BODRptS
.PDF
<Binary data>
2
a.xls
.xls
<Binary data>
3
test.txt
.txt
<Binary data>
4
test.sql
.sql
<Binary data>
5
ShowMIS_BODRptS
.pdf
<Binary data>


Read more »
By No comments:

Jun 19, 2013

LINQ to SQL: Basic Concepts and Features


By : ,


In this article we will see how to use LINQ to interact with a SQL Server database, or in other words, how to use LINQ to SQL in C#.
In this article, we will cover the basic concepts and features of LINQ to SQL, which include:
  • What is ORM
  • What is LINQ to SQL
  • What is LINQ to Entities
  • Comparing LINQ to SQL with LINQ to Objects and LINQ to Entities
  • Modeling the Northwind database in LINQ to SQL
  • Querying and updating a database with a table
  • Deferred execution
  • Lazy loading and eager loading
  • Joining two tables
  • Querying with a view
Use above (Ref) link to to read article.
By No comments:

Jun 11, 2013

All Browser Supporting Tag for Asp.net Website

Below code paste in Head section of the Page

<head id="Head1" runat="server">
    <title>:: My Home ::</title>
      <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1" />
      <meta content="blendTrans(Duration=0.50)" http-equiv="Page-Exit" />
      <meta http-equiv="Page-Enter" content="blendTrans(Duration=0.50)" />
</head>

Add Below code in File (VB) of Page


    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        If Request.UserAgent.IndexOf("AppleWebKit") > 0 Then
            Request.Browser.Adapters.Clear()
        End If
    End Sub

    Protected Overrides Sub AddedControl(ByVal control As Control, ByVal index As Integer)
        ' This is necessary because Safari and Chrome browsers don't display the Menu control correctly.
        ' Add this to the code in your master page.
        If Request.ServerVariables("http_user_agent").IndexOf("Safari", StringComparison.CurrentCultureIgnoreCase) <> -1 Then
            Me.Page.ClientTarget = "uplevel"
        End If

        MyBase.AddedControl(control, index)
    End Sub

By No comments:

May 30, 2013

JSON Tutorial

JSON Tutorial


JSON or JavaScript Object Notation, is a text-based open standard designed for human-readable data interchange. It is derived from the JavaScript scripting language for representing simple data structures and associative arrays, called objects. Despite its relationship to JavaScript, it is language-independent, with parsers available for many languages. The JSON format is often used for serializing and transmitting structured data over a network connection. It is used primarily to transmit data between a server and web application, serving as an alternative to XML.

Example: How to send JSON data to Web method  i.e. ‘GetData’
1) create New website in visual studio

2) Write Below code In java script as function
    function SendData() {
       
         var jsonObjects = {
        "items": [
            {
                "compId": "1","formId": "531"
            },
            {
                "compId": "5","formId": "77"
            },
            {
                "compId": "8","formId": "89"
            }
        ]
        };
       
        $.ajax({
            url: "Default.aspx/GetData",
            data: JSON.stringify(jsonObjects),
            dataType: "json",
            type: "POST",
            contentType: "application/json; charset=utf-8",
            dataFilter: function(data) { return data; },
            success: function(data) {
                alert(data.d);
            },
            error: function(XMLHttpRequest, textStatus, errorThrown) {
                alert(XMLHttpRequest.responseText);
            }
        });
    }

3) Now add new Button to call Method and send data to serverside

<asp:Button ID="Button4" runat="server" Text="Send JSON Data in Object(s)" OnClientClick="SendData();return false;" />



4) Import this libraries

using System.Collections.Generic;
using System.Web.Script.Serialization;
using System.Web.Services;
using System.Web.Script.Services;
using System.Web.Security;

5) Use this method to accept Json data and save it to RDBMS

[WebMethod]
public static string GetData(object items)
{
     //SINGLE OBJECT SAVE DATA

     List<object> lstItems = new           JavaScriptSerializer().ConvertToType<List<object>>(items);

     //now we can Acces lstItems values
     return "Send Data successfully." ;
}
By No comments:

May 29, 2013

Calculate GridView total using JavaScript / JQuery

Here is the code, both ASPX and the JQuery code.
The ASPX

    <asp:TemplateField>   
        <ItemTemplate>    
            <asp:TextBox ID="TextBox1" class="calculate" onchange="calculate()" runat="server" Text="0"></asp:TextBox>   
        </ItemTemplate>
    </asp:TemplateField>
The code is similar as previously. Only now we have addedd class=”calculate” to the TextBox in order to perform JQuery manipulation to all the textboxes with class=”calculate” (all textboxes will have class calculate, no matter of the number of textboxes inside the gridview, which will make easier to find and manipulate with them using JQuery).
The JQuery code:
    <script src="http://ajax.microsoft.com/ajax/jquery/jquery-1.4.2.min.js" type="text/javascript"></script>
    <script language="javascript" type="text/javascript">
        function calculate() {
            var txtTotal = 0.00;
            //var passed = false;
            //var id = 0;

            $(".calculate").each(function (index, value) {
                var val = value.value;
                val = val.replace(",", ".");
                txtTotal = MathRound(parseFloat(txtTotal) + parseFloat(val));
            });

            document.getElementById("<%=total.ClientID %>").value = txtTotal.toFixed(2);          
        }

        function MathRound(number) {
            return Math.round(number * 100) / 100;
        }
    </script>
Using this JQuery each function, we can easily iterate trough all html objects containing the class name calculate, which in our case are the text boxes.

That’s it.
By No comments:

Mar 30, 2013

Get Next Number with REPLICATE In SQL Server

Get Next max value for custom identification of table value


 SELECT 'PR' + Substring( '2012-2013', 3, 2 )
       + Replicate('0', 4-Len(Count(*)+1))
       + Cast(Count(*)+1 AS VARCHAR(4)) AS NewCode
FROM   tablename
WHERE  pro_finyear = '2012-2013' 


OUTPUT
=================

 NewCode 
PR120012

By No comments:

Mar 9, 2013

Jquery animation cutting Ribbon with scissors




<body>
    <form id="form1" runat="server">
        <img class="RibbonL" src="Images/LeftRibbon.png" />
        <img class="RibbonR" src="Images/RightRibbon.png" />
        <img id="imgFollow" style="position: relative;" class="imgFollow" width="145px" height="145px" src="Images/scissors.png" />
        <script src="jquery-1.6.2.min.js" type="text/javascript"></script>
        <script type="text/javascript">
            $(document).ready(function () {



                $(document).mousemove(function (e) {
                    $('#imgFollow').offset({
                        left: e.pageX + 30,
                        top: e.pageY - 20
                    });
                    $('#imgFollow').css('z-index', '1000');

                });

                $(".RibbonR, .RibbonL ").click(function () {
                    $(".RibbonL").hide(1000);
                    $(".RibbonR").hide(1000);

                    setTimeout(function () { //redirect after a certain time
                        $(window.location).attr('href', 'http://itapps.cgglobal.com/cgict/');
                    }, 1200);
                });

            });
        </script>
    </form>
</body>
By 1 comment:
Subscribe to: Posts (Atom)

What is the use of n-tier architecture and 3-tier architecture?

how to implement 3-tier architecture in asp.net using c#. 3-Tier architecture is also called layered architecture. Some people called it ...