Dot Netting

Take off from Entebbe Airport, Uganda to Dubai International Airport by ...

2020-08-03T02:05:00.001-07:00

How to send confidential email in gmail

2019-02-25T04:10:00.001-08:00

How to get lots of FOLLOWERS on Pinterest

2019-01-28T06:29:00.001-08:00

How to create a playlist on youtube channel

2019-01-01T09:31:00.001-08:00

Display Gridpanel cell tooltip in Ext.Net

2012-11-02T12:30:00.001-07:00

You often want to display tooltip using cell data when data length overflows column width in your gridpanel. You will get an example to show tooltip with gridpanel cell data here: http://examples1.ext.net/#/Miscellaneous/ToolTips/GridPanel_Cell_Tooltip/

But this is not working properly when it is included in some project especially if you have master page based design. I have tried this in my project and it worked properly with little bit changes. Here I want to share the codes with you guys:

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server">

<ext:XScript ID="XScript1" runat="server">

var showTip = function () {

var rowIndex = #{gpList}.view.findRowIndex(this.triggerElement),

cellIndex = #{gpList}.view.findCellIndex(this.triggerElement),

record = #{gpListStore}.getAt(rowIndex),

fieldName = #{gpList}.getColumnModel().getDataIndex(cellIndex),

data = record.get(fieldName);

if (data ==null){

this.body.dom.innerHTML = "";

}

else{

this.body.dom.innerHTML = data;

};

</script>

</ext:XScript>

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">

<ext:ResourceManager ID="rcm" runat="server">

</ext:ResourceManager>

<ext:Hidden ID="hfPK" runat="server">

</ext:Hidden>

<ext:TabPanel ID="tPnlMain" runat="server" ActiveTabIndex="0" AnchorHorizontal="100%"

Height="500" Plain="true" Visible="true" Width="1024">

<Items>

<ext:Panel ID="Tab2" runat="server" Title="Employee Search" Padding="1" AutoScroll="true">

<Items>

<ext:RowLayout runat="server">

<Rows>

<ext:LayoutRow RowHeight=".25">

<ext:Panel ID="Panel1" runat="server" Header="false" Padding="1" AutoScroll="true">

<Items>

</Items>

</ext:Panel>

</ext:LayoutRow>

<ext:LayoutRow RowHeight=".75">

<ext:Panel ID="Panel3" runat="server" Title="Employee List" Padding="1" AutoScroll="true">

<Items>

<ext:GridPanel ID="gpList" runat="server" StripeRows="true" AutoExpandColumn="EmployeeName"

Collapsible="true" AnchorHorizontal="100%" Height="322" TrackMouseOver="true">

<Store>

<ext:Store ID="gpListStore" runat="server">

<ext:JsonReader IDProperty="EmployeeId">

<ext:RecordField Name="EmployeeId" />

<ext:RecordField Name="EmployeeName" />

<ext:RecordField Name="EnrollId" />

<ext:RecordField Name="FirstName" />

<ext:RecordField Name="MiddleName" />

<ext:RecordField Name="LastName" />

<ext:RecordField Name="AddressLine1" />

<ext:RecordField Name="DepartmentId" />

<ext:RecordField Name="DesignationId" />

<ext:RecordField Name="PolicyId" />

<ext:RecordField Name="CardNumber" />

<ext:RecordField Name="DesignationName" />

<ext:RecordField Name="DeptName" />

<ext:RecordField Name="SbuName" />

</Fields>

</ext:JsonReader>

</Reader>

</ext:Store>

</Store>

<ext:RowNumbererColumn />

<ext:CommandColumn Header="Action" Width="65">

<ext:GridCommand Icon="ApplicationEdit" CommandName="Edit">

</ext:GridCommand>

</Commands>

</ext:CommandColumn>

<ext:Column ColumnID="cEnrollId" Header="Enroll Id" DataIndex="EnrollId" Width="50" />

<ext:Column ColumnID="cStaffCode" Header="Employee Code" DataIndex="StaffCode" Width="70" />

<ext:Column ColumnID="cEmployeeName" Header="EmployeeName" DataIndex="EmployeeName"

Width="130" />

<ext:Column ColumnID="cDesignationName" Header="Designation" DataIndex="DesignationName"

Width="150" />

<ext:Column ColumnID="cDepartmentName" Header="Department" DataIndex="DeptName" Width="100" />

<ext:Column ColumnID="cSbuId" Header="Branch" DataIndex="SbuName" />

<ext:Column ColumnID="cAddressLine1" Header="Address" DataIndex="AddressLine1" Width="180" />

</Columns>

</ColumnModel>

<ext:RowSelectionModel ID="RowSelectionModel1" runat="server" SingleSelect="true" />

</SelectionModel>

<ext:PagingToolbar ID="gpListPager" runat="server" PageSize="20" />

</BottomBar>

</Listeners>

<ext:ToolTip ID="RowTip" runat="server" Target="#{gpList}.getView().mainBody" Delegate=".x-grid3-cell" ShowDelay="0"

TrackMouse="true">

</Listeners>

</ext:ToolTip>

</ToolTips>

</ext:GridPanel>

</Items>

</ext:Panel>

</ext:LayoutRow>

</Rows>

</ext:RowLayout>

</Items>

</ext:Panel>

</Items>

</ext:TabPanel>

</asp:Content>

Hope this will help my friends.

Gridview RowEditing or RowDeleting event fires twice problem

2010-10-24T04:01:00.000-07:00

Problem:
When working with ASP.Net Gridview control's RowEditing or RowDeleting events, it fires twice if image is used in Edit or Delete CommandField. Many ASP.Net developers face this problem while working with Gridview controls. There is many post in different forum on this problem.

Solution:
To solve this problem convert CommandField to TemplateField and add an ImageButton to show your Edit or Delete image.

Example Code:

<asp:TemplateField HeaderText="Edit">

<asp:ImageButton ID="ImageButton1" runat="server" CausesValidation="False" CommandName="Edit" ImageUrl="~/Image/admin/edit.gif" Text="Edit" />

ItemTemplate>

asp:TemplateField>

Thanks.

Introduction to Balanced Scorecard(BSC)

2010-09-07T21:54:00.000-07:00

The balanced scorecard (BSC) is a strategic planning and performance management tool. It was originated by Drs. Robert Kaplan (Harvard Business School) and David Norton as a performance measurement framework. This added strategic non-financial performance measures to traditional financial metrics to give managers and executives a more 'balanced' view of organizational performance.

The balanced scorecard has evolved from its early use as a simple performance measurement framework to a full strategic planning and management system. It provides a framework that not only provides performance measurements, but helps planners identify what should be done and measured. It enables executives to truly execute their strategies.

It is extensively used in business and industry, government, and nonprofit organizations worldwide to align business activities. It improves internal and external communications, and monitor organization performance against strategic goals.

It is perhaps the best known of several such frameworks. It was widely adopted in English speaking western countries and Scandinavia in the early 1990s.

Perspectives

The four "perspectives" proposed were:

Financial: encourages the identification of a few relevant high-level financial measures. Timely and accurate funding data will always be a priority, and managers will do whatever necessary to provide it. In fact, often there is more than enough handling and processing of financial data. With the implementation of a corporate database, it is hoped that more of the processing can be centralized and automated.

Customer: Recent management philosophy has shown an increasing realization of the importance of customer focus and customer satisfaction in any business. These are leading indicators: if customers are not satisfied, they will eventually find other suppliers that will meet their needs.

Internal Business Processes: This perspective refers to internal business processes. Metrics based on this perspective allow the managers to know how well their business is running, and whether its products and services conform to customer requirements (the mission).

Learning and Growth: This perspective includes employee training and corporate cultural attitudes related to both individual and corporate self-improvement. In a knowledge-worker organization, people -- the only repository of knowledge -- are the main resource. In the current climate of rapid technological change, it is becoming necessary for knowledge workers to be in a continuous learning mode.


Balance Scorecard

Creating client script dynamically

2010-07-26T21:20:00.000-07:00

In many cases, you can create the client script for your page declaratively, usually as a script block. However, you can also create client script dynamically. This is useful if the script depends on information that is available only at run time. For example, you might insert client script into a page that addresses a server control whose name (ID) is not known until the application runs, or you might create script that depends on values that you get from a user.

You can create and insert client script dynamically into a rendered page by calling methods of the ClientScriptManager class, such as the following:

· RegisterClientScriptBlock, which inserts a script block at the top of the rendered page.

· RegisterStartupScript, which inserts a script block at the end of the rendered page.

The following example shows how to add dynamically generated client script to the page. The code checks whether a check box named checkDisplayCount is selected. If so, the code performs the following tasks:

· It creates a client script function that uses a span element to display the character count in a TextBox control named TextBox1.

· It adds a client event to the TextBox control.

· It generates the span element.

The code assumes that the page contains a check box named checkDisplayCount whose AutoPostBack property is set to true and a PlaceHolder control named PlaceHolder1.

void Page_Load(object sender, EventArgs e)

    if(checkDisplayCount.Checked)

        String scriptText = "";

        scriptText += "function DisplayCharCount(){";

        scriptText += "   spanCounter.innerText = " +

            " document.forms[0].TextBox1.value.length";

        scriptText += "}";

        ClientScriptManager.RegisterClientScriptBlock(this.GetType(),

           "CounterScript", scriptText, true);

        TextBox1.Attributes.Add("onkeyup", "DisplayCharCount()");

        LiteralControl spanLiteral = new

            LiteralControl("spanCounter\">");

        PlaceHolder1.Controls.Add(spanLiteral);

ASP.Net State management

2010-06-21T03:56:00.000-07:00

What is State Management?

State management is the process by which you maintain state and page information over multiple requests for the same or different pages.

ASP.NET includes several options that help you preserve data on both a per-page basis and an application-wide basis.

Types of State Management

There are two basic types of State Management:

1. Client-Based State Management

2. Server-Based State Management

Client-Based State Management:

Client based state management techniques stores data on the client in various ways. Client based state management techniques are:

A. View state

B. Control state

C. Hidden fields

D. Cookies

E. Query strings

View state:

The view state represents the state of the page when it was last processed on the server. It's used to build a call context and retain values across two successive requests for the same page. By default, the state is persisted on the client using a hidden field added to the page and is restored on the server before the page request is processed.

If the amount of data stored in the ViewState() property exceeds the specified value in the MaxPageStateFieldLength() property, multiple hidden fields are used to store View state data.

Advantages:

a) Server resources not required.

