Rodney Vinyard - .NET & SQL Developer

ASP.NET MVC 3 Walkthroughs & Books

Rodney Vinyard — Tue, 31 Jan 2012 14:45:38 GMT

ASP.NET MVC 3 Walkthroughs & Books

1. Intro to ASP.NET MVC 3 - Rick Anderson

http://www.asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/getting-started-with-mvc3-part1-cs

2. Building an MVC 3 App with Database First – Julie Lerman

a. http://msdn.microsoft.com/en-us/data/gg685489

3. Walkthrough: Retrieving Entity Types with a Stored Procedure (Entity Data Model Tools

a. http://msdn.microsoft.com/en-us/library/cc716672.aspx

4. Book – Wrox - Professional ASP.NET MVC 3

http://www.wrox.com/WileyCDA/WroxTitle/Professional-ASP-NET-MVC-3.productCd-1118076583,descCd-DOWNLOAD.html

Last n Months Display-Value Pair for DropDown List greater than a minimumm date

Rodney Vinyard — Tue, 31 Jan 2012 12:43:20 GMT

Create PROCEDURE [dbo].[ts_Dates]

@isTo bit

-----------------------------------------------------

--Last Dates Display-Value Pair for DropDown List

for date greater than

-----------------------------------------------------

exec [dbo].[ts_Dates] 0

exec [dbo].[ts_Dates] 1

declare @minToDate datetime

declare @minFromDate datetime

select @minToDate = min(<date>) from <table>;

select @minFromDate = DATEADD(MONTH,-1,min(<date>)) from <table>;

--print @minToDate

--print @minFromDate

if @isTo = 1

begin

--Display Value

------------------------------------------- --------------

--February 29, 2012 2/29/2012

--January 31, 2012 1/31/2012

--December 31, 2011 12/31/2011

--with

WITH R(N) AS (

sELECT 0

UNION ALL

SELECT N+1 FROM R

WHERE N < 100 )

, cte2 (Display, Value, [date]) as (

SELECT DATENAME(MONTH,DATEADD(MONTH,-N,GETDATE()))

+ ' ' + CONVERT(VARCHAR(4),DATEPART(Day, DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,DATEADD(MONTH,-N,GETDATE()))+1,0))))

+ ', ' + CAST(DATEPART(YEAR,DATEADD(MONTH,-N,GETDATE())) AS VARCHAR(4)) AS Display

, CONVERT(VARCHAR(4),DATEPART(MONTH,DATEADD(MONTH,-N,GETDATE())))

+ '/'

+ CONVERT(VARCHAR(4),DATEPART(Day, DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,DATEADD(MONTH,-N,GETDATE()))+1,0))))

+'/' + CONVERT(VARCHAR(4),DATEPART(YEAR,DATEADD(MONTH,-N,GETDATE()))) AS [Value]

, DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,DATEADD(MONTH,-N,GETDATE()))+1,0)) as [date]

FROM R )

select * from cte2 where [date] > @minToDate

end

else

begin

--Display Value

---------------------------------------- -----------

--February 1, 2012 2/1/2012

--January 1, 2012 1/1/2012

--December 1, 2011 12/1/2011

WITH R(N) AS (

sELECT 0

UNION ALL

SELECT N+1 FROM R

WHERE N < 100 )

, cte2 (Display, Value, [date]) as (

SELECT DATENAME(MONTH,DATEADD(MONTH,-N,GETDATE())) + ' 1, ' +

CAST(DATEPART(YEAR,DATEADD(MONTH,-N,GETDATE())) AS VARCHAR(4)) AS Display

, CONVERT(VARCHAR(4),DATEPART(MONTH,DATEADD(MONTH,-N,GETDATE())))

+ '/1/' + CONVERT(VARCHAR(4),DATEPART(YEAR,DATEADD(MONTH,-N,GETDATE()))) AS [Value]

, DATEADD(MONTH, DATEDIFF(MONTH, 0, DATEADD(MONTH,-N,GETDATE())), 0) as [date]

FROM R )

select * from cte2 where [date] > @minFromDate

end

Create

PROCEDURE [dbo].[ts_Dates]

@isTo bit

-----------------------------------------------------

--Last 100 Months Display-Value Pair for DropDown List

-----------------------------------------------------

exec [dbo].[ts_Dates] 0

exec [dbo].[ts_Dates] 1

if @isTo = 1

