dwight rau

Reflection to pull description attribute for class

2011-01-28T10:35:00.003-05:00

//get description from attribute on class
private static string GetDescription(Type type)
{
  return (from v in type.GetCustomAttributes( typeof(System.ComponentModel.DescriptionAttribute), true)
  select ((System.ComponentModel.DescriptionAttribute)v).Description).FirstOrDefault();
}

[Description("Users description!")]
public class MyClass
{
}

Taxonomy of Fallacies

2010-11-05T14:17:00.002-04:00

taxonomy of logical fallacies

sql server database size report

2010-06-03T17:14:00.001-04:00

SELECT * INTO #T1 FROM sys.sysfiles;
DELETE FROM #T1;
EXECUTE sp_msforeachdb 'INSERT INTO #T1 SELECT * from ?.sys.sysfiles'

select ( size * 0.00000762939453125 )as SizeGB , * from #t1
order by size desc

Microsoft Video Link Collection

2010-05-24T17:28:00.002-04:00

Silverlight
http://silverlight.net/learn
http://www.silverlight.net/learn/videos/all/

ASP + AJAX + MVC
http://asp.net/learn
http://www.asp.net/ajax/videos
http://www.asp.net/mvc/videos
http://www.asp.net/web-forms

Winform
http://windowsclient.net/learn
http://windowsclient.net/learn/videos.aspx

The rest of the How do I?
http://msdn.microsoft.com/en-us/bb629407.aspx

Missing Index for SQL Server for slow performance

2010-04-13T16:08:00.004-04:00

This query will script indexes create statements when you have slow performance with SQL server. After applying the indexes you should see some improvement. SQL Server keeps an internal list of indexes it believe that you should create to speed things up and this query will show them to you. This is not as thorough / accurate as using the Index Tuning Wizard and you do not know how large the indexes will be. The scripts with the highest improvement_measure should be tested first because you would see the most benefit. The tables that hold the recommended indexes are cleared every time you restart SQL server and are not populated until you use put a load on the database. If you do not see a query improve in speed after testing the index, it may still be improving but you did not notice. Check to see if the CPU / Memory/ Disk usage usage was reduced. I recommend adding this view to your database and selecting from it from time to time to see what shows up.

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create view [dbo].[usp_Missing_Indexes] as

select * from
(
SELECT
'CREATE INDEX [experimental_index_' + CONVERT (varchar, missingGroups.index_group_handle) + '_' + CONVERT (varchar, mid.index_handle)
+ '_' + LEFT (PARSENAME(mid.statement, 1), 32) + ']'
+ ' ON ' + mid.statement
+ ' (' + ISNULL (mid.equality_columns,'')
+ CASE WHEN mid.equality_columns IS NOT NULL AND mid.inequality_columns IS NOT NULL THEN ',' ELSE '' END
+ ISNULL (mid.inequality_columns, '')
+ ')'
+ ISNULL (' INCLUDE (' + mid.included_columns + ')', '') AS create_index_statement,
stats.avg_total_user_cost * stats.avg_user_impact * (stats.user_seeks + stats.user_scans) as BenefitWeight,
stats.avg_total_user_cost * (stats.avg_user_impact / 100.0) * (stats.user_seeks + stats.user_scans) AS improvement_measure,
stats.unique_compiles,
stats.user_seeks + stats.user_scans as SeeksScans,
stats.last_user_seek,
stats.last_user_scan

FROM sys.dm_db_missing_index_groups missingGroups
INNER JOIN sys.dm_db_missing_index_group_stats stats ON stats.group_handle = missingGroups.index_group_handle
INNER JOIN sys.dm_db_missing_index_details mid ON missingGroups.index_handle = mid.index_handle
) a
where improvement_measure > 100
--order by BenefitsWeight

idempotent

2010-02-25T11:02:00.000-05:00

idempotent definition - computer

Refers to an operation that produces the same results no matter how many times it is performed. For example, if a request to delete a file is successfully completed for one program, all subsequent requests to delete that file from other programs would return the same success confirmation message if the delete function were idempotent. In a function that is not idempotent, an error would be returned for the second and subsequent requests indicating that the file was not there, and that error condition might cause the program to halt. If all that were desired was to ensure a certain file was deleted, an idempotent delete function would return the same success result no matter how many times it was executed for the same file. (dictionary.com)

SQL Server select data from CSV as if it were a table

2009-09-24T13:13:00.002-04:00

I can select without using DTS or a linked server.

SELECT * FROM OPENROWSET
('MICROSOFT.JET.OLEDB.4.0','Text;Database=C:\Folder\;',
'SELECT * FROM [Report.csv]') MyAlias

You may need these permissions
sp_configure 'Ad Hoc Distributed Queries', 1
reconfigure

You may have problems on X64

Linq: Split string array and convert into integer using a converter / lambda and then selecting where in or contains from that list

2008-10-09T17:02:00.000-04:00

// This will split an CSV string array into an array of integers
int[] intArr = Array.ConvertAll( priorityCsv.Split(','), n => Convert.ToInt32(n) );

//This will select the count of values where there are in or contain the values in the array
return (from v in this.Context.VACompanyErrors where intArr.Contains(v.Priority) select v).Count();

fill text box with nullable type or empty

2008-05-20T16:44:00.001-04:00

fill text box with nullable type or empty
txtExpectedCloseDateTextBox.Text = olo.ExpectedCloseDate.ToString() ?? string.Empty;

iterate

2008-04-25T15:17:00.000-04:00