b) Simple implementation

c) automatic retention of page and control state

d) Enhanced security features. The values in view state are hashed, compressed, and encoded for Unicode implementations.

Disadvantages:

a) Scope is limited to only single page.

b) Performance. The view state is stored in the page itself, so increase the page size.

c) Security. The view state is stored in a hidden field on the page. Although view state stores data in a hashed format, it can be tampered with.

Control state:

If you create a custom control that requires view state to work properly, you should use control state to ensure your control work properly though developers disable view state. The ControlState() property allows you to persist property information that is specific to a control and cannot be turned off like the ViewState() property.

Advantages:

a) Server resources not required.

b) Reliable. Because control state can not be turned off like ViewState.

Disadvantages:

a) Some programming is required.

Hidden Fields:

A hidden field acts as a repository for any page-specific information that you want to store directly in the page. ASP.NET allows you to store information in a HiddenField control, which renders as a standard HTML hidden field. A hidden field does not render visibly in the browser.

You must submit the page using an HTTP POST command in order for hidden-field values to be available.

Advantages:

a) Server resources not required.

b) Simple implementation

c) Widespread support.

Disadvantages:

a) Potential security risk.

b) Performance. The hidden fields are stored in the page itself, so increase the page size.

c) Does not support rich data types to store.

Cookies:

