Session Security in ASP.NET

http://www.dotnetfunda.com/articles/article730-session-security-in-aspnet-.aspx

Open a Page in a new window from code behind in asp.net

Dim strScript As String = ""
Page.RegisterStartupScript("PopUp", strScript)

Here "filePath " can be a page name like "/Application/folder/default.aspx" or "/Application/folder/mypdffile.pdf".

Remove non-numeric or non-alphameric characters.

This can be used to remove or save any range of characters from a string or field.

declare @s varchar(100), @i int

select @s = 'asd i/.,<>as>[{}]vnbv'
select @s

select @i = patindex('%[^a-zA-Z0-9 ]%', @s)
while @i > 0
begin
select @s = replace(@s, substring(@s, @i, 1), '')
select @i = patindex('%[^a-zA-Z0-9 ]%', @s)
end

select @s


gives
before
asd i/.,<>as>[{}]vnbv
after
asd iasvnbv


Removing the characters from a field in a table


create table #a (s varchar(100))

insert #a (s) select 'asd i/.,<>as>[{}]vnbv'
insert #a (s) select 'aaa'
insert #a (s) select '123 ''h 9)'

select * from #a

while @@rowcount > 0
update  #a
set s = replace(s, substring(s, patindex('%[^a-zA-Z0-9 ]%', s), 1), '')
where patindex('%[^a-zA-Z0-9 ]%', s) <> 0

select * from #a

Gives

before
asd i/.,<>as>[{}]vnbv
aaa
123 'h 9)
after
asd iasvnbv
aaa
123 h 9

Asp.Net page Life Cycle events

If (!IsPostBack)

1. Begin PreInit
2. End PreInit
3. Begin Init
4. End Init
5. Begin InitComplete
6. End InitComplete
7. Begin PreLoad
8. End PreLoad
9. Begin Load
10. End Load
11. Begin LoadComplete
12. End LoadComplete
13. Begin PreRender
14. End PreRender
15. Begin PreRenderComplete
16. End PreRenderComplete
17. Begin SaveState
18. End SaveState
19. Begin SaveStateComplete
20. End SaveStateComplete
21. Begin Render
22. End Render
    

If(IsPostBack)

1. Begin PreInit
2. End PreInit
3. Begin Init
4. End Init
5. Begin InitComplete
6. End InitComplete
7. Begin LoadState
8. End LoadState
9. Begin ProcessPostData
10. End ProcessPostData
11. Begin PreLoad
12. End PreLoad
13. Begin Load
14. End Load
15. Begin ProcessPostData (Again)
16. End ProcessPostData (Again)
17. Begin Raise ChangedEvents
18. End Raise ChangedEvents
19. Begin Raise PostBackEvent
20. End Raise PostBackEvent
21. Begin LoadComplete
22. End LoadComplete
23. Begin PreRender
24. End PreRender
25. Begin PreRenderComplete
26. End PreRenderComplete
27. Begin SaveState
28. End SaveState
29. Begin SaveStateComplete
30. End SaveStateComplete
31. Begin Render
32. End Render

Export to Excel from html

Response.Clear()
Response.Buffer = True
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader("content-disposition", "attachment;filename=MyFiles.xls")
Response.ContentEncoding = System.Text.Encoding.Unicode
Response.BinaryWrite(System.Text.Encoding.Unicode.GetPreamble())
Me.EnableViewState = False
Response.Write(Session("Str"))
Response.End()