ASP.Net, C#, SQL Server Programming

14 Google Fun Tricks and Easter Eggs That You'd Love to Know

noreply@blogger.com (uniquesaiful) — Wed, 28 Nov 2018 07:49:00 -0800

14 Google Easter Eggs And Fun Tricks That You'd Love to Know
In this video I have shown top 14 google easter eggs on google search page that most of the people don't know. All these are google secret tricks that you can try in google search page.

Generally when we think about google, we think it as a giant search engine that can find any result for the text we are searching for. It can do a bit more.

For having fun with Google secrets, be sure to watch the full video.

Please watch till the end of the video, I hope you will enjoy it.

If you have enjoy the video, please go ahead and like it.

Write us in comment how helpful this video for you. If you think this might be helpful for your friends, Please share the video with your friends.

If you have any question, regarding the video, Please write us through comments.

Please join in our community through subscription of channel and subscription of video notification.

In triksbuddy channel, you will get different interesting tech stuffs that will help you enrich your technology knowledge. Please subscribe our channel to get updates of our videos. Subscription link: https://goo.gl/GE4g8v

/*ignore*/
These video answers to following queries:
- fun google maps tricks,
- fun tricks google can do
- fun tricks to do with google,
- google assistant fun tricks,
- google chrome fun tricks,
- google easter eggs 2017
- google easter eggs 2018,
- google easter eggs and secrets,
- google easter eggs android,
- google easter eggs dreamworks,
- google easter eggs games,
- google easter eggs gravity,
- google easter eggs hangouts,
- google easter eggs mario,
- google easter eggs mobile,
- google easter eggs on phone,
- google easter eggs reaction time,
- google easter eggs wikipedia,
- google easter eggs youtube,
- google fun tricks 2017,
- google fun tricks and secrets,
- google fun tricks easter eggs,
- google fun tricks list,
- google hangouts fun tricks,
- ok google fun tricks,

/*ignore*/

Convert PDF To JPG with zamzar.com

noreply@blogger.com (uniquesaiful) — Wed, 28 Nov 2018 07:46:00 -0800

In this video I have shown how to convert pdf to jpg with zamzer.com. It allows user to convert documents to many different formats like :

PDF to Word | PDF to Excel | FLAC to MP3 | DOC to PDF | EPUB to PDF | MP4 to MP3 | PDF to DOC | WAV to MP3 | MKV to MP4 | DJVU to PDF | JPG to Word | XPS to PDF | FLV to MP3 | MOV to MP4 | Excel to PDF | PNG to PDF | PDF to JPG | DOCX to PDF | EPUB to MOBI | MP3 to WAV | MP4 to GIF | PPT to PDF | Excel to PDF | PNG to JPG | PDF to DWG | PDF to DOCX | JPG to GIF | JPG to PNG | FLV to MP4 | Word to PDF

This is a very helpful software which is free for users.

Url: https://www.zamzar.com/convert/pdf-to...

Please watch till the end of the video, I hope you will enjoy it.

If you have enjoy the video, please go ahead and like it.

Write us in comment how helpful this video for you. If you think this might be helpful for your friends, Please share the video with your friends.

If you have any question, regarding the video, Please write us through comments.

Please join in our community through subscription of channel and subscription of video notification.

In triksbuddy channel, you will get different interesting tech stuffs that will help you enrich your technology knowledge. Please subscribe our channel to get updates of our videos. Subscription link: https://goo.gl/GE4g8v

/*ignore*/
triksbuddy,Convert PDF To JPG with zamzar.com,how to convert pdf to jpg,convert pdf to jpg,convert from pdf to jpg,pdf to jpg,pdf to jpg convert tricks,pdf to jpg converter,pdf to jpg converter free,convert pdf to jpg online,free convert pdf to jpg,pdf to jpg windows 10,pdf to word,pdf to excel,how to convert pdf to word,pdf to word converter,pdf to jpg windows 10 free,how to convert pdf to jpg image,convert pdf to jpg free,pdf to jpg converter software,pdf to jpg converter online free high quality,how to convert pdf to jpg on mac,how to convert pdf to jpg on windows 10,how to convert pdf to jpg on iphone,pdf to jpg converter free download,jpg to pdf converter free download full version for windows 7,free jpg to pdf converter,convert pdf to jpg online free,how to convert pdf file to jpg online,how to convert pdf to jpg online free,how to convert photo from pdf to jpg,how to convert image from pdf to jpg,how to convert pdf to jpg image offline,how to convert pdf file to jpg image
/*ignore*/