A cookie is a small amount of data that is stored either in a text file on the client file system or in-memory in the client browser session. Browser sends with cookies values with every page request to the same server. Cookies can be temporary or persistent.

Advantages:

a) Server resources not required.

b) Simple implementation

c) Configurable expiration rules

d) Data persistent.

Disadvantages:

e) Size limitation: Most browsers support maximum 4096 bytes cookies.

f) User configuration refusal: User can disable cookies in their browser.

g) Security risk: Can be tempered.

Query strings:

A query string is information that is appended to the end of a page URL. Query strings provide a simple but limited way to maintain state information. Some browsers and client devices impose a 2083 character limit on the length of the URL.

You must submit the page using an HTTP POST command in order for query string values to be available.

Advantages:

h) Server resources not required.

i) Simple implementation

j) Widespread support.

Disadvantages:

k) Size limitation: Some browser limits 2083 chars on the length of URLs.

l) Security risk: Information is visible to the user.

Server-Based State Management:

Server based state management techniques store data in memory on the server. Server based state management techniques are:

A. Application state

B. Session state

C. Profile Properties

Application state:

Application state provides a method of storing data global to whole application. These data are visible to entire application and shared by all active sessions. That’s why Application state variables are global variables for an ASP.Net application.

Advantages:

m) Simple implementation

n) Application wide scope

Disadvantages:

o) Application scope in case of Web Garden or Web Firm.

p) Limited Durability of data.

q) Requires server memory.

Session state:

Session state provides a method of storing session specific information that is visible only within the session.

Advantages:

r) Simple implementation

s) Session specific events

t) Data can persists across multiple process

Disadvantages:

u) Application scope

v) Limited Durability of data.

w) Requires server memory.

T-SQL Dynamic Paged Query Techniques

2010-06-13T05:43:00.000-07:00

Here we will see how to write dynamic paged query using Derived Table and CTE.

Simple paging query using Derived Table:

CREATE PROCEDURE [dbo].[HrEmployee_GetPaged]

BEGIN

SET NOCOUNT ON

SET TRANSACTION ISOLATION LEVEL READ COMMITTED

select * from

( select row_number() over(order by EmployeeId) as Row,* from HrEmployee ) as e

where e.Row between 21 and 30
END

Dynamic paging query using Derived Table:

CREATE PROCEDURE [dbo].[HrEmployee_GetPaged]

@StartRowIndex int,

@RowPerPage int,

@WhereClause nvarchar(4000),

@SortColumn nvarchar(128),

@SortOrder nvarchar(4)

BEGIN

SET NOCOUNT ON

SET TRANSACTION ISOLATION LEVEL READ COMMITTED

SET @StartRowIndex = isnull(@StartRowIndex, -1)

SET @RowPerPage = isnull(@RowPerPage, -1)

SET @WhereClause = isnull(@WhereClause, '')

SET @SortColumn = isnull(@SortColumn, '')

SET @SortOrder = isnull(@SortOrder, '')

DECLARE @SQL nvarchar(4000)

IF (@WhereClause != '')

BEGIN

SET @WhereClause = 'WHERE ' + char(13) + @WhereClause

END

IF (@SortColumn != '')

BEGIN

SET @SortColumn = 'ORDER BY ' + @SortColumn

IF (@SortOrder != '')

BEGIN

SET @SortColumn = @SortColumn + ' ' + @SortOrder

END

SET @SQL = 'SELECT * FROM (SELECT *,

ROW_NUMBER() OVER ('+ @SortColumn +')AS Row

FROM [HrEmployee]

'+ @WhereClause +'

) as E

WHERE E.Row between '+ CONVERT(nvarchar(10), @StartRowIndex) +' And ('+ CONVERT(nvarchar(10), @StartRowIndex+ @RowPerPage-1) +')'

-- print @SQL

EXEC sp_executesql @SQL

END

Simple paging query using CTE:

CREATE PROCEDURE [dbo].[HrEmployee_GetPaged]

BEGIN

SET NOCOUNT ON

