-->

Tuesday, August 6, 2013

How to use caching in ASP.NET

Top related article


Introduction
Caching as the name suggest, is used to store data temporarily either on a Web server or on the client-side. Caching is useful in situation where several programs continually access the same set of data. This data can be easily stored in a cache and used in future. Accessing a database in an ASP.NET page is generally a slow and time-consuming process that involves connecting to the database and retrieving data from it. Caching is the best way to improve the performance of your Web application since it allows you to access data from the cache itself, which is quicker than if you were to retrieve the data from the database on each request. Therefore, caching not only reduces the processing time of a Web application, but also reduces network traffic; thereby improving the performance of your Web application and enhancing user experience.

Example of caching using output caching 


<%@ Page Language="C#" %>
<%@ OutputCache Duration ="10" VaryByParam ="none" %>
<!DOCTYPE html>
<script runat="server">
    protected void Page_Load(object sender, EventArgs e)
    {
        Label2.Text = DateTime.Now.ToString();
    }
</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>  
        <asp:Label ID="Label1" runat="server" Text="The below displayed time was cached for 10 seconds keep refreshing the page to see the changes"></asp:Label>
        </div>
        <asp:Label ID="Label2" runat="server" Text=""></asp:Label>
    </form>
</body>
</html>
Output
How to use caching in ASP.NET

Here in this example time label will changed after 10 second.

VaryByParam Attribute 
The VaryByParam attribute is used to cache different copies of a Web page when it is generated dynamically, based on the parameters received in the form of HTTP POST or HTTP GET.




LinkLabel control in windows forms C#

Label control is used to display the text such as Name, address, title and so on. The text shown through Label control cannot be edited directly by the user. Most often this control is used for providing information of another control in the windows form.

LinkLabel control is, derived from the label control, used to display text as a link. Link may be of a windows form or a website depending on the requirements. It has all the properties of Label control as well as its own properties. The commonly used properties of LinkLabel control are:

  • ActiveLinkColor: used to get or set the color used to display the active link. It is of type Color.
    linkLabel1.ActiveLinkColor = Color.Blue; This code sets the color to blue of an active link in C#.
  • DisabledLinkColor: used to get or set the color used to display the disabled link. It is also of type Color. linkLabel1.DisabledLinkColor = Color.Blue; This code sets the color to blue of an disabled link in C#.
  • LinkColor: used to get or set the color of the text on the LinkLabel control. It is also of type Color. linkLable1.LinkColor = Color.Blue; This code sets the color of the text to blue in C#.
  • LinkVisited: used to get or set a value indicating whether a link should be displayed as though it were visited. It is of type Boolean and default value is false.

LinkClicked event occurs when the link is clicked by the user. This event has an event argument of LinkLabelLinkClickedEventArgs which returns the link that was clicked by the user. The structure of this event is as follows in C#:

private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
}

Writing the following code in this event will show a new form

Form2 frm = new Form2();
frm.Show();

To create a link to a website, we should use following code:

