Asp.Net Theme Example

  Apply theme is a beautiful concept in Asp.Net. We can set properties of a specific control and save it in skin file. Then all control of that type the properties fixed means if we set properties for a Gridview in skin file then all Gridview control all over the project will be same properties and same look.

 Steps-1 :-

   Right Click on website -> Add New Item -> SkinFile.skin

  Add the GridView properties there

  

<asp:GridView runat="server"   HeaderStyle-BackColor="#5D7B9D"

    HeaderStyle-ForeColor="White" AllowPaging="True" Font-Size="11px" HeaderStyle-Font-Size="11px"

    AllowSorting="True" CellPadding="4" ForeColor="#333333"

     GridLines="None" EmptyDataText="No record found." ShowFooter="True" >

    <AlternatingRowStyle BackColor="White" />

    <EmptyDataRowStyle  Font-Bold="true" Width="100%" HorizontalAlign="Center"/>

    <EditRowStyle BackColor="#2461BF" />

    <HeaderStyle Height="22px" BackColor="#18677C" ForeColor="White" Font-Bold="True" />

    <PagerStyle ForeColor="Gray" HorizontalAlign="Center" />

    <RowStyle BackColor="#EFF3FB" />

    <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />

    <SortedAscendingCellStyle BackColor="#F5F7FB" />

    <SortedAscendingHeaderStyle BackColor="#6D95E1" />

    <SortedDescendingCellStyle BackColor="#E9EBEF" />

    <SortedDescendingHeaderStyle BackColor="#4870BE" />

</asp:GridView>

 Steps-2 :-

  Open Web.Config file and set this code for Page tag within <System.Web>

 

<system.web>

    <pages theme="SkinFile"   ></pages>

  </system.web>

  

Then every GridView across project will be same.

 

Gridview Column Sorting in Asp.net

  Sometimes we need to sort the values display in Gridview columns. Normally data display in Gridview either in ascending or descending depending on the Sql query as per the requirement. Asp.net Gridview has a feature to sort the value when necessary





Source Code :-

<asp:GridView ID="GvRecords" runat="server" Width="100%"

        AutoGenerateColumns="False" onsorting="GvRecords_Sorting"

        AllowSorting="True">

        <Columns>

            <asp:TemplateField HeaderText="ID" SortExpression="ledgerId" >

              <HeaderStyle Font-Underline="true" />

                <ItemTemplate>

                    <asp:Label ID="LblId" runat="server" Text='<%# Eval("ledgerid") %>' CommandArgument='<%# Eval("ledgerid") %>'></asp:Label>

                </ItemTemplate>

            </asp:TemplateField>

            <asp:TemplateField HeaderText="Name" SortExpression="Ledgername">

             <HeaderStyle Font-Underline="true" />

                <ItemTemplate>

                    <asp:Label ID="Lblname" runat="server" Text='<%# Eval("ledgername") %>' CommandArgument='<%# Eval("ledgername") %>'></asp:Label>

                </ItemTemplate>

            </asp:TemplateField>

        </Columns>

    </asp:GridView>

C# Code :-

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.SqlClient;

using System.Data;

using System.Configuration;

public partial class GridViewShorting : System.Web.UI.Page

{

    SqlConnection con;

    SqlCommand cmd;

    SqlDataReader dr;

    SqlDataAdapter da;

    DataSet ds;

    protected void Page_Load(object sender, EventArgs e)

    {

        con = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConnection"].ConnectionString);

// define the connection string in web config file.

        SelectData();   

    }

    private void SelectData()

    {

        try

        {     

            da = new SqlDataAdapter("select ledgerid,ledgername  from ledgers order by ledgername ", con);          

            ds = new DataSet();

            da.Fill(ds);

            GvRecords.DataSource = ds.Tables[0];

            GvRecords.DataBind();

        }

        catch (Exception ex)

        {

          

        }

      

    }

    protected void GvRecords_Sorting(object sender, GridViewSortEventArgs e)

    {

        try

        {

            string sortingDirection = string.Empty;

            if (dir == SortDirection.Ascending)

            {

                dir = SortDirection.Descending;

                sortingDirection = "Desc";

            }

            else

            {

                dir = SortDirection.Ascending;

                sortingDirection = "Asc";

            }

            DataView sortedView = new DataView(GetAllRecordDataTable());

            sortedView.Sort = e.SortExpression + " " + sortingDirection;

            GvRecords.DataSource = sortedView;

            GvRecords.DataBind();

           // SelectData();

        }

        catch (Exception) { }

    }

    public SortDirection dir

    {

        get

        {

            if (ViewState["dirState"] == null)

            {

                ViewState["dirState"] = SortDirection.Ascending;

            }

            return (SortDirection)ViewState["dirState"];

        }

        set

        {

            ViewState["dirState"] = value;

        }

    }

    public DataTable GetAllRecordDataTable()

    {

        da = new SqlDataAdapter("select ledgerid,ledgername  from ledgers order by ledgername  ", con);

        ds = new DataSet();

        da.Fill(ds);      

        DataTable dtGrid = ds.Tables[0];

        return dtGrid;

    }

}

Declare Connection in Web.Config file :-

<connectionStrings>

    <add name="DBConnection" connectionString="server=myDBS;database=accounts;uid=sa;pwd=raj" providerName="System.Data.SqlClient"/>

   

  </connectionStrings>