SET TRANSACTION ISOLATION LEVEL READ COMMITTED

WITH e AS (select row_number() over(order by EmployeeId) as Row,* from HrEmployee )

select * from e where e.Row between 21 and 30
END

Dynamic paging query using CTE:

CREATE PROCEDURE [dbo].[HrEmployee_GetPaged]

@StartRowIndex int,

@RowPerPage int,

@WhereClause nvarchar(4000),

@SortColumn nvarchar(128),

@SortOrder nvarchar(4)

BEGIN

SET NOCOUNT ON

SET TRANSACTION ISOLATION LEVEL READ COMMITTED

SET @StartRowIndex = isnull(@StartRowIndex, -1)

SET @RowPerPage = isnull(@RowPerPage, -1)

SET @WhereClause = isnull(@WhereClause, '')

SET @SortColumn = isnull(@SortColumn, '')

SET @SortOrder = isnull(@SortOrder, '')

DECLARE @SQL nvarchar(4000)

IF (@WhereClause != '')

BEGIN

SET @WhereClause = 'WHERE ' + char(13) + @WhereClause

END

IF (@SortColumn != '')

BEGIN

SET @SortColumn = 'ORDER BY ' + @SortColumn

IF (@SortOrder != '')

BEGIN

SET @SortColumn = @SortColumn + ' ' + @SortOrder

END

SET @SQL = 'WITH E AS (

SELECT ROW_NUMBER() OVER ('+ @SortColumn +')AS Row, *

FROM [HrEmployee]

'+ @WhereClause +'

)

SELECT *

FROM E

WHERE E.Row between '+ CONVERT(nvarchar(10), @StartRowIndex) +' And ('+ CONVERT(nvarchar(10), @StartRowIndex+ @RowPerPage-1) +')'

-- print @SQL

EXEC sp_executesql @SQL

END

Earn money from Twitter

2010-06-08T00:48:00.000-07:00

Passing value and auto refresh parent window from popup

2010-06-01T05:38:00.000-07:00

Here I will show how to pass value from popup window to parent window and refresh parent window while closing popup. This is a common task and often asked in asp.net forum. In this example, I have taken two forms:

Default4.aspx >Its Master page is MasterPage.master (This is parent page)
Default5.aspx (This is child page)

I have taken UpdatePanel in parent page to check whether it is working properly with UpdatePanel. Let us see codes of Default4.aspx:

HTML:

<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true"

CodeFile="Default4.aspx.cs" Inherits="Default4" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server">

function OpenPopup() {

window.open("Default5.aspx", "Popup", "scrollbars=no,resizable=no,width=500,height=250");

return false;

}

script>

asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">

<div>

<asp:UpdatePanel ID="UpdatePanel1" runat="server">

<div>

<tr>

<td>

<asp:Label ID="Label1" runat="server" Text="Value from popup:">asp:Label>

td>

<td>

<asp:TextBox ID="txtOpenner" runat="server">asp:TextBox>

<asp:Button ID="Button1" runat="server" Text="Popup" OnClientClick="OpenPopup()" />

<asp:Label ID="Label2" runat="server" Text="">asp:Label>

td>

tr>

table>

div>

ContentTemplate>

asp:UpdatePanel>

div>

asp:Content>

Design preview:

When user click on Popup button popup window will be displayed and the textbox will show value sent from popup window.

Code behind:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

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