Unlimited Photos and Videos backup free in Google Photos

noreply@blogger.com (uniquesaiful) — Wed, 28 Nov 2018 07:44:00 -0800

In this video I have shown how you can Back up Photos and Videos from Mobile to Google Photos.

Please watch till the end of the video, I hope you will enjoy it.

If you have enjoy the video, please go ahead and like it.

Write us in comment how helpful this video for you. If you think this might be helpful for your friends, Please share the video with your friends.

If you have any question, regarding the video, Please write us through comments.

Please join in our community through subscription of channel and subscription of video notification.

In triksbuddy channel, you will get different interesting tech stuffs that will help you enrich your technology knowledge. Please subscribe our channel to get updates of our videos. Subscription link: https://goo.gl/GE4g8v

How to add social media icons in email signature

noreply@blogger.com (uniquesaiful) — Sun, 14 Oct 2018 10:01:00 -0700

How to get/set a Control’s position on client side?

noreply@blogger.com (uniquesaiful) — Sun, 6 Jan 2013 22:16:00 -0800

Microsoft AJAX Library provides a bunch of facilities to manipulate the HTML element on client side, including getting and setting the position of an element.

For example:
To get a Panel's current position on the client side, we can use $common.getLocation(DOM Element) function.

//Get DOM Element with $get() function. 
var el = $get('<%=Panel1.ClientID%>');   
//Get its position.  
var newLocation = $common.getLocation(el);

To set its position:

//Create the new position.
var newLocation = new Sys.UI.Point(x-position,y-position);
//Move the Panel to the destination.
$common.setLocation(Panel, newLocation);

Sometimes,

How to solve error: 404.2 The page you are requesting cannot be served

noreply@blogger.com (uniquesaiful) — Mon, 17 Sep 2012 12:54:00 -0700

Problem:
I get the error while trying to visit home page of a deployed asp.net 4 application in IIS7: 404.2 The page you are requesting cannot be served because of the ISAPI and CGI Restriction list settings on the Web server.

How can I solve this issue?

Solution:
This error occurs because the requested ISAP(Internet Server API) and/or CGI(Common Gateway Interface) resource is restricted on the computer that is running IIS 7. After installing .NET Framework 4.0 on a machine there is a few configuration changes you need to do to IIS in order to get a ASP.NET 4.0 page running.

To resolve this issue you have to follow steps mentioned below:

1. Open IIS and Click on the sever name.
2. In Feature View Double click "ISAPI and CGI Restrictions"

3. Select ASP.Net V4 and click Allow in action panel. It will be set to Allowed.

Now your application should run.

How to call server side a direct method from ext.net gridpanel?

noreply@blogger.com (uniquesaiful) — Tue, 4 Sep 2012 09:53:00 -0700

In ext.net you can call server side direct method from your client side code. This is an excellent way to doing jobs on server side from client side java script function and grid panel, button or other controls. Here we will see how we can do this job done in a grid panel.

In the following code snippet will call a direct method against an action in a grid panel action column. Also we will pass some arguments from our grid to direct method that we require for data manipulation on server side.

Let see code for grid panel:

<ext:GridPanel ID="gpList" runat="server" StripeRows="true" Title="BO List" AutoExpandColumn="name"

Collapsible="true" AnchorHorizontal="100%" Height="350">

<Store>

<ext:Store ID="gpListStore" runat="server" OnRefreshData="gpListStore_RefreshData"

OnSubmitData="gpListStore_SubmitData">

<ext:JsonReader IDProperty="cno">

<ext:RecordField Name="dividendyear" />

<ext:RecordField Name="declareid" />

<ext:RecordField Name="wno" />

<ext:RecordField Name="name" />

<ext:RecordField Name="boid" />

<ext:RecordField Name="shares" />

<ext:RecordField Name="dividendM" />

<ext:RecordField Name="taxrate" />

<ext:RecordField Name="taxamt" />

<ext:RecordField Name="netamt" />

<ext:RecordField Name="actionid" />

<ext:RecordField Name="status" />

</Fields>

</ext:JsonReader>

</Reader>

</ext:Store>

</Store>

<ext:RowNumbererColumn />