begin

--Display Value

------------------------------------------- --------------

--February 29, 2012 2/29/2012

--January 31, 2012 1/31/2012

--December 31, 2011 12/31/2011

WITH R(N) AS (

sELECT 0

UNION ALL

SELECT N+1 FROM R

WHERE N < 100 )

SELECT DATENAME(MONTH,DATEADD(MONTH,-N,GETDATE()))

+ ' ' + CONVERT(VARCHAR(4),DATEPART(Day, DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,DATEADD(MONTH,-N,GETDATE()))+1,0))))

+ ', ' + CAST(DATEPART(YEAR,DATEADD(MONTH,-N,GETDATE())) AS VARCHAR(4)) AS Display

, CONVERT(VARCHAR(4),DATEPART(MONTH,DATEADD(MONTH,-N,GETDATE())))

+ '/'

+ CONVERT(VARCHAR(4),DATEPART(Day, DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,DATEADD(MONTH,-N,GETDATE()))+1,0))))

+'/' + CONVERT(VARCHAR(4),DATEPART(YEAR,DATEADD(MONTH,-N,GETDATE())))

AS [Value]

FROM R

end

else

begin

--Display Value

---------------------------------------- -----------

--February 1, 2012 2/1/2012

--January 1, 2012 1/1/2012

--December 1, 2011 12/1/2011

WITH R(N) AS (

sELECT 0

UNION ALL

SELECT N+1 FROM R

WHERE N < 100 )

SELECT DATENAME(MONTH,DATEADD(MONTH,-N,GETDATE())) + ' 1, ' +

CAST(DATEPART(YEAR,DATEADD(MONTH,-N,GETDATE())) AS VARCHAR(4)) AS Display

, CONVERT(VARCHAR(4),DATEPART(MONTH,DATEADD(MONTH,-N,GETDATE())))

+ '/1/' + CONVERT(VARCHAR(4),DATEPART(YEAR,DATEADD(MONTH,-N,GETDATE())))

AS [Value]

FROM R

end

CREATE

FUNCTION [dbo].[tsDatesInRange] (@DateStart DATETIME, @DateEnd DATETIME) RETURNS TABLE AS RETURN (

--=======================================================================================

-- Find first of every month between the start and end dates (inclusive)

--=======================================================================================

--===== Here are the two parameters you wanted

DECLARE @DateStart DATETIME

DECLARE @DateEnd DATETIME

SELECT @DateStart = '20070429',

@DateEnd = '20081201'

select * from tsDatesInRange('20070429', '20081201')

--===== Find the dates using a Tally table as a counter.

-- The outer select formats it. Once cached, it's incredibly fast.

WITH

cteTally

(

--==== Returns a value of 1 to the number of months in date range

SELECT TOP (DATEDIFF(mm,

DATEADD(mm,DATEDIFF(mm,0,@DateStart),0), --First of start month

DATEADD(mm,DATEDIFF(mm,0,@DateEnd)+1,0))) --First of month after end month

= ROW_NUMBER() OVER (ORDER BY t1.Object_ID)

FROM Master.sys.All_Columns t1

CROSS JOIN Master.sys.All_Columns t2

)

SELECT N,

--DateStart = DATEADD(mm,DATEDIFF(mm,0,@DateStart)+t.N-1,0),

--NextStart = DATEADD(mm,DATEDIFF(mm,0,@DateStart)+t.N,0)

month(DATEADD(mm,DATEDIFF(mm,0,@DateStart)+t.N-1,0)) [Month]

,Year(DATEADD(mm,DATEDIFF(mm,0,@DateStart)+t.N-1,0)) [Year]

FROM cteTally t

)

Generate insert SQL for a table

Rodney Vinyard — Thu, 12 Jan 2012 15:17:56 GMT

Thanks to

Andraax
Aged Yak Warrior

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=23133

Generate insert SQL for a table - Insert this stored proc:

create

proc [dbo].[generate_inserts] @table varchar(50)

--Generate inserts for table @table

declare

@cols varchar(1000)

declare

@col varchar(50)

generate_inserts 'PlanLevel1ControlResponsibility'

set

@cols=''

declare

colcur

cursor

for

select

column_name

from

information_schema.columns

where

table_name=@table

open

colcur

fetch

next from colcur into @col

while

@@fetch_status=0

begin

select

@cols = @cols + ', ' + @col