System.Diagnostics.Process.Start(“http://dotprogramming.blogspot.in”);

In the above code the method Start() starts the default browser with the given URL.

Monday, August 5, 2013

Basics about XAML in context of WPF Application

XAML, stands for eXtensible Application Markup Language, is a declarative XML based language used for initializing structured values and objects. In the context of WPF, XAML is used to describe visual user interface. The GUI created in XAML can be expressed using any .NET language like C# or VB.

As this is simply based on XML, programmers are able to share and edit content amongst themselves without compilation. Whenever you will create a page or a window in WPF, it will create a XAML document and a code behind file, which together creates the page or window.

Here is the basic XAML code for creating a textblock in Grid element.
<Grid>
        <TextBlock Text="My First WPF Application" FontSize="30" HorizontalAlignment="Center" VerticalAlignment="Center"></TextBlock>
</Grid>
In the above code use <TextBlock> element to identify the TextBlock control. The FontSize property is used to get or set the font size of the content of the element. Here font size of the text block is 30 pixels.

Horizontal alignment property is used to get or set the horizontal alignment of this element when it is within a parent element like a panel etc. The horizontal alignment may be center, left, right and stretch according to programmer’s requirement. The default value is Stretch.

Vertical alignment property is same as horizontal property. It is also may have four values i.e. center, left, right and stretch programmer’s requirement. The default value is Stretch.

We can also use the above properties like the following code:
<TextBlock Text="My First WPF Application">
<TextBlock.FontSize>30</TextBlock.FontSize>
<TextBlock.HorizontalAlignment>Center</TextBlock.HorizontalAlignment>
<TextBlock.VerticalAlignment>Center</TextBlock.VerticalAlignment>
</TextBlock>
The window will be look like the following screenshot:

Basic about XAML in WPF application

Both type of syntaxes are same. There are many more properties for each elements which will use as per the requirements.

Sunday, August 4, 2013

How to use menu control in ASP.NET

About menu control

The Menu control is another navigation control, which is also used to display site navigation information . The Menu control can however , displays the site structure vertically as well as horizontally. It can be used as a databound  control , for example , binding the menu control with a SiteMapDataSource control. It can also retrieve the data to be displayed from the items that are added to the Item collection of the Menu control at runtime. The Menu control supports binding data with hierarchical datasource, such as XML files. You can also add the database items to the Menu control at runtime using the Item collection of the Menu control . The Menu control consists of one or more MenuItems properties displayed at different levels of hierarchy. Each MenuItem, in turn, consists of properties to set the style of the individual MenuItem. The menu control contains two types of menus:

  • Static menu -- This type of menu is displayed completely with all the menu options on the screen. The entire structure of the static menu, including the parent menu items and their sub menus, is visible.
  • Dynamic menu -- This type of menu contains static part which is displayed on the screen as well as the dynamic part which appears when user passes the mouse pointer over the static part of the menu.

Example

first take a "sitemap" file for binding menu control. Right click on your application name in solution explorer and select Web.sitemap file.
Sitemap file for menu control

A sitemap is a xml file which include different siteMapNode.


<?xml version="1.0" encoding="utf-8" ?>
<siteMap xmlns="http://schemas.microsoft.com/AspNet/SiteMap-File-1.0" >
    <siteMapNode url="http://dotprogramming.blogspot.in" title="Programing"  description="Its world best programming site">
        <siteMapNode url="http://www.google.com" title="Google"  description="" />
        <siteMapNode url="http://www.msn.com" title="microsoft"  description="" />
    <siteMapNode url ="http://pc-gadgetworld.blogspot.in" title ="pc-gadget" description ="" >
     <siteMapNode title ="left child"  />
      <siteMapNode title ="right child " />

    </siteMapNode>
    </siteMapNode>
</siteMap>
Diagrammatic view of sitemap file
How to use menu control in ASP.NET

Binding Menu with Sitemap file
<%@ Page Language="C#" %>
<!DOCTYPE html>
<script runat="server">
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
   
        <asp:Menu ID="Menu1" runat="server" DataSourceID="SiteMapDataSource1" Orientation="Horizontal" StaticDisplayLevels="2">
        </asp:Menu>
        <asp:SiteMapDataSource ID="SiteMapDataSource1" runat="server" />  
    </div>
    </form>
</body>
</html>

Friday, August 2, 2013

How to change back color of the gridview column in ASP.NET

Step-1 : Bind GridView using SqlDataSource in ASP.NET.
Step-2 : Select Edit column link using show smart tag.

How to change back color of the gridview column  in ASP.NET

Step-3 : Select fields in left pane.
How to change back color of the gridview column  in ASP.NET

Step-4 : Select itemStyle in Style tab in right pane
How to change back color of the gridview column  in ASP.NET

Step-5 : Change back color of the column using back color property.
How to change back color of the gridview column  in ASP.NET





Wednesday, July 31, 2013

How to get cell value from gridview in asp.net

Computer Programming : GridView, combination of rows and columns. Single row contains one or more then one cells. If you want to get cell value from GridView, select Gridview row first. After that you can get cell value/Text from selected rows.

Step-1 : Bind GridView using SqlDataSource in ASP.NET
Step-2 : Drag and drop one label control onto design window
Step-3 : Select "Enable Selection" using show smart tag.


How to get cell value from gridview in asp.net



Step-4 : Double click on Gridview and handle SelectedIndexChanged event

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {

    }


Step-6 : Write code for getting value from gridview cell

 protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {
        Label1 .Text =GridView1 .SelectedRow .Cells [2].Text ;
    }
Output
How to get cell value from gridview in asp.net

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

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
 
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="Id" DataSourceID="SqlDataSource2" OnSelectedIndexChanged="GridView1_SelectedIndexChanged">
            <Columns>
                <asp:CommandField ShowSelectButton="True" />
                <asp:BoundField DataField="Id" HeaderText="Id" InsertVisible="False" ReadOnly="True" SortExpression="Id" />
                <asp:BoundField DataField="name1" HeaderText="name1" SortExpression="name1" />
                <asp:BoundField DataField="Record_detail " HeaderText="Record_detail " SortExpression="Record_detail " />
                <asp:BoundField DataField="photo" HeaderText="photo" SortExpression="photo" />
                <asp:BoundField DataField="Address" HeaderText="Address" SortExpression="Address" />
                <asp:BoundField DataField="DOB" HeaderText="DOB" SortExpression="DOB" />
                <asp:BoundField DataField="Date" HeaderText="Date" SortExpression="Date" />
                <asp:BoundField DataField="Nomination" HeaderText="Nomination" SortExpression="Nomination" />
                <asp:BoundField DataField="present_time" HeaderText="present_time" SortExpression="present_time" />
                <asp:BoundField DataField="charge" HeaderText="charge" SortExpression="charge" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT * FROM [crimefile]"></asp:SqlDataSource>
         
    </div>
        <asp:Label ID="Label1" runat="server"></asp:Label>
    </form>
</body>
</html>

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

public partial class sqldatabindgrid : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {
        Label1 .Text =GridView1 .SelectedRow .Cells [2].Text ;
    }
}