<ext:Column ColumnID="cdeclareid" Header="Declare Id" DataIndex="declareid" Width="70" />

<ext:Column ColumnID="cdividendyear" Header="Year" DataIndex="dividendyear" Width="50">

</ext:Column>

<ext:Column ColumnID="cBoid" Header="Boid" DataIndex="boid" Width="130" />

<ext:Column ColumnID="cname" Header="Name" DataIndex="name" />

<ext:Column ColumnID="cshares" Header="Shares" DataIndex="shares" Width="50" />

<ext:Column ColumnID="cdividendM" Header="Dividend" DataIndex="dividendM" Width="50" />

<ext:Column ColumnID="ctaxrate" Header="Tax Rate" DataIndex="taxrate" Width="50" />

<ext:Column ColumnID="ctaxamt" Header="Tax Amt" DataIndex="taxamt" Width="50" />

<ext:Column ColumnID="cnetamt" Header="Net Amt" DataIndex="netamt" Width="50" />

<ext:Column ColumnID="cStatus" Header="Status" DataIndex="status" />

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

<ext:GridCommand Icon="ApplicationViewDetail" CommandName="ViewDetail">

</ext:GridCommand>

<ext:CommandSeparator />

<ext:GridCommand Icon="AsteriskRed" CommandName="Action">

</ext:GridCommand>

<ext:CommandSeparator />

<ext:GridCommand Icon="Connect" CommandName="Communication">

</ext:GridCommand>

</Commands>

</ext:CommandColumn>

</Columns>

</ColumnModel>

<ext:CheckboxSelectionModel ID="CheckboxSelectionModel1" runat="server" />

</SelectionModel>

<ext:PagingToolbar ID="PagingToolBar1" runat="server" PageSize="10" />

</BottomBar>

</Listeners>

<ext:Parameter Name="field" Value="e.field" Mode="Raw" />

<ext:Parameter Name="id" Value="e.record.id" Mode="Raw" />

<ext:Parameter Name="record" Value="e.record.data" Mode="Raw" Encode="true" />

</ExtraParams>

</AfterEdit>

</DirectEvents>

</ext:GridPanel>

Direct method is called using listener in ext.net which always woks at client side.

</Listeners>

Here in Action column we have three action commands:

1. ViewDetail

2. Action

3. Communication

These commands will pass to parameter command and on server side we will decide which action actually performed. Server side code is here:

[DirectMethod]

public void ExecuteActionCommand(string command, string wno, string declareid, string boid)

