Preventing / Blocking Page Review after Logout with Forms Authentication

After logging out we can prevent getting previous page or information by doing following things.

Add Code to Page Load event:
—————————–

Response.Cache.SetExpires(DateTime.UtcNow.AddMinutes(-1));
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.Cache.SetNoStore();

Or We can use following code
Continue reading

Export to pdf ( Create pdf on fly ) using ASP.net and C#

Consider following code for creating pdf document on fly using ASP.net in C#.

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.IO;
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;

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

 Continue reading 

How to enable Paging in GridView in ASP.net or Grid View Paging doesn’t work

Do Following steps.

–> Set EnablePaging and Sorting Callback = True from Propertise.
Set your data source as general way.

Now do another extra job for working paging
Write down the following code under PageIndexGhanging Event

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
      //Create your data set or table as u did 
        GridView1.PageIndex = e.NewPageIndex;
        GridView1.DataSource = ds;
        GridView1.DataBind();
    }

Filter data by date time in MS access, Select only date without selecting time from date time field in MS Access

Select * from TransactionInfo where CDate(Int([CreatedDate])) between #2010-05-04# and #2010-05-05#
—————–
it will return date like
—————–

23-May-2010

Select * from TransactionInfo where [CreatedDate] between #2010-05-04# and #2010-05-05#

—————–
it will return
—————–

Continue reading

Cursor in MS SQL

Using Cursor in MS SQL Server 2005 or 2008
Consider following code for creating cursor

declare db_cursor CURSOR for
SELECT ItemSLNO FROM P_Return_ItemSLNOTraking where Com_PReturnId_ItemId = @Com_ReceiveId_ItemId
OPEN db_cursor
FETCH NEXT FROM db_cursor INTO @ItemSLNO
WHILE @@FETCH_STATUS = 0
BEGIN
SET @SLNO = @SLNO+ ','+ @ItemSLNO
FETCH NEXT FROM db_cursor INTO @ItemSLNO
END
CLOSE db_cursor
DEALLOCATE db_cursor

Split in MS SQL SERVER

Here I shall describe about split in MS SQL.

There is no built in function for splitting your text, that’s why I am describing two customize function for performing split operation in MS SQL.


Split function 1: This function returns table that’s why we can say it table valued function.

--select * from fnSplit('1,22,333,444,,5555,666', ',')
CREATE FUNCTION dbo.fnSplit(
  @sInputList VARCHAR(8000) -- List of delimited items
, @sDelimiter VARCHAR(8000) = ',' -- delimiter that separates items
) RETURNS @List TABLE (item VARCHAR(8000))

 Continue reading