fetch

next from colcur into @col

end

colcur

deallocate

colcur

select

@cols = substring(@cols, 3, datalength(@cols))

--select @cols

declare

@sql varchar(4000)

declare

@colname varchar(100),

@coltype

varchar(30)

select

@sql = 'select replace(''insert ' + @table + ' (' + @cols + ') '

select

@sql = @sql + 'values ('''

declare

ccur

cursor

for

select

column_name, data_type

from

information_schema.columns

where

table_name=@table

open

ccur

fetch

from ccur into @colname, @coltype

while

@@fetch_status=0

begin

@coltype in ('varchar', 'char', 'datetime')

select

@sql=@sql + ''''''

select

@sql=@sql + ' + coalesce(convert(varchar, ' + @colname + '), ''null'') + '

@coltype in ('varchar', 'char', 'datetime')

select

@sql=@sql + ''''''

select

@sql = @sql + ''', '''

fetch

from ccur into @colname, @coltype

end

ccur

deallocate

ccur

select

@sql=substring(@sql, 1, datalength(@sql)-3)

select

@sql=@sql + ')'', ''''''null'''''', ''null'') from ' + @table

exec

(@sql)

list schema, table, row count in a database

Rodney Vinyard — Mon, 09 Jan 2012 01:40:26 GMT

-----------------------------------------------------------

--all info from Tables

-----------------------------------------------------------

SELECT

FROM

sys.Tables

-----------------------------------------------------------

--Schema.name from Tables

-----------------------------------------------------------

SELECT

'['+SCHEMA_NAME(schema_id)+'].['+name+']'

SchemaTable

FROM

sys.tables

-----------------------------------------------------------

--Schema, name from Tables

-----------------------------------------------------------

SELECT

SCHEMA_NAME(schema_id) [Schema]

name [Table]

FROM

sys.tables

-----------------------------------------------------------

--(for dropdownlist) Schema.name - rowcount, Schema.name from Tables

-----------------------------------------------------------

select

--'['+SCHEMA_NAME(t.[SCHEMA_ID])+'].['+t.NAME+']' AS [fulltable_name],

SCHEMA_NAME

(t.[SCHEMA_ID]) as [schema_name],t.NAME as [table_name] ,i.rows

from

sys.tables t

INNER

JOIN sysindexes i ON (t.object_id = i.id AND i.indid < 2)

SELECT

[TableAndCount]

= '['+SCHEMA_NAME(t.[SCHEMA_ID])+'].['+t.NAME+']' + ' - ' + CAST(i.rows as varchar(10)) + ' Rows',

[Name]

= '['+SCHEMA_NAME(t.[SCHEMA_ID])+'].['+t.NAME+']'

--[RowCount] = MAX(si.rows)

FROM

sys.tables t

INNER JOIN sysindexes i ON (t.object_id = i.id AND i.indid < 2)

ORDER

'['+SCHEMA_NAME(t.[SCHEMA_ID])+'].['+t.NAME+']'

Display Foreign Key Relationships and Name of the Constraint for Each Table in Database

Rodney Vinyard — Thu, 15 Dec 2011 13:04:55 GMT

Display Foreign Key Relationships and Name of the Constraint for Each Table in Database

Original Article: http://blog.sqlauthority.com/2006/11/01/sql-server-query-to-display-foreign-key-relationships-and-name-of-the-constraint-for-each-table-in-database/

I changed to version below to

1) show PK to the left

2) trim the result columns

SELECT

PK_Table =Left(PK.TABLE_NAME, 35),

PK_Column =Left(PT.COLUMN_NAME, 12),

FK_Table =Left(FK.TABLE_NAME, 25),

FK_Column =Left(CU.COLUMN_NAME, 20),

Constraint_Name = C.CONSTRAINT_NAME

FROM INFORMATION_SCHEMA . REFERENTIAL_CONSTRAINTS C

INNER JOIN INFORMATION_SCHEMA . TABLE_CONSTRAINTS FK ON C.CONSTRAINT_NAME = FK.CONSTRAINT_NAME

INNER JOIN INFORMATION_SCHEMA . TABLE_CONSTRAINTS PK ON C.UNIQUE_CONSTRAINT_NAME = PK.CONSTRAINT_NAME

INNER JOIN INFORMATION_SCHEMA . KEY_COLUMN_USAGE CU ON C.CONSTRAINT_NAME = CU.CONSTRAINT_NAME

INNER JOIN (

SELECT i1.TABLE_NAME, i2.COLUMN_NAME

FROM INFORMATION_SCHEMA . TABLE_CONSTRAINTS i1

INNER JOIN INFORMATION_SCHEMA . KEY_COLUMN_USAGE i2 ON i1.CONSTRAINT_NAME = i2.CONSTRAINT_NAME

WHERE i1.CONSTRAINT_TYPE ='PRIMARY KEY'

) PT ON PT.TABLE_NAME = PK.TABLE_NAME

---- optional:

ORDER BY

--1,2,3,4

PK_Table, FK_Table

--WHERE PK.TABLE_NAME='something'WHERE FK.TABLE_NAME='something'

--WHERE PK.TABLE_NAME IN ('one_thing', 'another')

--WHERE FK.TABLE_NAME IN ('one_thing', 'another')

FTP Upload ftpWebRequest Proxy

Rodney Vinyard — Fri, 11 Nov 2011 15:08:44 GMT

Searchable:

FTP Upload ftpWebRequest Proxy

FTP command is not supported when using HTTP proxy

In the article below I will cover 2 topics

1. C# & Windows Command-Line FTP Upload with No Proxy Server

2. C# & Windows Command-Line FTP Upload with Proxy Server

Not covered here: Secure FTP / SFTP

Sample Attributes:

· UploadFilePath = “\\servername\folder\file.name”

· Proxy Server = “ftp://proxy.server/”

· FTP Target Server = ftp.target.com

· FTP User = “User”

· FTP Password = “Password”

with No Proxy Server

· Windows Command-Line

> ftp ftp.target.com

> ftp User: User

> ftp Password: Password

> ftp put \\servername\folder\file.name

> ftp dir

(result: file.name listed)

> ftp del file.name

> ftp dir

(result: file.name deleted)

> ftp quit

· C#

//-----------------

//Start FTP via _TargetFtpProxy

//-----------------

string relPath = Path.GetFileName(\\servername\folder\file.name);

//result: relPath = “file.name”

FtpWebRequest ftpWebRequest = (FtpWebRequest)WebRequest.Create("ftp.target.com/file.name);

ftpWebRequest.Method = WebRequestMethods.Ftp.UploadFile;

//-----------------

//user - password

//-----------------

ftpWebRequest.Credentials = new NetworkCredential("user, "password");

//-----------------

// set proxy = null!

//-----------------

ftpWebRequest.Proxy = null;

//-----------------

// Copy the contents of the file to the request stream.

//-----------------

StreamReader sourceStream = new StreamReader(“\\servername\folder\file.name”);

byte[] fileContents = Encoding.UTF8.GetBytes(sourceStream.ReadToEnd());

sourceStream.Close();

ftpWebRequest.ContentLength = fileContents.Length;

//-----------------

// transer the stream stream.

//-----------------

Stream requestStream = ftpWebRequest.GetRequestStream();

requestStream.Write(fileContents, 0, fileContents.Length);

requestStream.Close();

//-----------------

// Look at the response results

//-----------------

FtpWebResponse response = (FtpWebResponse)ftpWebRequest.GetResponse();

Console.WriteLine("Upload File Complete, status {0}", response.StatusDescription);

with Proxy Server

· Windows Command-Line

> ftp proxy.server

> ftp User: User@ftp.target.com

> ftp Password: Password

> ftp put \\servername\folder\file.name

> ftp dir

(result: file.name listed)

> ftp del file.name

> ftp dir

(result: file.name deleted)

> ftp quit

· C#

//-----------------

//Start FTP via _TargetFtpProxy

//-----------------

string relPath = Path.GetFileName(\\servername\folder\file.name);

//result: relPath = “file.name”

FtpWebRequest ftpWebRequest = (FtpWebRequest)WebRequest.Create("ftp://proxy.server/" + relPath);

ftpWebRequest.Method = WebRequestMethods.Ftp.UploadFile;

//-----------------

//user - password

//-----------------

ftpWebRequest.Credentials = new NetworkCredential("user@ftp.target.com, "password");

//-----------------

// set proxy = null!

//-----------------

ftpWebRequest.Proxy = null;

//-----------------

// Copy the contents of the file to the request stream.

//-----------------

StreamReader sourceStream = new StreamReader(“\\servername\folder\file.name”);

byte[] fileContents = Encoding.UTF8.GetBytes(sourceStream.ReadToEnd());

sourceStream.Close();

ftpWebRequest.ContentLength = fileContents.Length;

//-----------------

// transer the stream stream.

//-----------------

Stream requestStream = ftpWebRequest.GetRequestStream();

requestStream.Write(fileContents, 0, fileContents.Length);

requestStream.Close();

//-----------------

// Look at the response results

//-----------------

FtpWebResponse response = (FtpWebResponse)ftpWebRequest.GetResponse();

Console.WriteLine("Upload File Complete, status {0}", response.StatusDescription);

Invalid value for 'OSVersion'

Rodney Vinyard — Fri, 14 Oct 2011 14:30:39 GMT

Invalid value for 'OSVersion'

Thanks to Mike Wade @ Microsoft

I would recommend clearing the environment variable, or better yet, adding the following to the project file:

This will fully override the environment variable and blank it out. The task should then set this to a better default value.

Oracle Dynamic SQL – Drop Table, Copy Table, Purge Tables

Rodney Vinyard — Mon, 10 Oct 2011 19:43:25 GMT

Oracle Dynamic SQL – Drop Table, Copy Table, Purge Tables

CREATEORREPLACEPROCEDURE COMPLIANCE11.table_drop (table_name VARCHAR2) IS
    dml_str VARCHAR2        (500);
BEGIN
    dml_str := 'DROP TABLE ' || table_name ;
    EXECUTEIMMEDIATE dml_str ;
END;

void the_Table_Housekeeping()

{

try

{

string JobDateTime_string = _jobDateTime.ToString("yyyy-MM-dd_HH-mm-ss");

JobDateTime_string = JobDateTime_string.Replace("-", "");

JobDateTime_string = JobDateTime_string.Replace("_", "");

Microsoft_Enterprise_Library.Oracle.OracleAccessLayer objData = new Microsoft_Enterprise_Library.Oracle.OracleAccessLayer();

//-----------------------------------

// look for dupe table before drop table

//-----------------------------------

string ssql = "select nvl((select 1 from user_tables where table_name='THE_" + JobDateTime_string + "' and rownum=1),0) from dual";

DataTable dt = objData.GetDataTableFromOracleSQL(ssql, this._Oracle_Compliance11connectionString);

if (dt.Rows.Count < 1)

{

throw new Exception("dt.Rows.Count < 1");

}

int found = int.Parse(dt.Rows[0][0].ToString());

OracleCommand oracleCommand = new OracleCommand();

if (found == 1)

{

//-----------------------------------

// drop table

//-----------------------------------

oracleCommand.CommandText = "table_Drop";

oracleCommand.Parameters.Clear();

oracleCommand.Parameters.Add("table_name", OracleType.VarChar).Value = "THE_" + JobDateTime_string;

int rowsAffected = objData.GetRowsAffected_From_StoredProc(this._Oracle_Compliance11connectionString,

oracleCommand);

}

//-----------------------------------

// does not work, "insufficient privileges"

//-----------------------------------

//oracleCommand.CommandText = "table_copy";

//oracleCommand.Parameters.Clear();

//oracleCommand.CommandType = CommandType.StoredProcedure;

//oracleCommand.Parameters.Add("table_name_orig", OracleType.VarChar).Value = "THE_Table";

//oracleCommand.Parameters.Add("table_name_new", OracleType.VarChar).Value = "THE_" + JobDateTime_string;

//int rowsAffected2 = objOracle.GetRowsAffected_From_StoredProc_Transaction();

//-----------------------------------

// create table

//-----------------------------------

StringBuilder sb = new StringBuilder();

sb.AppendLine("CREATE TABLE THE_" + JobDateTime_string + " AS (SELECT * FROM THE_Table)");

string mySQL = sb.ToString();

oracleCommand.CommandType = CommandType.Text;

int rowsAffected2 = objData.ExecuteNonQuery_SQL(

mySQL,

this._Oracle_Compliance11connectionString,

false);

//-----------------------------------

// purge to 4 previous copies

//-----------------------------------

sb = new StringBuilder();

ssql = "select table_name from user_tables where table_name LIKE 'THE_2%' order by table_name asc";

dt = objData.GetDataTableFromOracleSQL(ssql, this._Oracle_Compliance11connectionString);

for (int i = 0; i < dt.Rows.Count - 4; i++)

{

string table_name = dt.Rows[i][0].ToString();

//-----------------------------------

// drop table

//-----------------------------------

oracleCommand.CommandText = "table_Drop";

oracleCommand.Parameters.Clear();

oracleCommand.Parameters.Add("table_name", OracleType.VarChar).Value = table_name;

int rowsAffected = objData.GetRowsAffected_From_StoredProc(this._Oracle_Compliance11connectionString,

oracleCommand); ;

}

catch (Exception ex)

{

throw ex;

}

OpenXML SDK 2.0: Export a DataTable to Excel

Rodney Vinyard — Thu, 06 Oct 2011 12:01:29 GMT

OpenXML SDK 2.0: Export a DataTable to Excel

Very good article and download project

http://lateral8.com/articles/2010/3/5/openxml-sdk-20-export-a-datatable-to-excel.aspx

The DocumentFormat.OpenXml.dll is registered in the GAC when the SDK is installed so it doesn't physically copy it to your project's output folder by default when you build the application. If you select the option to Show All Files in Visual Studio (Project | Show All Files), you'll see a References node appear in your VB.NET project in the Solution Explorer. Expand it, select DocumentFormat.OpenXml, view it's properties, and set the Copy Local option to True so that it copies it to the output folder when you build the app. You can then copy it along with the app to any other PC and it will run without having to install the SDK on them.

Debug Web Part installed in GAC

Rodney Vinyard — Wed, 10 Aug 2011 13:52:32 GMT

Debug Web Part installed in GAC

Thanks to Doug Ware @ Elumenotion > Elumenotion Blog > Posts > You Don't Need to Copy PDB Files to Debug in the GAC!

11/12/2007

http://www.elumenotion.com/Blog/Lists/Posts/Post.aspx?ID=23

ASP.NET Detect and alert forms authentication timeout

Rodney Vinyard — Thu, 28 Jul 2011 16:23:45 GMT

ASP.NET Detect and alert forms authentication timeout

With help from & thanks to PsychoCoder at http://www.dreamincode.net/forums/topic/45300-base-page-for-detecting-session-timeout-in-aspnetc%23/

1. Add sessionState to web.config

<system.web>

<sessionStatetimeout="1"mode="InProc" />

2. Add FormsAuthentication to web.config

<authenticationmode="Forms">

<formsloginUrl="~/Forms/Logon.aspx"

defaultUrl="~/Forms/OrderCreate.aspx?TimeOut=True"

protection="All"

timeout="1"

name=".ASPXAUTH"

path="/"

requireSSL="false"

slidingExpiration="true"

cookieless="UseDeviceProfile"

enableCrossAppRedirects="false"/>

</authentication>

3. On Session_Start, detect session timeout and set a “CatchTimeOut” session variable

void Session_Start(object sender, EventArgs e)

{

// Code that runs when a new session is started

// no - Response.Cookies["CoprSession"].Value = ""; //.Expires = DateTime.Now.AddDays(5000);

//This is obviously a new session being created; it can be

//created at the first hit of a user, or when the user

//previous session has expired (timeout). We are only interested

//in the timeout scenario, so we look at the request cookies

//and if we have a previous session ID cookie, it means this is a

//new session due to the timing out of the old one.

//Note: slight problem here: in .Net 2.0 the ASP Session ID

//cookie name is configurable, but we don't have a way to

//retrieve that from the web.config - so if you customize

//the session cookie name in the web.config you'll have to

//use the same name here.

string request_cookies = Request.Headers["Cookie"];

if ((null != request_cookies) &&

(request_cookies.IndexOf("ASP.NET_SessionId") >= 0))

{

//cookie existed, so this new one is due to timeout.

//Redirect the user to the login page

//System.Diagnostics.Debug.WriteLine("Session expired!");

//Response.Redirect(Constants.HOME_PAGE + "?" +

// Constants.PARAM_REQUEST + "=" +

// Constants.PARAM_REQUEST_VALUE_TIMEOUT);

Session[“CatchTimeOut”] = true;

}

4. Create a base page to query the “CatchTimeOut” session variable and do a javascript alert

public class _BasePage : System.Web.UI.Page

{

protected override void OnLoad(EventArgs e)

{

// Be sure to call the base class's OnLoad method!

base.OnLoad(e);

//-----------------------------------------------------------------------

if (Session[“CatchTimeOut”])

{

Session[“CatchTimeOut”] = false;

string strScript = "<script>alert('Your web session timed out.');</script>";

Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "ShowInfo", strScript);

}

5. Inherit base page wherever base behavior is needed

· public partial class LnumberSearch : _BasePage

· {

Capture DataGridView CheckBox Checked event on a WinForm

Rodney Vinyard — Wed, 13 Apr 2011 16:19:29 GMT

Private Sub dgv_CurrentCellDirtyStateChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles dgv.CurrentCellDirtyStateChanged

'--------------------------------------------------------

'when a user checks/unchecks a checkbox

'perform "commitEdit" so that "CellValueChanged" event gets fired

'--------------------------------------------------------

If dgv.IsCurrentCellDirty Then

dgv.CommitEdit(DataGridViewDataErrorContexts.Commit)

End If

End Sub

Private Sub dgv_CellValueChanged(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles dgv.CellValueChanged

'--------------------------------------------------------

'when a user checks/unchecks a checkbox

'be sure to check/uncheck other rows with same session, barcode and assay (but different seq)

'--------------------------------------------------------

Dim checked As Boolean = Boolean.Parse(dgv.CurrentRow.Cells(gCol.PlateIsLabeled).Value.ToString) = True

Dim targetSessionName As String = dgv.CurrentRow.Cells(gCol.SessionName).Value.ToString

Dim targetPlateBarcode As String = dgv.CurrentRow.Cells(gCol.PlateBarcode).Value.ToString

Dim targetAssayName As String = dgv.CurrentRow.Cells(gCol.AssayName).Value.ToString

For Each irow As DataGridViewRow In dgv.Rows

If irow.Index <> dgv.CurrentRow.Index Then

Dim PlateBarcode As String = irow.Cells(gCol.PlateBarcode).Value.ToString

Dim AssayName As String = irow.Cells(gCol.AssayName).Value.ToString

Dim SessionName As String = irow.Cells(gCol.SessionName).Value.ToString

If PlateBarcode = targetPlateBarcode _

And AssayName = targetAssayName _

And SessionName = targetSessionName _

Then

irow.Cells(gCol.PlateIsLabeled).Value = checked

End If

End Sub

Capture DataGridView CheckBox Checked event on a WinForm

ASP.NET Export n GridViews to Excel

Rodney Vinyard — Fri, 25 Mar 2011 18:51:59 GMT

ASP.NET Export n GridViews to Excel

Thanks to awesome article by Matt Berseth

http://mattberseth.com/blog/2007/04/export_gridview_to_excel_1.html

http://forums.asp.net/t/1527194.aspx/1

//Web Page Call to ExcelExport Class

protected void lnkExport_Click(object sender, EventArgs e)

{

//creating the array of GridViews and calling the Export function

GridView[] gvList = new GridView[] { gvPlateList, gvPlateDetails };

ExcelExport.Export("DeliverySheet.xls", gvList);

}

//ExcelExport Class

using System;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

///<summary>

/// Summary description for ExcelExport

///</summary>

public static class ExcelExport

{

public static void Export(string fileName, GridView[] gvs)

{

HttpContext.Current.Response.Clear();

HttpContext.Current.Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", fileName));

HttpContext.Current.Response.ContentType = "application/ms-excel";

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

HtmlTextWriter htw = new HtmlTextWriter(sw);

foreach (GridView gv in gvs)

{

// Create a form to contain the grid

Table table = new Table();

table.GridLines = gv.GridLines;

// add the header row to the table

if (!(gv.HeaderRow == null))

{

PrepareControlForExport(gv.HeaderRow);

table.Rows.Add(gv.HeaderRow);

}

// add each of the data rows to the table

foreach (GridViewRow row in gv.Rows)

{

PrepareControlForExport(row);

table.Rows.Add(row);

}

// add the footer row to the table

if (!(gv.FooterRow == null))

{

PrepareControlForExport(gv.FooterRow);

table.Rows.Add(gv.FooterRow);

}

// render the table into the htmlwriter

table.RenderControl(htw);

}

// render the htmlwriter into the response

HttpContext.Current.Response.Write(sw.ToString());

HttpContext.Current.Response.End();

}

private static void PrepareControlForExport(Control control)

{

for (int i = 0; i < control.Controls.Count; i++)

{

Control current = control.Controls[i];

if (current is LinkButton)

{