{

if (command == "ViewDetail")

{

//Display bo holder detail info

var win = new Window

{

ID = "BOWindow",

Title = "Bo Detail",

Width = Unit.Pixel(800),

Height = Unit.Pixel(380),

Modal = true,

Collapsible = true,

Maximizable = false,

Hidden = false,

};

win.AutoLoad.Url = "~/BoMasterDetails.aspx?boid=" + boid + "&declareid=" + declareid;

win.AutoLoad.Mode = LoadMode.IFrame;

win.Render(this.Form); win.Dispose();

}

else if (command == "Action")

{

var win = new Window

{

ID = "ActionWindow",

Title = "Corporate Action",

Width = Unit.Pixel(800),

Height = Unit.Pixel(550),

Modal = true,

Collapsible = true,

Maximizable = false,

Hidden = false,

};

win.AutoLoad.Url = "~/ActionLogEntryPopup.aspx?wno=" + wno + "&boid=" + boid + "&declareid=" + declareid;

win.AutoLoad.Mode = LoadMode.IFrame;

win.Render(this.Form); win.Dispose();

}

else if (command == "Communication")

{

dividend div = new dividendBLL().dividend_GetAll_By_wno(wno).FirstOrDefault();

var win = new Window

{

ID = "CommWindow",

Title = "Communication",

Width = Unit.Pixel(800),

Height = Unit.Pixel(550),

Modal = true,

Collapsible = true,

Maximizable = false,

Hidden = false,

};

win.AutoLoad.Url = "~/CommunicationLogEntryPopup.aspx?wno=" + wno + "&boid=" + boid + "&declareid=" + declareid;

win.AutoLoad.Mode = LoadMode.IFrame;

win.Render(this.Form); win.Dispose();

}

How to display a popup dynamically in ext.net?

noreply@blogger.com (uniquesaiful) — Tue, 4 Sep 2012 09:51:00 -0700

Here I will show you quick tips on how you can create a dynamic popup control in your ext.net application.

Look at the following server side ext.net code snippet:

var win = new Window

{

ID = "CommWindow",

Title = "Communication",

Width = Unit.Pixel(800),

Height = Unit.Pixel(550),

Modal = true,

Collapsible = true,

Maximizable = false,

Hidden = false,

};

win.AutoLoad.Url = "~/CommunicationLogEntryPopup.aspx?wno=" + wno + "&boid=" + boid + "&declareid=" + declareid;

win.AutoLoad.Mode = LoadMode.IFrame;

win.Render(this.Form); win.Dispose();

First create a window and define all its properties and load your page into the window and IFrame.

Hope this will help you guys.

Making ViewState Secure

noreply@blogger.com (uniquesaiful) — Wed, 1 Jun 2011 20:24:00 -0700

One of the most common ways to store information is in view state. View State uses hidden
field that ASP.Net automatically inserts in the rendered HTML of a web page. View state
information is stored in a single jumbled string that looks like this:

As this value isn’t formated as clear text, many ASP.Net programmers assume that
their view state data is encrypted. Actually, view state information is simply patched
together in memory and converted to a Base54 string which is a special type of string that
is always acceptable in an HTML document because it does not include any special character.
A clever hacker could reverse-engineer this string and examine your view state data
in a matter of second.
To make your secure data temperproof you have to use encryption enabled. You can turn on
encryption for an individual page using the ViewStateEncryptionMode property of the page
directive:

Count total working days between two days in T-SQL

noreply@blogger.com (uniquesaiful) — Thu, 6 Jan 2011 01:08:00 -0800

Create a user defined scalar function:

CREATE FUNCTION [dbo].[udf_GetWorkingDays](@StartDate DATETIME,@EndDate DATETIME)

RETURNS INT

BEGIN

DECLARE @CurDate DATETIME

DECLARE @i INT

DECLARE @days INT

set @i=1

set @days=0

while @i<=(DATEDIFF(dd, @StartDate, @EndDate))

begin

set @CurDate=dateadd(day,@i, @StartDate)

if(DATENAME(dw, @CurDate) != 'Friday' and DATENAME(dw, @CurDate) != 'Saturday')

begin

set @days=@days+1

end

set @i=@i+1

end

RETURN @days

END

Let's test now with following query:

select dbo.udf_GetWorkingDays('01/01/2011','01/31/2011') as TotalWorkingDays

Result is: 22

Hope this will help others.

Gridview RowEditing or RowDeleting event fires twice problem

noreply@blogger.com (uniquesaiful) — Sun, 24 Oct 2010 04:01:00 -0700

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)

noreply@blogger.com (uniquesaiful) — Tue, 7 Sep 2010 21:54:00 -0700

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

noreply@blogger.com (uniquesaiful) — Mon, 26 Jul 2010 21:20:00 -0700

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

noreply@blogger.com (uniquesaiful) — Mon, 21 Jun 2010 03:56:00 -0700

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

noreply@blogger.com (uniquesaiful) — Sun, 13 Jun 2010 05:43:00 -0700

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

noreply@blogger.com (uniquesaiful) — Sun, 13 Jun 2010 03:55:00 -0700

Earn money from Twitter

noreply@blogger.com (uniquesaiful) — Tue, 8 Jun 2010 00:48:00 -0700

Passing value and auto refresh parent window from popup

noreply@blogger.com (uniquesaiful) — Tue, 1 Jun 2010 05:38:00 -0700

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

noreply@blogger.com (uniquesaiful) — Tue, 25 May 2010 05:24:00 -0700

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

noreply@blogger.com (uniquesaiful) — Sat, 22 May 2010 01:33:00 -0700

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

noreply@blogger.com (uniquesaiful) — Sun, 9 May 2010 01:01:00 -0700

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

noreply@blogger.com (uniquesaiful) — Mon, 1 Feb 2010 07:17:00 -0800

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

noreply@blogger.com (uniquesaiful) — Mon, 25 Jan 2010 19:29:00 -0800

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

noreply@blogger.com (uniquesaiful) — Sat, 10 Oct 2009 21:35:00 -0700

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

noreply@blogger.com (uniquesaiful) — Mon, 17 Aug 2009 19:36:00 -0700

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.