list.ForEach(delegate(MyType x) { x.Property1.Replace("AAAA", "").Replace("BBBB", ""); });
OneType one = OneTypeList.Find(delegate(OneType ooo) { return oood.Value == "findstring; });

table with infinite dynamically expandable columns veritcal rows propertes attributes eav otlt

2008-02-13T02:34:00.004-05:00

If you need to have a table with attributes(columns) that need to be added dynamically, consider going vertically. There are various methods to add attributes to an entity by adding the attributes as rows.

you may be looking for these (Google them):

Entity-Attribute-Value model
“OTLT” (One True Lookup Table)
vertical model
vertical database
row modeling
attribute value system
sql_variant

Think deeply before you use any of these. Be careful you don't end up with a mess.
Resources:

Dave’s guide to the EAV

OTLT and EAV: the two big design mistakes all beginners make

Entity-Attribute-Value (EAV) model with SQL Server 2005 xml datatype

An Introduction to Entity-Attribute-Value Design for Generic Clinical Study Data Management Systems

Entity-Attribute-Value model

Explanation of many database models including EAV

-Dwight

Generate or create XSD Schema from Database Table in sql server 2005

2008-02-13T02:09:00.000-05:00

create table Person
(
Age int not NULL check( Age > 0) ,
Height numeric(10,2) not NULL check( Height > 5),
Gender varchar(5) not null check( Gender in ('M', 'F', 'O')),
BirthDate datetime null,
)
DECLARE @schema xml
SET @schema = (SELECT * FROM Person FOR XML AUTO, ELEMENTS, XMLSCHEMA('PersonSchema'))
select @schema
OUTPUT:

identify system service 100% cpu svchost.exe

2008-01-25T13:35:00.000-05:00

Which system service is causing svchost.exe to use 100% cpu value?

First lookup the PID (process identifier) number in task manager that is causing the problem. You may have to tell task manager to add the column.

This command will allow you to identify the problem service by showing what each svchost.exe PID is running.

C:\>tasklist /SVC /FI "IMAGENAME eq svchost.exe"

In vista you can right your problem process click and choose "go to service".

Pattern Links

2007-12-28T12:56:00.000-05:00

dofactory design patterns
http://www.dofactory.com/Patterns/Patterns.aspx

A short summary of the patterns in Patterns of Enterprise Application Architecture (P of EAA).
http://www.martinfowler.com/eaaCatalog/

WCF permission problem

2007-12-12T00:36:00.000-05:00

In windows (likely to be vista) where you do not have acccess to register an http listener with WCF..

"HTTP could not register URL http://+:8080/QuickReturns/. Your process does not have access rights to this namespace (see http://go.microsoft.com/fwlink/?LinkId=70353 for details)."

{"Access is denied"}

as admin run:
netsh http add urlacl url=http://+:8080/ user=dwight

Web Parts with SQL Server 2005 instead of sql express for testing

2007-10-12T00:07:00.000-04:00

try this:

connectionString="data source=VRTSVR04;Initial Catalog=DemoPortal;User Id=sa2;Password=di902jkd89x88-1;"
providerName="System.Data.SqlClient"/>

keywords: connection string default The entry 'LocalSqlServer' has already been added. aspnetdb

Generate XSD Schema From XML using inference

2007-10-05T01:36:00.000-04:00

Upload an xml file and we will return you the schema as an XSD file. This is called Inferring the schema. This uses the .Net InferSchema method of the XmlSchemaInference class. Create an XML file given an XSD.

windows workflow custom activity values not persisting check results after exectution property System.Workflow.ComponentModel.Activity

2007-08-15T11:31:00.000-04:00

If you are having trouble retrieving the results of a custom activity that inherits activity in windows workflow and your value is null or reset to the default, try a property to a static variable.

Extract columns from microsoft SqlProfileProvider

2007-06-29T21:17:00.000-04:00

If you want to select data from the asp.net membership api database but you are having problems because the PropertyValuesString / PropertyNames / PropertyValuesBinary values are all delimited / separated by a colon but you want to but cant use a split function on it. Below is a solution. There are also UserId LastUpdatedDate columns.

Step 1. Execute the sql from HERE to create some functions to extract your data.
Step 2. Create a view like the example below
Step 3. (optional) index your view.

create my_cusomers_vw view as
SELECT
dbo.fn_GetProfileElement('Phone',PropertyNames,PropertyValuesString) AS Company,
dbo.fn_GetProfileElement('ZipCode',PropertyNames,PropertyValuesString) AS ZipCode,
dbo.fn_GetProfileElement('State',PropertyNames,PropertyValuesString) AS State
FROM dbo.aspnet_Profile
GO

select * from my_customers_vw

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

fn_GetElement fn_GetProfileElement FUNCTION

UML Cheet Sheet

2007-05-08T17:07:00.000-04:00

Cheat Sheet 1

Cheat Sheet 2

Asp.net 2.0 Post Retrieve Send values from another page using PostBackUrl

2007-02-28T10:28:00.000-05:00

Various techniques including Page.PreviousPage.FindControl, PreviousPage, Request.Form

This is how you can post from one page to another
How to: Post ASP.NET Web Pages to a Different Page

This is different ways you can read data posted from one page to another
How to: Pass Values Between ASP.NET Web Pages

C# Web Crawler for links

2006-12-25T00:46:00.000-05:00

This code will crawl a web page and gather urls (hyperlinks) and their titles into collections and bind them to a datagrid. The code uses Regular Expressions (Regex), HttpWebRequest, WebRequest, WebResponse and more.

View original source code here

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Text.RegularExpressions;
using System.Collections.ObjectModel;
using System.Net;

namespace Regexer
{
public partial class Form1 : Form
{
public Form1()

{
InitializeComponent();
}

private string Fixx(string x)
{
return x.Replace(""", @"""").Replace(">", ">").Replace("<", "<");
}

private void button1_Click(object sender, EventArgs e)

{
//string testData = ReadStream("http://www.google.com/search?as_q=test+results&hl=en&num=100&btnG=Google+Search", 9000);

string testData = ReadStream("http://del.icio.us/", 99000);

Regex test = new Regex(Fixx(@"<[aA][\s]+[^>]*?[hH][rR][eE][fF][\s]?=[\s\"\']+(.*?)[\"\']+.*?>([^<]+|.*?)?<\/[aA]>";));
//The regex on the above line will be mangled, click the image below to see what it should be.

MatchCollection mc = test.Matches(testData);
Collection<UrlData> uColl = new Collection<UrlData>();

foreach (Match mt in mc)

{
UrlData url = new UrlData();
url.Url = mt.Groups[1].Value;
url.Title = mt.Groups[2].Value;
uColl.Add(url);
}

dataGridView1.DataSource = uColl;
dataGridView1.AutoResizeColumn(1);
}

public static string ReadStream(string url, int timeOut)
{
String result;
WebResponse objResponse;
WebRequest objRequest = System.Net.HttpWebRequest.Create(url);
objRequest.Timeout = timeOut;

objResponse = objRequest.GetResponse();

using (System.IO.StreamReader sr =
new System.IO.StreamReader(objResponse.GetResponseStream()))
{
result = sr.ReadToEnd();
sr.Close();
}
return result;
}
}

public class UrlData
{
private string url = null;
private string title = null;

public string Url
{
get { return url; }

set { url = value; }
}

public string Title
{
get { return title; }
set { title = value; }
}
}

}

Verisign PayFlow Authentication ECI XID CAVV values Example

2006-07-20T17:26:00.000-04:00

I am sending orders to verisign payflow pro and i am using a third party for
additional "Buyer authentication". The third party sends certain response values
back to me to include in my order request to verisign to decide if the order
is fraudulent or not. They work along with MasterCard secure code and
verified by visa. The upside to this is that if they say the order is okay
then the merchant is not libel for the fraud and they lose no money.
We are using XMLPay document to send our messages to verisign and i want to include
this information i have recieved from the third party.
It is unclear in the XMLPay spec where to insert this information.
I do see examples where to insert the ECI, XID, CAVV values in many other
manuals but they only show examples in a string format instead of an xml format.
I found a quote below in a manual but this was no help.

Special Note for XMLPay users

For Call 4 on page 42, pass AUTHENTICATION_STATUS=,

AUTHENTICATION_ID=, CAVV=, and XID=,

ECI= in the ExtData for Authorization and Sale transactions.

This was not correct. I also emailed verisign and they only responded
with another copy of the manual.

Here is an example document of the correct place to insert these.


/*
<ns0:XMLPayRequest Timeout="60" version="2.0" xmlns:ns0="http://www.verisign.com/XMLPay">
<RequestData>
<Vendor>myvendor</Vendor>
<Partner>verisign</Partner>
<Transactions>
  <Transaction Id="GPECAWJ4AG358HAF35RXK55A87" CustRef="myname@myaddr.com">
    <Authorization>
      <PayData>
        <Invoice>
          <Date>2006-07-05</Date>
          <BillTo>
            <Name>first last</Name>
            <Address>
              <Street>7600 Main Street</Street>
              <Street2></Street2>
              <City>Boaz</City>
              <State>VA</State>
              <Zip>12345</Zip>
              <Country>US</Country>
            </Address>
            <EMail>test2user@email.com</EMail>
          </BillTo>
          <ShipTo>
            <Name>first last</Name>
            <Address>
              <Street>7600 My Street</Street>
              <Street2></Street2>
              <City>Boaz</City>
              <State>VA</State>
              <Zip>21222</Zip>
              <Country>US</Country>
            </Address>
          </ShipTo>
          <TotalAmt>531.75</TotalAmt>
          <Comment>1093293</Comment>
          <CustIP>10.0.30.208</CustIP>
          <Items>
            <Item>
              <SKU>TELE101032</SKU>
              <Quantity>1</Quantity>
              <TotalAmt>495</TotalAmt>
            </Item>
            <Item>
              <SKU>TELE101322</SKU>
              <Quantity>1</Quantity>
              <TotalAmt>203.00</TotalAmt>
            </Item>
          </Items>
          <ExtData Name="COMMENT2" Value="1PECFWJ4Aq358HAF35XRK55A87"></ExtData>
        </Invoice>
        <Tender>
          <Card>
            <CardType>Visa</CardType>
            <CardNum encrypt="1">qFS+dZ9kEi/sCCPe288eB</CardNum>
            <ExpDate encrypt="1">E3V1BuHDhEBCzEvHURwB92zWjfJc2+rC</ExpDate>
            <CVNum encrypt="1">Kd762lK+2HAkxiRrNK7JCA==</CVNum>
            <NameOnCard>My Name</NameOnCard>
          </Card>
        </Tender>
      </PayData>
      <ExtData>
        <CAVV>AAABBEKQkQAAeAABEo3RENiWiVM=</CAVV>
        <XID>v73iqKAE/sM4Z2rX8qSCfMDavt4=</XID>
        <ECI>05</ECI>
        <STATUS>Y</STATUS>
      </ExtData>
    </Authorization>
    <Verbosity>Medium</Verbosity>
    <BrowserUserAgent>Mozilla/4.0 </BrowserUserAgent>
  </Transaction>
</Transactions>
</RequestData>
<RequestAuth>
<UserPass>
  <User>testUser10293</User>
  <Password>password09209320931</Password>
</UserPass>
</RequestAuth>
</ns0:XMLPayRequest>

*/

2006-07-20T16:45:00.000-04:00

Sql T-Sql Sql server 2000 select or show distinct rows by column instead of the entire row. In this case it only shows the latest by date. 2 examples are provided. Thanks to Steve Hamilton.


/*
CREATE TABLE #TestTable( ID INT, TEST VARCHAR(50), TEST2 VARCHAR(50), TEST3 DATETIME )

INSERT INTO #TestTable VALUES ( 1, 'A', 'A', GETDATE() + 0 )
INSERT INTO #TestTable VALUES  ( 2, 'A', 'B', GETDATE() + 1 )
INSERT INTO #TestTable VALUES ( 3, 'A', 'C', GETDATE() + 2 )
INSERT INTO #TestTable VALUES ( 4, 'A', 'D', GETDATE() + 3 )
INSERT INTO #TestTable VALUES ( 5, 'B', 'A', GETDATE() + 4 )
INSERT INTO #TestTable VALUES ( 6, 'B', 'B', GETDATE() + 5 )
INSERT INTO #TestTable VALUES ( 7, 'B', 'C', GETDATE() + 6 )
INSERT INTO #TestTable VALUES ( 8, 'B', 'D', GETDATE() + 7 )
INSERT INTO #TestTable VALUES ( 9, 'C', 'A', GETDATE() + 8 )
INSERT INTO #TestTable VALUES ( 10, 'C', 'B', GETDATE() + 9 )
INSERT INTO #TestTable VALUES ( 11, 'C', 'C', GETDATE() + 10 )
INSERT INTO #TestTable VALUES ( 12, 'C', 'D', GETDATE() + 11 )
INSERT INTO #TestTable VALUES ( 13, 'D', 'A', GETDATE() + 12 )
INSERT INTO #TestTable VALUES ( 14, 'D', 'B', GETDATE() + 13 )
INSERT INTO #TestTable VALUES ( 15, 'D', 'C', GETDATE() + 14 )
INSERT INTO #TestTable VALUES ( 16, 'D', 'D', GETDATE() + 15 )

SELECT DISTINCT *
FROM #TestTable T
  INNER JOIN 
  (
   SELECT ID
   FROM #TestTable T3
   WHERE T3.TEST3 = (SELECT MAX(TEST3) FROM #TestTable T4 WHERE T3.TEST = T4.TEST)
  ) T2
  ON T2.ID = T.ID

SELECT * FROM #TestTable t 
WHERE T.TEST3 = (SELECT MAX(TEST3) FROM #TestTable T2 WHERE T2.TEST = T.TEST)

DROP TABLE #TestTable
*/

Hello

2006-07-03T22:41:00.000-04:00

I put this page here to post my code in hopes it might be useful to other people. Some of the sentences may appear awkward either because i cant type or because i typed it easiest for google to index and people to find.

wrt54g v5 qos does not appear to be working broken

2006-05-08T18:56:00.000-04:00

if you have the wrt54g router, and your using it with a voip service such as vonage or sun rocket, you may need to tune the QOS settings in the router in order to avoid being cut off or to have choppy distorted sounds. this qos will make sure that the router will do its best to give the most bandwidth to voice instead of data. the problem i had with the router was that the QOS (quality of service) does not appear to work correctly when using wireless. if your not using any wireless devices, it appears to work correctly. im not 100% sure but i believe you can have this working correctly by putting the mac address of the wireless device and setting it to low, and by setting the port number of the gizmo or voip device to high. note that the wireless device is only found by mac, and if you dont give it a priority, i think it defaults to high. the only problem with this, is that the default firmware on the device will only allow you to put two different devices at low priority. so if you have more than two wireless devices your screwed. someone on another site said to put the only the mac address of the gizmo instead and set that to highest priority, and not to use the other spot but it didn't appear to work for me, but you try it. if you are willing to upgrade your box to a better firmware that is better, check out here
to see if your box is upgradeable.

convert a dataview to a dataset dataview to datatable

2006-03-16T16:58:00.000-05:00

public static DataTable DataViewAsDataTable( DataView dv)
{
DataTable dt = dv.Table.Clone();
foreach (DataRowView drv in dv)
dt.ImportRow(drv.Row);
return dt;
}

DataSet dsFiltered = new DataSet(); //create a new dataset
dsFiltered.Tables.Add(AppUtil.DataViewAsDataTable (dvResult) ); //fill the dataset with the sorted results

convert a dataview to a dataset dataview to datatable

2006-03-16T16:56:00.000-05:00

public static DataTable DataViewAsDataTable( DataView dv)
{
DataTable dt = dv.Table.Clone();
foreach (DataRowView drv in dv)
dt.ImportRow(drv.Row);
return dt;
}

Comerce server 2002 pup packaging problem Error finding IIS object

2006-03-01T11:47:00.000-05:00

If you have this problem with commerce server 2002 when creating a pup package with the site packager:

Error finding IIS object for site:Automation error
The system cannot find the path specified.
Error finding directory for site 0:There is no entry in IIS for this
application on this machine.

Try this:

Go into the properties for the web site and go to the "Home Directory" tab and click "Remove" under application settings and click "Create." Make sure your app pool is correct.
ALSO repeat the same for your virtual directory.
Run this in this in the MSCS_Admin database
SELECT s_PropertyName, s_value FROM ResourceProps WHERE s_PropertyName ='s_WebServerInstance'
If the value of WebServerInstace has a trailing zero, remove the zero
In commerce center manager go here: Server manager -> Commerce Sites -> Your Site -> Applications -> IIS Site Name and verify your host name and IIS application path are correct. This is probably correcy but check it anyways. Next, click the web servers tab, and make sure your IIS web site is correct and click Synchronize. The odds are your IIS web site was not correct.
Run iisreset and package again.

The biggest problem I see people explainin wrong in newsgroups is you need to do step 1 and 2 both.

Area code lookup

2006-02-14T13:55:00.000-05:00

Search for an area codes and get the telephone company, and approximate GPS coordiantes of where a cell phone was purchased. This is great for looking up cell phones that called you. you can also lookup various other forms of information.

http://www.areacodedownload.com/

I personally just edit the url to lookup locations
http://www.areacodedownload.com/410/247/

bill gates got hit with a pie

2006-02-09T15:24:00.000-05:00

does anyone remember this when bill gates got hit with a pie?

Differences and new features in visual studo 2005 instead of visual studio 2003

2006-02-07T22:50:00.000-05:00

Want to catch up on visual studio 2005 ? There is a good downloadable issue (free tutorial) of msdn magazine dedicated to the differences and new features in asp.net 2.0, C# 2.0 and win forms and visual studio 2005 (not asp.net 1.1 or visual studio 2003) so that you can quickly catch up. It goes over all the controls, how to use them, and a summary of just about all the features. [HERE] is a downloadable pdf (24mb) and [HERE] is the issue on the site. Some newest features are the gridview contol, generics, type safe collections, data source control, more.

Statistics

2006-02-06T14:51:00.000-05:00

Here are some interesting statistics (stats)

Gasoline Prices (per litre)

#1	Uruguay	1.95
#2	United Kingdom	1.92

#102

United States

0.77

#140

Iraq

0.05

Growth Rate

Afghanistan

4.77%

#130

United States

0.92%

#234

Bulgaria

-0.89%

Longest Living

#1	Andorra	83.49 years
#2	Macau	81.87 years
#3	San Marino	81.43 years
#4	Japan	80.93 years
#5	Singapore	80.42 years
#6	Australia	80.13 years

#48

United States

77.14 years

#218

Zimbabwe

39.01 years

#224

Mozambique

31.3 years

Car thefts

#1	United States	1,147,300
#2	United Kingdom	338,796
#3	Japan	309,638

Most murders

Rank	Country	Amount (top to bottom)
#1	India	37,170
#2	Russia	28,904
#3	Colombia	26,539
#4	South Africa	21,995
#5	Mexico	13,829
#6	United States	12,658

Murders (per capita)

#1	Colombia	0.617847 per 1,000 people
#2	South Africa	0.496008 per 1,000 people
#3	Jamaica	0.324196 per 1,000 people
#4	Venezuela	0.316138 per 1,000 people

http://www.nationmaster.com/statistics/stats

ASP.NET 2.0 Page LifeCycle

2006-02-03T12:18:00.000-05:00

Note for self: Application, Page and Control events in ASP.NET v2.0

Application: BeginRequest
Application: PreAuthenticateRequest
Application: AuthenticateRequest
Application: PostAuthenticateRequest
Application: PreAuthorizeRequest
Application: AuthorizeRequest
Application: PostAuthorizeRequest
Application: PreResolveRequestCache
Application: ResolveRequestCache
Application: PostResolveRequestCache
Application: PreMapRequestHandler
Page: Construct
Application: PostMapRequestHandler
Application: PreAcquireRequestState
Application: AcquireRequestState
Application: PostAcquireRequestState
Application: PreRequestHandlerExecute
Page: AddParsedSubObject
Page: CreateControlCollection
Page: AddedControl
Page: AddParsedSubObject
Page: AddedControl
Page: ResolveAdapter
Page: DeterminePostBackMode
Page: PreInit
Control: ResolveAdapter
Control: Init
Control: TrackViewState
Page: Init
Page: TrackViewState
Page: InitComplete
Page: LoadPageStateFromPersistenceMedium
Control: LoadViewState
Page: EnsureChildControls
Page: CreateChildControls
Page: PreLoad
Page: Load
Control: DataBind
Control: Load
Page: EnsureChildControls
Page: LoadComplete
Page: EnsureChildControls
Page: PreRender
Control: EnsureChildControls
Control: PreRender
Page: PreRenderComplete
Page: SaveViewState
Control: SaveViewState
Page: SaveViewState
Control: SaveViewState
Page: SavePageStateToPersistenceMedium
Page: SaveStateComplete
Page: CreateHtmlTextWriter
Page: RenderControl
Page: Render
Page: RenderChildren
Control: RenderControl
Page: VerifyRenderingInServerForm
Page: CreateHtmlTextWriter
Control: Unload
Control: Dispose
Page: Unload
Page: Dispose
Application: PostRequestHandlerExecute
Application: PreReleaseRequestState
Application: ReleaseRequestState
Application: PostReleaseRequestState
Application: PreUpdateRequestCache
Application: UpdateRequestCache
Application: PostUpdateRequestCache
Application: EndRequest
Application: PreSendRequestHeaders
Application: PreSendRequestContent

Quoted from here

Another list here

Heavy metal party

2006-02-02T23:37:00.000-05:00

Wow, this is my kinda party! I need a career as a dance instructor.

Never disturb a gamer or get hurt badly.

2006-02-02T02:27:00.000-05:00

Check out this video and see what happens to this guy after he teases a gamer.

Hacking / Sploit video

2006-01-31T13:15:00.000-05:00

Heres a collection of hacks / exploit videos ive collected from around the web. These are real hacks that work. Some are exciting and have cool music, others are boring, slow but very detailed.

This one is a basic mysql injection attack on a php, then they eventually get all info and root access.

Here they use a IIS frontpage exploit,upload ssh client to ssh into at any later time
shell, nmap, metaspoit, iis exploit, ssh exploits, alot more

Here they use kismac to crack wireless encryption.

Here is a basic bluetooth hack

Here is sql injection of helpdesk software, done in url of browser then uses tools bsqlbf, very detailed, very slow

Here is a long video (tv show?) with rad music for beginners, hacking, not a bad show.

links from
http://reversing.org/
http://milw0rm.com
www.thebroken.org
www.ethicalhack.org

A Vrey Inetersting Stroy

2006-01-23T23:17:00.000-05:00

Aoccdrnig to a rscheearch at an Elingsh uinervtisy, it deosn't mttaer in waht oredr the ltteers in a wrod are, the olny iprmoetnt tihng is taht frist and lsat ltteer is at the rghit pclae. The rset can be a toatl mses and you can sitll raed it wouthit porbelm. Tihs is bcuseae we do not raed ervey lteter by itslef but the wrod as a wlohe.

Where did this come from?

http://www.snopes.com/language/apocryph/cambridge.asp

Web 2.0

2006-01-19T13:30:00.000-05:00

Nobody has been able to clearly define web 2.0. It sounds more like a markeiting buzzword, but its meaning hasnt quite been established. To me it sounds like the usage of various resources on the web as a platform.

I think this sums it up.
[Link from oreilly]

Web 2.0 is the era when people have come to realize that it's not the software that enables the web that matters so much as the services that are delivered over the web. Web 1.0 was the era when people could think that Netscape (a software company) was the contender for the computer industry crown; Web 2.0 is the era when people are recognizing that leadership in the computer industry has passed from traditional software companies to a new kind of internet service company. The net has replaced the PC as the platform that matters, just as the PC replaced the mainframe and minicomputer.

Here is an example.
[Link from oreilly]

This article is an attempt to clarify just what we mean by Web 2.0.In our initial brainstorming, we formulated our sense of Web 2.0 by example:
Web 1.0 Web 2.0
DoubleClick --> Google AdSense
Ofoto --> Flickr
Akamai --> BitTorrent
mp3.com --> Napster
Britannica Online --> Wikipedia
personal websites --> blogging
evite --> upcoming.org and EVDB
domain name speculation --> search engine optimization
page views --> cost per click
screen scraping --> web services
publishing --> participation
content management systems --> wikis
directories (taxonomy) --> tagging ("folksonomy")
stickiness --> syndication

An finally a picture.
[An Image From oreilly] (click to see)

Hope this helps.
-Dwight

Microsoft .Net / C# gaining popularity over java

2006-01-13T03:02:00.000-05:00

Looks like C# and microsoft technologies is gaining ground over java according to these two aricles.

According to this first is ComputerWorld Article

"Microsoft's C# beat out Java as the preferred programming language in a recent developer survey conducted by Computerworld."

"Top 5 programming languages reported in use by respondents
C# 72%
Java 66%
VB 62%
C++ 54%
Javascript/... 50%"

According to this article at dedasys , it says the mean cost per click for an advertisement for c# is is $2.8 per click where java is at $0.75 per click.

Both are interesting reads.

msde cant remotely connect with enterprise manager

2006-01-13T00:35:00.000-05:00

if your having problem connecting to a remote msde 2000 with enterprise manager, you need to do this.

Execute this program
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\SVRNETCN.exe
and enable tcpip

now you can connect with windows authentication.
If you want mixed mode authentication, do this
osql -U sa
and type
sp_password null, 'mynewpassword', 'sa'

go

Credit card offers opt out

2005-11-21T00:50:00.000-05:00

I really hate credit card offers, do you? They clutter your mailbox and home. Do you want to get rid of them? Ill show you how to get rid of them, why I trust this method and how effective this really is based on my own experience. Currently I get about 3 per day. That's over 18 per week. I have to open every offer because I am not sure if its a legitimate letter. I suppose I am in a certain age range or fit a certain profile to get this many offers. I always put it off but I am finally putting a stop to this now so i can save some valuble time. I found this [site] run by the three credit bureaus that will allow you to opt out. Warning, it does want your social security number and other personal information, but they [the bureaus] have it anyways. I have seen many people complain this is a scammer / phishing site. I know its is legit because I learned about on this government [site ] and others. I felt confident and I trusted them will all my personal info and I gave it to them. Does it really work? I signed up and here is my results.

One Week before signing up - 19 offers
Week two after signing up - 20 offers
Week three after signing up - 15 offers
Week four after signing up - 8 offers
Week five after signing up - 2 offers
Week six after signing up - 1 offer
Week seven after signing up - 1 offer

Apparently it works! This saves me about 10 minutes a week or 8.6 hours a year or 2 weeks of my life.

-Dwight

change dotnetnuke folder installation path rename

2005-11-17T01:18:00.000-05:00

1. install dotnetnuke to default as normal.
2. rename your folder to your new name.
3. exit your solution and iisreset.
3. delete your old virtual root and create a new virtual root pointing to that name
4. edit DotNetNuke.sln. On the second line you'll see "http://localhost/DotNetNuke/DotNetNuke.vbproj". Change the URL to your location, ie: "http://localhost/NewPage/DotNetNuke.vbproj"
5. edit DotNetNuke.vbproj.webinfo. On the second line make the same change.
6. Start your soluton, it should load fine.
7. If dotnetnuke redirects you to the old site after explorer tries the old site do 8 and 9
8. exec GetPortalAliasByPortalID 0 to see your aliases
9. use your judgement using something like exec UpdatePortalAlias 1, 0, 'localhost/NewPage'

visual studio debugging and other problems

2005-11-17T00:02:00.000-05:00

unable to start debugger

exit VS
debug=true in the web config file
iisreset
delete contents of C:\Documents and Settings\[USER]\VSWebCache
delete contents of C:\WINDOWS\Microsoft.NET\Framework\[FRAMEWORKVERSION]\Temporary ASP.NET Files
Just set your web app up in IIS as a virtual web app: Go to control panel, administrative services, Internet Information Services (IIS)
In explorer change zone settings to Automatic Logon With Password (sometimes u need this)
reboot

Asp.net 2.0 Visual Studio 2005 permissions problem

2005-11-15T00:18:00.000-05:00

If you get the error below when using asp.net 2.0, check your file permissions on your folder and files contained within. I had this problem with .net nuke dot net nuke 3.0 with visual studio 2005. I wish it just told me there was a permissions problem. I found out by the event log.

Unable to start debugging on the web server. Server Unavailable
Server Application Unavailable
The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request.
An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur.
Make sure the server is operating correctly. Verify there are no syntax errors in web.config by doing a Debug.Start Without Debugging. You may also want to refer to the ASP.NET and ATL Server debugging topic in the online documentation.

Sql Server DTS Error Problem

2005-10-07T00:06:00.000-04:00

If you get an error similar to this "cannot insert the value null into column" X "table" Y "column does not allow nulls" "insert fails" ive notices 2 common problems. This is common in sql server when importing data into your database.
1. Do not map or associate data in any way to any identity column. skip it.
2. On your transformation, go to the options and uncheck "Enable Identity Insert".

Remote desktop console

2005-08-13T16:51:00.000-04:00

If you want a saved ( rdp ) remote desktop connection file to always automatically connect to the console, save your configuration file and put this as the last line "connect to console:i:1" without the quotes and with the spaces. Keywords: Remote desktop Connect To Console server.

Using reflection to access private data

2005-07-24T23:48:00.000-04:00

One day I ordered an expensive SDK to use additional functionality with previously purchased application. I was promised I could access certain additional features. This was not true. The method we needed to use was private.No big deal. Using reflection, we can see / view / access a private member, private variable, private method. You can also call a private method of another class. This is great to take a peek at some private data for the curious. Some people may say this is not a solution, dangerous, and also complain your messing up the laws of encapsulation. It worked for me. Here is an example that may help you. Take special note of the ORed bindingflags NonPublic and Instance because you wont find the private methods without them.

This is also useful for unit testing private methods.


using System;
using System.Reflection;
public class PrivateReflection
{
 public static int Main()
 {
   ClassA a = new ClassA();
   Console.WriteLine("before:" + readPrivateVar(a));
   changePrivateVar(a, "I am changed!");
   Console.WriteLine("after:" + readPrivateVar(a));
   Console.WriteLine("executing:" + execPrivMethod(a, "haxx0red", 1234));
   return 0;
 }
 public static string readPrivateVar(ClassA a)
 {
   Type t = Type.GetType("ClassA");
   FieldInfo Myfieldinfoa = t.GetField("privateString",
   BindingFlags.NonPublic | BindingFlags.Instance);
   return (string)Myfieldinfoa.GetValue(a);
 }
 public static void changePrivateVar(ClassA a, string ChangeTo)
 {
   Type t = a.GetType();
   FieldInfo f = t.GetField("privateString",
   BindingFlags.NonPublic | BindingFlags.Instance);
   f.SetValue(a, ChangeTo);
 }
 public static string execPrivMethod(ClassA a, string str, int integ)
 {
   Type t = a.GetType();
   Object[] paramz =  { str, integ };
   MethodInfo m = t.GetMethod("privateCalculation",
   BindingFlags.NonPublic | BindingFlags.Instance);
   return (string)m.Invoke(a, paramz);
 }
}
public class ClassA
{
 private string privateString = "I am a private string.";
 private string privateCalculation(string x, int y)
 {
   return x + "SECRET" + y.ToString();
 }
}

Result:
before:I am a private string.
after:I am changed!
executing:haxx0redSECRET1234

Printing differently

2005-07-19T13:51:00.000-04:00

Here is instructions how you can print a web page differently than viewed on screen by using CSS stylesheets. You can hide your header / footer, web page menus, preventing credit card numbers from printing, tables or passwords from printing. This is good for omitting certain information. You can also print differently depending on the device that the document is being output to (or printed). This can be used to easily print alternate content on your page depending on if your viewing it or printing it. To do this, we will use the media attribute. I think of it as an if else statement depending upon the output device. Some of these outputs include printer, projection, screen, tty, tv and more. For a full list see this. Below is an example where you can to hide certain text from printing and also print text differently out the printer.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
  <head>
    <style>
      .name { FONT-SIZE:10px}
      @media screen {
      .doNotPrint{ display: all}
      .creditCardNumber {COLOR: #111111;}
      }
      @media print {
      .name{FONT-SIZE: 20px;}
      .creditCardNumber {  display: none;}
      .doNotPrint{display: none; }
      }
    </style>
  </head>
  <body>
    <P>
      <TABLE id="Table1" cellSpacing="1">
        <TR class="doNotPrint">
          <TD>Welcome(WONT PRINT)</TD>
        </TR>
        <TR class="creditCardNumber">
          <TD>4522668955551234(WONT PRINT)</TD>
        </TR>
        <TR class="name">
          <TD>John Smith(PRINTS LARGE)</TD>
        </TR>
      </TABLE>
    </P>
  </body>
</html>

P2P Client Port Numbers

2005-07-10T01:27:00.000-04:00

Here is a list of ports to forward when using file shaing programs ( P2P )
Kazaa ( fasttrack ) uses 1214
Gnutella ( LimeWire, Bearshare, Morpheus and others ) 6346
OpenFt 1215,1216
Ares ( Ares ? ) 59049
Edonkey (emule) 4662 4665

The open source P2P program KCEasy Application supports all these protocols in one and contains no string and no adware.

http://kceasy.com/
you have to search for the kazaaa plugin yourself it is under this name
kceasy-fasttrack-0.8.7.exe

Using BITS from C#

2005-07-07T00:53:00.000-04:00

Here is instructions download a file with BITS. Perhaps to update your app from C# or at least this will get you started. Bits is written in C++ but fourtounately; Microsoft wrote a wrapper called BackgroundCopyManager (backgroundcopymanager.dll). You can read the article and download the assembly here. You need to start a new C# project and add a reference to the dll and also add this namespace to the top of your code.

using Microsoft.Msdn.Samples.BITS;

Here is code to queue a file and download it.

Manager m = new Manager();
Job bj = m.CreateJob("MyJob3");
bj.AddFile("http://localhost/largefile.msi", "destination123.msi");
bj.ResumeJob();

This code will bind a listbox and show the status of each job

Manager myBITS = new Manager();
JobCollection myJobs = myBITS.GetListofJobs(JobType.AllUsers);
myListBox.DataSource = myJobs;

Good luck.

BITSAdmin Uploading

2005-07-07T00:22:00.000-04:00

Here is how you upload if you have been having problems. None of the documentation is in one place.

Download the newest bits available ( see my other post and this)
Install the bits server extentions ( part of windows 2003 server)
Create a virtual folder in IIS ( or a new web site) (DO NOT GIVE ANY EXECUTE PERMISSIONS)
Enable Bits Server Extentions in IIS for your virtual folder.
Grant access to the folder to everyone (just for now ;] )
Use this batch file to upload your files.

bitsupload.txt

@echo off
echo usage: %0 RandomJobname FullPathToSource FullPathToDest
echo i.e. %0 myJob91832 c:\windows\file.txt http://abc.com/file.txt
if "%1"=="" goto end
Bitsadmin /create /upload %1
Bitsadmin /addfile %1 %3 %2
BitsAdmin /setnoprogresstimeout %1 79200
BitsAdmin /setminretrydelay %1 60
Bitsadmin /resume %1
Bitsadmin /info %1 /verbose
rem Bitsadmin /monitor
:end

Hopefully that should work, drop me a line if that helped.

BITSAdmin Tool / Downloading

2005-07-06T23:57:00.000-04:00

Have you had any problems with the Background Intelligent Transfer Service ? ( BITS) I did, and it took me quite a while and various resources to figure how this tool worked. I really needed it because its useful for downloading updates for you applications and also for backing up things such as your laptop to another server. Windows update uses this tool to slowly download updates. First of all ill show you how to download and upload with the bitsadmin tool ( bitsadmin.exe ). Lastly ill show you how to download using this code in C# without needing to know any C++. Just for basic use; here is microsofts docs on the tool LINK . Not too clear? They say to extract the most recent version from the windows xp service pack 2 support tools. I would get it ( version 2.0) here. I created a bat file to make the usage easier. To download is pretty Simple, try these in a cmd window. [Note, i replaced my previous intructions here with a .bat file instead]

bitsdownload.bat

@echo off
echo usage: %0 RandomJobName FullPathToSource FullPathToDest
echo i.e. %0 myJob141112 http://MyServer.com/file.txt c:\temp\file.txt
if "%1"=="" goto end
Bitsadmin /create %1
Bitsadmin /addfile %1 %2 %3
Bitsadmin /resume %1
Bitsadmin /info %1 /verbose
rem Bitsadmin /monitor
:end

Note that some servers dont support downloading with this. Also there is a parameter to notify you when the download is complete. Hope this helps someone.

Cache XML Dataset

2005-06-26T21:22:00.000-04:00

Here is a quick way to retrieve configuration data from an XML files (not web.config) in ASP.NET. This supports caching and is quick and efficient.

public static DataRow LoadXML(string XMLFileName)
{
DataSet ds1;

if (HttpContext.Current.Cache[XMLFileName] == null)
{ //not in cache so we create it
ds1 = new DataSet();
ds1.ReadXml(XMLFileName);//read it
HttpContext.Current.Cache.Insert(XMLFileName, ds1,
new CacheDependency(XMLFileName));//save it
}
else //or load it from cache
{
ds1=(DataSet) HttpContext.Current.Cache[XMLFileName];
}

DataRow r=ds1.Tables[0].Rows[0];
return r;
}

Every time you need a data from a simple config file, you can get the data out like this below without any consequences. There is a Cache dependency on the file so if it changed, the cache is updated. The key is set to the filename

datarow r = LoadXML(@"c:\\file.xml");
string foo=r["blahColumn"];
.

The Ultimate Compression

2004-10-15T11:40:00.000-04:00

I have seen the best compression ratio I have ever seen. Last night I compressed a 16 Gig database down to 2. I used the 7-Zip program. Its interface isn't too pleasing to the eye, but you can tell they focus on what's important, the algorithms. It's a GNU project. It allows you to specify the "Dictionary Size" and "Word Size" for the patterns it finds. The more ram you have, the higher the Dict Size you can use. None of the others program support using more than 4 megs for the compression. I chose for 7zip to use about a gig which resulted in a way higher compression. I highly recommend this program for compression of larger databases.

Program | Method | Percent Of original Size
Zip | (Maximum)| 53% (zip didn't support it this big, I had to split it)
Rar | (Best) | 26%
7zip | (Ultra) | 12%

Duplicate Partial File Finder

2004-09-01T23:45:00.000-04:00

How many times have you downloaded a bunch of songs from Kazaa (or whatever P2P program) and had several duplicate files. If one of those files is 99% there and the other is 100% of the actual file, no current duplicate eliminator program will work. I created a program that scans for partial files and allows you to delete them. First it does a pre-scan and only scans (compares) a little bit into the file (compares by using a hash). This will result in a few errors, but saves alot of time and eliminate non duplicates from the equation and selects probable duplicates without having to go through each entire file. A second pass goes alot further into the file to ensure accuracy. It saves alot of space. Try it, on the download link.

No Sourcesafe, YES integrate CVS into Visual Studio .net

2004-09-01T01:14:00.000-04:00

This thing is awesome. http://www.jalindi.com/igloo/
I hate sourcesafe. But cvs is annoying since its not integrated. The good news is this site has a plugin to use cvs seamlessly in visual studio. It works perfect, its awesome!You might think you found a few kinks like things that dont work and greyed out things that used to work in sourcesafe but you need to fool with it for a while. You'll find out that alot of the sourcesafe features are redundant. Works with cvsnt http://www.cvsnt.com/cvspro/ which is free. Also works with any other cvs such as linux ones.

Nullable Date Time Picker

2004-08-15T01:17:00.000-04:00

A while back, i was so angry when i was using the .net c# dateTimePicker control on a winform. It did not support null dates. It defaulted to today's date. No matter if i push delete or anything.I decided to write a nullable one. I decided to write this one myself. Well, mostly myself.I got some ideas from usenet. Noone else had a solution that actually worked. I hope it works for you. BTW, in this control that inherits the date time picker, you must bind to BindMe, or else you will loose you null support.

using System;
using System.Collections;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Windows.Forms;

namespace DateTimePickerNull
{
       public class DateTimePickerNull
: System.Windows.Forms.DateTimePicker
       {

              public DateTimePickerNull()
              {
                     this.ShowCheckBox=true;
              }

              public object BindMe

              {
                     get
                     {
                            if (this.Checked)
                            {
                                   return base.Value;
                            }
                            else
                            {
                                   return System.DBNull.Value;
                            }
                     }
                     set
                     {
                            if (System.Convert.IsDBNull(value))
                            {
                                   this.Checked=false;
                            }
                            else
                            {
                                   if (this.Checked==false)
                                          this.Checked=true;

                                   this.Value = Convert.ToDateTime(value);
                            }
                     }
              }

       }
}

Blogger Formatting Problem

2004-07-08T14:31:00.000-04:00

I got tired of pasting source code into blogger, and it messing it up. So i made a program to format the code correctly. The problem was that spaces dont do anything in html and also it will wrap on certain characters. The solution is to replace spaces with nbsp and also put a tag in so it does not wrap on certain characters.I put a link on the sidebar for you to try it out now in php or here. If it doesent work for you, download it from the download link.