Tuesday, July 30, 2013

How to bind GridView using SqlDataSource in ASP.NET

Step-1 : First design database table in visual studio
Step-2 : Drag and drop GridView control from ToolBox to Design window
Step-3 : Select Choose data source by show smart tag.

choose data source from show smart tag

Step-4 : Select SQL Database in Data Source Configuration wizard.
data source configuration wizard in asp.net

Step-5 : Select your database by dropdownlist in "Choose your data connection" wizard 
your connection string will appeared.

Choose your data connection

Step-6 : Select Table or Column name using "Configure the select statement"  wizard.
Configure the select statement

Step-7: Press Test Query button
Test your query window

Step-8: Run your Application
Bind gridview
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="sqldatabindgrid.aspx.cs" Inherits="sqldatabindgrid" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
 
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="Id" DataSourceID="SqlDataSource2">
            <Columns>
                <asp:BoundField DataField="Id" HeaderText="Id" InsertVisible="False" ReadOnly="True" SortExpression="Id" />
                <asp:BoundField DataField="name1" HeaderText="name1" SortExpression="name1" />
                <asp:BoundField DataField="Record_detail " HeaderText="Record_detail " SortExpression="Record_detail " />
                <asp:BoundField DataField="photo" HeaderText="photo" SortExpression="photo" />
                <asp:BoundField DataField="Address" HeaderText="Address" SortExpression="Address" />
                <asp:BoundField DataField="DOB" HeaderText="DOB" SortExpression="DOB" />
                <asp:BoundField DataField="Date" HeaderText="Date" SortExpression="Date" />
                <asp:BoundField DataField="Nomination" HeaderText="Nomination" SortExpression="Nomination" />
                <asp:BoundField DataField="present_time" HeaderText="present_time" SortExpression="present_time" />
                <asp:BoundField DataField="charge" HeaderText="charge" SortExpression="charge" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT * FROM [crimefile]"></asp:SqlDataSource>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT * FROM [crimefile]"></asp:SqlDataSource>
 
    </div>
    </form>
</body>
</html>

© Copyright 2013 Computer Programming | All Right Reserved