{

protected void Page_Load(object sender, EventArgs e)

{

int count = 0;

if (!IsPostBack)

{

Session["Count"] = 0;

}

if (IsPostBack)

{

Session["Count"] = count = int.Parse(Session["Count"].ToString())+1;

Label2.Text = "This page is postedback " + count.ToString() + " times";

}

Here I am counting how many time PostBack event is occurring in parent page and showing in Label2. I am doing this to clearly understand that parent page is refreshed clearly.

Now, Let us see codes of Default5.aspx:

HTML:

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

DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>title>

function SendValue() {

var val = document.getElementById('<%=TextBox1.ClientID%>').value;

window.opener.document.getElementById("ctl00_ContentPlaceHolder1_txtOpenner").value = val;

window.close();

window.opener.document.forms(0).submit();

}

script>

head>

<body>

<div>

<tr>

<td>

<asp:Label ID="Label1" runat="server" Text="Give your name here:">asp:Label>

td>

<td>

<asp:TextBox ID="TextBox1" runat="server">asp:TextBox>

<asp:Button ID="btnSend" runat="server" Text="Send to opener" OnClientClick="SendValue()" />

td>

tr>

table>

div>

form>

body>

html>

Code behind:

using System;

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

{

protected void Page_Load(object sender, EventArgs e)

{

}

Earn money from Freelancer.com:

Show client side alert message from server side code even when update panel is used

2010-05-25T05:24:00.000-07:00

Developers might want to display client side message with information from server side to their users when they have completed some execution at server side. People may try in different way for this purpose.
For example:
Response.Write() method with JavaScript code inside the method:

string mes = "Hello Dhaka";
        Response.Write("<script language=\"javascript\" type=\"text/javascript\">alert('" + mes + "');</script>");

or ClientScript.RegisterStartupScript() method:

string message = "<script language=\"javascript\" type=\"text/javascript\">alert('Hello Dhaka');</script>";
        if (!ClientScript.IsStartupScriptRegistered("mes"))
        {
            ClientScript.RegisterStartupScript(this.GetType(), "mes", message);
        }

But these code doesn't work when you use update panel in your page. So better solution is to use ScriptManager.RegisterStartupScript() method. This works whether update panel is used or not. So let's see the code snippet below:

string message = string.IsNullOrEmpty(TextBox1.Text) ? "Please give a text to textbox." : "You have given: " + TextBox1.Text.Trim();
        string script = "<script language=\"javascript\" type=\"text/javascript\">alert('" + message + "');</script>";
        ScriptManager.RegisterStartupScript(Page, this.GetType(), "AlertMessage", script, false);

With this code snippet you can display a modal message that their data was saved or updated successfully or not.

Truncate table when referenced by a FOREIGN KEY

2010-05-22T01:33:00.000-07:00

If you try to truncate a table that is referenced by foreign key you usually get the following error:

Cannot truncate table 'TableName' because it is being referenced by a FOREIGN KEY constraint.

To avoid this error the easiest way to use DELETE without where clause and RESEED the identity:

DELETE FROM AccVoucher
DBCC CHECKIDENT (AccVoucher, RESEED, 0)

Highlight gridview row on mouse hover in asp.net

2010-05-09T01:01:00.000-07:00

Gridview control is a customizable and flexible control used to display data in tabular format. It has some nice features. But lacks of some client side features that makes web users happy. We can easily add these features with few lines of code.

For example, a common task is to highlight gridview row on mouse over which is not provided with gridview control. Here we will see how easily we can do the task.

In order to change gridview row color we need to add/remove style attributes to that specific row using JavaScript onmouseover and onmouseout client event. We can do it on RowDataBound or RowCreated gridview event.

Code Snippet:

protected void gvHrEmploye_RowDataBound(object sender, GridViewRowEventArgs e)

{

if (e.Row.RowType == System.Web.UI.WebControls.DataControlRowType.DataRow)

{

// when mouse is over the row, save original color to new attribute, and change it to highlight color

e.Row.Attributes.Add("onmouseover", "this.originalstyle=this.style.backgroundColor;this.style.backgroundColor='#EEFFAA'");

// when mouse leaves the row, change the bg color to its original value

e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=this.originalstyle;");

}

or,

protected void gvHrEmploye_RowCreated(object sender, GridViewRowEventArgs e)

{

if (e.Row.RowType == System.Web.UI.WebControls.DataControlRowType.DataRow)

{

// when mouse is over the row, save original color to new attribute, and change it to highlight color

e.Row.Attributes.Add("onmouseover", "this.originalstyle=this.style.backgroundColor;this.style.backgroundColor='#EEFFAA'");

// when mouse leaves the row, change the bg color to its original value

e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=this.originalstyle;");

}

It works properly even if you set AlternatingRowStyle property or the row is previously selected.

How it works:

Export gridview data to excel and word

2010-02-01T07:17:00.000-08:00

Every software has a common requirement to export data to Microsoft Excel or Word format. I saw multiple on this topic in asp.net forum. Here I will explain a simple way of exporting your gridview data to excel (.xls) or word (.doc) format when used with master page and updatepanel.

Firstly we will write html codes:

<tr>

<td>

<asp:Label ID="Label3" runat="server" Text="Export to: "></asp:Label>

<asp:LinkButton ID="lnkExportToExcel" runat="server"

OnClick="lnkExportToExcel_Click">Excel</asp:LinkButton>

 <asp:LinkButton ID="lnkExportToWord" runat="server"

onclick="lnkExportToWord_Click">Word</asp:LinkButton>

 <asp:DropDownList ID="ddlExportOption" runat="server">

<asp:ListItem Value="0">This Page</asp:ListItem>

<asp:ListItem Value="1">All Page</asp:ListItem>

</asp:DropDownList>

 </td>

</tr>

</table>

Code behind:

Now we will write lnkExportToExcel and lnkExportToWord click event handler code:

protected void lnkExportToExcel_Click(object sender, EventArgs e)

{

if (ddlExportOption.SelectedIndex == 0)

{

Helper.Export("excel", gvHrEmploye, this.Page);

}

else

{

int pageNo = gvHrEmploye.PageIndex;

gvHrEmploye.AllowPaging = false;

BindList();

Helper.Export("excel", gvHrEmploye, this.Page);

gvHrEmploye.AllowPaging = true;

gvHrEmploye.PageIndex = pageNo;

BindList();

}

protected void lnkExportToWord_Click(object sender, EventArgs e)

{

if (ddlExportOption.SelectedIndex == 0)

{

Helper.Export("word", gvHrEmploye, this.Page);

}

else

{

int pageNo = gvHrEmploye.PageIndex;

gvHrEmploye.AllowPaging = false;

BindList();

Helper.Export("word", gvHrEmploye, this.Page);

gvHrEmploye.AllowPaging = true;

gvHrEmploye.PageIndex = pageNo;

BindList();

}

Here notice that we are currently displaying data or all data based on users choice.

Then we will look at export method which actually does the job:

public static void Export(string type, GridView gv, Page page)

{

if (type == "excel")

{

page.Response.AddHeader("content-disposition", "attachment;filename=EmployeeList.xls");

page.Response.ContentType = "application/vnd.xls";

}

else if (type == "word")

{

page.Response.AddHeader("content-disposition", "attachment;filename=EmployeeList.doc");

page.Response.ContentType = "application/msword";

}

page.Response.Charset = String.Empty;

System.IO.StringWriter sw = new System.IO.StringWriter();

System.Web.UI.HtmlTextWriter hw = new HtmlTextWriter(sw);

gv.RenderControl(hw);

page.Response.Write(sw.ToString());

page.Response.End();

}

You can use this code to export gridview data to excel and word format. This method works fine when working with pages that does not have update panel and have no master page. But when used with master page and update panel it gives an error while executing RenderControl()method.

Error:

"Control of type GridView must be placed inside form tag with runat = server"

To solve this error you have to override VerifyRenderingInServerForm method:

public override void VerifyRenderingInServerForm(Control control)

{

return;

}

This method confirms that HtmlForm control is rendered for specified ASP.Net server control at runtime.

If you run this time you will get another error:

“RegisterForEventValidation can only be called during Render()”

To solve this problem add EnableEventValidation = "false" page tag of .aspx page.

<%@ Page Language="C#" MasterPageFile="~/Master/MasterPage.master" AutoEventWireup="true"

MaintainScrollPositionOnPostback="true" CodeFile="HrEmployeeForm.aspx.cs" Inherits="ERP.Web.UI.HrEmployeeForm"

EnableEventValidation="false" %>

This time your code should work properly. Have a nice feature working properly in your asp.net application. Thanks.

Master Detail representation using Nested Gridview

2010-01-25T19:29:00.000-08:00

Introduction

A recurring task in software development is representing tabular data in master detail format. ASP.Net provides a number of tools for performing this task. Here I will show how to use nested grid view to show detail data related to master table on asp.net web page.

Technique

Take a grid view that display data from master table. Create last column of this grid as TemplateField. Inside this TemplateField, take another girdview to display data from detail table. Bind detail grid view in OnRowDataBound event of master grid view with related data of respective row.

Defining Task

We will bind departments of a company in a CheckedList box. We want to display employee information of selected departments to gridview. Master grid will bind department names and Detail grid will display employee information of respective department.

Expected Output:

Writing HTML code:

HTML codes should look like following:

<tr>

<asp:Label ID="lblTableHeader" runat="server" CssClass= "TableHeader" >asp:Label>

td>

tr>

<tr>

<asp:Label ID="lblDept" runat="server" Text="Select Department:" Font-Bold="True">asp:Label>

td>

<asp:CheckBoxList ID="lstDepartmentName" runat="server" Height="100px" RepeatColumns="4">

<asp:ListItem>DepartmentNameasp:ListItem>

asp:CheckBoxList>

td>

<td>

td>

tr>

<tr>

<asp:Label ID="lblEmptype" runat="server" Font-Bold="True" Text="Select Employee Type:">asp:Label>

td>

<td>

<asp:DropDownList ID="ddlEmpType" runat="server">

asp:DropDownList>

td>

<td>

td>

tr>

<tr>

<asp:Button ID="btnPreview" runat="server" CssClass="Button" OnClick="btnPreview_Click"

Text="Preview" Width="105px" />

td>

<td>

td>

<td>

td>

tr>

<tr>

<asp:GridView ID="gvDeptNameList" runat="server" AutoGenerateColumns="False" BackColor="White"

BorderColor="#CCCCCC" BorderStyle="Solid" BorderWidth="1px" CellPadding="3" EmptyDataText="No rows returned"

OnRowDataBound="gvDeptNameList_RowDataBound" Width="100%">

<asp:BoundField DataField="DepartmentName" HeaderText="Department" SortExpression="DepartmentName">

asp:BoundField>

<asp:TemplateField HeaderText="Employee Inforamtion">

<asp:GridView ID="gvEmpLstByDeptAndEmpType" runat="server" AutoGenerateColumns="False" BackColor="White" BorderColor="#CCCCCC" BorderStyle="Solid" BorderWidth="1px" CellPadding="3" EmptyDataText="No Employees"

Width="100%">

<asp:BoundField DataField="StaffCode" HeaderText="Staff Code" SortExpression="StaffCode">

asp:BoundField>

<asp:BoundField DataField="LastName" HeaderText="Employee Name" SortExpression="Name">

asp:BoundField>

<asp:BoundField DataField="DesignationName" HeaderText="Designation" SortExpression="Designation">

asp:BoundField>

<asp:BoundField DataField="GradeName" HeaderText="Grade" SortExpression="GradeName">

asp:BoundField>

Columns>

asp:GridView>

ItemTemplate>

asp:TemplateField>

Columns>

asp:GridView>

<asp:HiddenField ID="hfSortExp" runat="server" />

<asp:HiddenField ID="hfWhereCondition" runat="server" />

<asp:HiddenField ID="hfddlEmpType" runat="server" />

td>

tr>

table>

Notice in above HTML code I have taken gvDeptNameList to display department list. Here I have taken two columns. First one to display department name and second on to display related employee information of the department. Second column is TempalteField and contain Detail grid.

Code:

Now we will see back end C# code step by step:

Step1: Populate departments on Page_Load

protected void Page_Load(object sender, EventArgs e)

{

if (!Page.IsPostBack)

{

BindDepartmnets();

lblTableHeader.Text = "Departemt Wise Employee List";

}

SetPageTitle("Departemt Wise Employee List");

}

public void BindDepartmnets()

{

lstDepartmentName.DataSource = oHR_ReportBLL.EmployeeList_GetDistinctDepartments(CustomQueries.VW_EMPLOYEELIST_GETDDISTINCT_DEPARTMENTS);

lstDepartmentName.DataTextField = "DepartmentName";

lstDepartmentName.DataValueField = "DepartmentName";

lstDepartmentName.DataBind();

}

Step2: Populate Department on btnPreview_Click

protected void btnPreview_Click(object sender, EventArgs e)

{

//Get list of selected departments

List<Department> departmentList = new List<Department>();

for (int i = 0; i <= lstDepartmentName.Items.Count - 1; i++)

{

Department department = new Department();

ListItem lst = lstDepartmentName.Items[i];

if (lst.Selected)

{

if (departmentList.Count == 0)

{

department.DepartmentName = lst.Text;

departmentList.Add(department);

}

else

{

department.DepartmentName = lst.Text;

departmentList.Add(department);

}

gvDeptNameList.DataSource = departmentList;

gvDeptNameList.DataBind();

}

Step3: Populate gvEmpLstByDeptAndEmpType on gvDeptNameList_RowDataBound

protected void gvDeptNameList_RowDataBound(object sender, GridViewRowEventArgs e)

{

if (e.Row.RowType == System.Web.UI.WebControls.DataControlRowType.DataRow)

{

Department department = (Department)e.Row.DataItem;

GridView gvEmpLstByDeptAndEmpType = (GridView)e.Row.FindControl("gvEmpLstByDeptAndEmpType");

WhereCondition = " DepartmentName in('" + department.DepartmentName + "') ";

if (ddlEmpType.SelectedIndex > 0)

{

WhereCondition += " and EmployeeTypeName='" + ddlEmpType.SelectedItem.Text + "'";

}

OrderbyClause = " DesignationGroupRank ";

BindListEmpByDeptAndEmpType(WhereCondition, OrderbyClause, gvEmpLstByDeptAndEmpType);

}

public void BindListEmpByDeptAndEmpType(string WhereCondition, string orderByExpression, GridView gv)

{

List<Hr_GetEmployeesByDeartmentAndEmployeeType> lstHr_GetEmployeesByDeartmentAndEmployeeType = oHR_ReportBLL.Report_Hr_GetEmployeesByDeartmentAndEmployeeType(WhereCondition, orderByExpression);

gv.DataSource = lstHr_GetEmployeesByDeartmentAndEmployeeType;

gv.DataBind();

}

Here notice that I find gridview gvEmpLstByDeptAndEmpType inside row of gvDeptNameList that is binding its row data. Then bind related employee information to gvEmpLstByDeptAndEmpType.

Conclusion

Here I have illustrated how you can extend the functionality of GridView control to display related data by using nested GridView controls on an ASP.NET Web page. You can also extend your application to enable data to be updated and deleted or enable users to insert new records.

Simple way of using Flash file in ASP.Net web application

2009-10-10T21:35:00.000-07:00

You can easily use flash movie file in our asp.net web application. For this purpose I am using FlashControl.dll which is downloadable from here. Download free version. It works fine.

First, you have to add this control to visual studio 2008 toolbox. To do this, put FlashControl.dll file to folder of your choice. I am kept it to C:\Program Files\Microsoft ASP.NET\. Now in Visual Studio, open the Toolbox window, right-click on a tab. Select “Add Tab” option. Name it “Flash” and click ok to add new tab named “Flash”. Now right-click on “Flash” tab and select "Choose items..." option. Choose Toolbox Items dialog box opens. On the ".Net Framework components" tab click "Browse..." and select the "FlashControl.dll" file from the location you kept it. I this case it is C:\Program Files\Microsoft ASP.NET\. Check that flash control is added in the list and is selected. Click OK button to add it to toolbox.

Now take a new website project. Open your default.aspx file. Now drag and drop it on your page and set MovieUrl properties to your .swf file path. In this case MovieUrl= "~/Movie/8311.swf". Optionally you can set height and width. Note that in your source page added two tags:

<%@ Register Assembly="FlashControl" Namespace="Bewise.Web.UI.WebControls" TagPrefix="Bewise" %>

<Bewise:FlashControl ID="FlashControl1" runat="server" MovieUrl="~/Movie/8311.swf" Height="223px" Width="363px" Loop="True" />

If you don't want to have FlashControl in Visual Studio Toolbox, you can do this way:

Add a reference to FlashControl.dll in your web project, then cut and paste the following code in the source view of your aspx page:

<%@ Register Assembly="FlashControl" Namespace="Bewise.Web.UI.WebControls" TagPrefix="Bewise" %>

<Bewise:FlashControl ID="FlashControl1" runat="server" MovieUrl="~/Movie/8311.swf" Height="223px" Width="363px" Loop="True" />

You can change any FlashControl’s properties (Height, Width, Menu, Loop, Scale ...) in the designer view, by using the Smart Tag or in the Properties Window.

Now run your application to enjoy flash movie on you ASP.Net web applicat

Organization chart generator

2009-08-17T19:36:00.000-07:00

A common requirements in most of software's is to generate an hierarchical chart for example organization chart. Rotem Sapir written a DLL to make the task easier and it was published in codeproject. Rotem demonstrated the way of generating tree with text. I have modified his DLL so that we can display both picture and text so that the diagram representation becomes more appealing. Now it will generate chart like following one:

You can get updated component from here. For details of how it works please read Rotem's article from codeproject.

Create Single Instance Application using Mutex

2009-08-07T19:22:00.000-07:00

Mutex is a windows kernel level object typically used for thread synchronization across AppDomain and Process boundaries. We can easily use Mutex to confirm that only one instance of our application will run at a time. Following code snippet shows the way of achieving the goal:
using System;
using System.Windows.Forms;
using System.Threading;

namespace SingleInstanceApp
{
static class Program
{
///

/// The main entry point for the application.
///

[STAThread]
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Mutex objMutex = null;
const string MutexName = "THEONE";
try
{
//Open Mutex if already exists
objMutex = Mutex.OpenExisting(MutexName);
}
catch (WaitHandleCannotBeOpenedException)
{
//Cannot be opened because no Mutex exists
}
if (objMutex == null)
{
//Create a new instance of Mutex
objMutex = new Mutex(true, MutexName);
}
else
{
//Close Mutex because one instance already exists
objMutex.Close();
return;
}
Application.Run(new MainForm());
}
}
}

Design Enterprise Application with VS2008

2009-07-15T21:10:00.000-07:00

Microsoft Visual Studio 2008 gives us easy way design an enterprise application. Here I will demonstrate step by step process of designing application using MS Visual Studio 2008.

Create a new application design project:
1. From File menu select New>Project.
2. From new project dialog box select Distributed System project type and Application Design from templates.
3. Put ERP in name and press OK button. Application design window opens.

Design the system:
1. From Toolbox drag an ASP.NetWebApplication to Application Design window.
Set the following properties:
Name: ERP
Project: ERP
Default Class Namespace: Erp.Web.UI
Language: Visual C#
Project Location Type: File System
Target Framework: .NET Framework 3.5
Template: ASP.NET Web Site
Web Content: Dynamic

2. Drag an ASP.NetWebService to Application Design window.
Set the following properties:
Name: POSService
Project: POSService
Default Class Namespace: POSService
Language: Visual C#
Project Location Type: File System
Target Framework: .NET Framework 3.5
Template: Empty Web Site
Web Content: Dynamic

3. Drag another ASP.NetWebService to Application Design window.
Set the following properties:
Name: ParserService
Project: ParserService
Default Class Namespace: ParserService
Language: Visual C#
Project Location Type: File System
Target Framework: .NET Framework 3.5
Template: Empty Web Site
Web Content: Dynamic

4. Drag a WindowsApplication to Application Design window.
Set the following properties:
Name: POSClient
Project: POSClient
Language: Visual C#
Target Framework: .NET Framework 3.5
Template: Windows Forms Application

5. Drag another WindowsApplication to Application Design window.
Set the following properties:
Name: ParserClient
Project: ParserClient
Language: Visual C#
Target Framework: .NET Framework 3.5
Template: Windows Forms Application

6. Drag an External Database and set name properties to ErpDB.

The design should look like the following figure:

Now we will connect each application end point.

Connect ASP.NetWebApplication to Database:
1. Right click on ASP.NetWebApplication.
2. Select Connect. Create connection window appears.

3. Select ErpDB from Application drop down list in Connect to panel and click OK.
4. SQL Server Connection Properties window will appear. Provide your connection information and click OK button. Connection to ERP and ErpDB will be established.

This way connect:
POSService to ERP ,
POSClient to POSService,
ParserService to ERP and
ParserClient to ParserService .

Match your design to following figure:

Our design is OK. Now we will implement the design so that we get application framework.
Implement the design:
1. Right click on design window. Select Implement All Applications.
2. Confirm Application Implementation dialog box appears. Press OK button.

Notice that in Solution Explorer, you will see five new projects added. Now your framework is ready and go ahead with further coding.

Increase database performance with proper indexing (A practical experience explained)

2009-07-13T22:54:00.000-07:00

Relational databases used index to find out data quickly. An Index is an underlying structure that determines how data is stored. Proper Indexing can increase your database's overall performance when your database becomes larger. Recently I have worked with a medical customer who uses software for their Pathology department developed by other party. Problem with that software was that it becomes slower by the end of month when data size overcomes 150MB. I was engaged to solve the problem.

I have changed inline queries to stored procedure which increased performance a bit. But when I have created Index, performance increased drastically.

Let’s see how to identify fields for indexing:

I have identified queries on tables that have heavy data load. Then I have identified fields of the table that are not primary key or don’t contain foreign key reference but they are used in query's where clause or group by clause. For example, I have a table named "RequestCompositList" with primary key field "ID" and I have following queries on this table that is called frequently:

SELECT ID, ReqID, CID,
FROM RequestCompositList
WHERE ReqID='0152435' AND CID ='546466'

or

SELECT Count(ID), ReqID
FROM RequestCompositList
GROUP BY ReqID

In this table I have created two non-clustered index on RequestCompositList table for example: IX_RequestCompositList_ReqID and IX_RequestCompositList_CID, this drastically increases my query performance on this table.

I kept some consideration in mind while creating index on this database:

1. Index a field which is frequently used for searching.
2. No indexing on tables with little data.

This worked for me. Hope will work for others also.