Jeffery (Mingqiu) Chi

C#: Calculate Age in Years, Month and Days

2011-01-18T12:03:00.001-08:00

C#: Calculate Age in Years, Month and Days

http://www.raasukutty.com/blog/programming/c-calculate-age-in-years-month-and-days.html

All credits belong to the original author...

Unit Testing Entity Framework 4 - Test Add Object

2010-12-22T19:33:00.001-08:00

  [TestMethod]

        public void ShouldSaveMemberNote()

            using(var memberDataRepository = new MemberDataRepository(mockUnitOfWork.Object))

                const int memberId = 1;

                const int noteCategoryLookupId = 1;

                memberDataRepository.SaveMemberNote(memberId, noteCategoryLookupId, @"Some Random Texts");

            mockUnitOfWork.Verify(work => work.AddObject("MemberNotes", It.IsAny<MemberNote>()));

            mockUnitOfWork.Verify(work => work.SaveChanges());

Resharper

2010-12-22T14:09:00.000-08:00

http://www.jetbrains.com/resharper/documentation/help20/OtherEdit/showParams.html

C# + Multithreading returns value

2010-12-18T03:26:00.000-08:00

  [HandleError]

    public class HomeController : Controller

        private Stream streamTesting = null;

        public void StreamResultCallBack(Stream s)

            streamTesting = s;

        public FileStreamResult GeneratePdfReport()

            var g = new GenerateReport(_callback: new StreamResultDelegate(StreamResultCallBack));

            var t = new Thread(new ThreadStart(g.ThreadProc));

            t.Start();

            t.Join();

            HttpContext.Response.AddHeader("content-disposition", "attachment; filename=Rockets_List_Printout.pdf");

            return new FileStreamResult(streamTesting, "application/pdf");

 #region "Report related multi-thread applications"

    public delegate void StreamResultDelegate(Stream streamResults);

    public class GenerateReport

        private StreamResultDelegate callback;

        public GenerateReport(StreamResultDelegate _callback)

            callback = _callback;

        public void ThreadProc()

            if (callback != null)

                callback(Testing());

        public Stream Testing()

            var reportsService = new ReportsService();

            var nameValueCollection = new NameValueCollection();

            byte[] pdfReportContents = reportsService.GetReport("/Rocket.Reports/RocketReport", nameValueCollection);

            var stream = new MemoryStream(pdfReportContents);

            return stream;

    #endregion

Professional Portfolio

2010-11-09T22:35:00.000-08:00

Government Superannuation Fund Authority (ASP.NET MVC)

2010-11-09T22:32:00.001-08:00

The Government Superannuation Fund Authority is an autonomous Crown Entity, established in October 2001. Its functions are to manage and administer the Government Superannuation Fund (“GSF” or the “Fund”) and the GSF Schemes in accordance with the Government Superannuation Fund Act 1956 and subsequent amendments (“the GSF Act”).

Project is built using ASP.NET MVC 2 with MS SQL SERVER 2008, report server 2008.

Unit Testing Moq

Entity Framework 4

The Unity Application Block (Unity) is a lightweight extensible dependency injection

MS Exam 70433 Chapter 1 Data Retrieval - Lesson 3 : Implementing Aggregate Queries

2010-09-25T21:20:00.001-07:00

Lesson 3 : Imp re
Objectives :

1. Describe the purpose of the aggregate functions available
2. Group aggregate data by using the GROUP BY statement

Working with Aggregate functions, aggregate functions perform calculations on a set of data and return a scalar (single) value.

AVG Returns the average of all values in the data set
CHECKSUM_AGG Returns the checksum of all values in the data set
COUNT Returns the number of values contained in the data set. COUNT (*) returns the number of rows in the set.
COUNT_BIG Works the same as COUNT, but it returns the bigint data type, while COUNT returns only the int data type.
GROUPING Returns 1 or 0 and identifies rows as aggregate or detail rows when the GROUP By statement is used.
MAX Returns the highest value in the data set for numeric, data, and character-based fields.
MIN Returns the lowest value in the data set for numeric, data, and character-based fields.
SUM Returns the total of the values in the data set. You can specify ALL or DISTINCT to produce either the sum of all values or only distinct values in the data set.
STDEV Returns the statistical standard deviation of the values in the data set.
STDEVP Returns the statistical standard deviation for the population of the values in the data set.
VAR Returns the statistical variance of the values in the data set.
VARP Returns the statistical variance for the population of the values in the data set.

MS Exam 70433 Chapter 1 Data Retrieval - Lesson 2 : Joining Related Tables

2010-09-18T23:22:00.000-07:00

Normalized databases :

->Using INNER, OUTER, FULL and CROSS JOIN
->Difference between different JOIN operators

The join operator allows you to return data from columns stored in multiple related tables. Although actual relatinships, implemented by creating PRIMARY KEY and FOREIGN KEY constraints, are not required, there does need to be at least one column in each of the tables that has the same meaning to enable the join query.

If a column with the same column name exists in more than one table in the query, you must qualify the column with the table name when defining the select list of listing columns in the WHERE clause or other clauses within the SELECT statement.

You can use table aliases to avoid lengthy code caused by long schema and object names.

select firstname, lastname, jobtitle, vacationhours, sickleavehours from humanresources.employee e inner join person.person p on e.businessentityid = p.businessentityid

Defining Inner Joins
Inner joins return only the rows that match in the join condition. Although an inner join can be specified in either the FROM or the WHERE clause, it is recommended to specify the JOIN in the FROM clause. All samples and practices in this book follow this recommendation.

Defining Outer Joins
An outer join can be used to return all rows from one table and only information from rows that are in common from the other table, or it can return all rows from all tables in the JOIN clause.

A FULL OUTER JOIN is neither "left" nor "right"— it's both! It includes all the rows from both of the tables or result sets participating in the JOIN. When no matching rows exist for rows on the "left" side of the JOIN, you see Null values from the result set on the "right." Conversely, when no matching rows exist for rows on the "right" side of the JOIN, you see Null values from the result set on the "left."

Defining Cross Joins

Most of the time, we do not want a Cartesian join, and we end up with one because we failed to provide a filter on the join. If we actually want a Cartesian join, then we should use the ANSI cross join to tell others reading the script that we actually wanted a Cartesian join.
One reason to use a Cartesian join is to generate a large amount of rows to use for testing. I can take a large table and cross join it to another large table and produce a very large results set.

Working with More Than Two Tables
A general performance recommendation is to try and avoid JOIN operations that include more than four or five tables.

CAUTION: Working with more than two tables. You need to be especially careful to verify result sets when working with the OUTER JOIN operator within more than two tables involved. The Database Engine builds temporary result sets from the first JOIN operation, and then uses that result set for the next JOIN operation. Depending on the order defined and the operators specified, you may get different results.

Defining a Self - Join
1) When your database includes a self-referencing table. (common table expression (CTE))

select e.firstname + '' + e.lastname as 'employee name', ds.firstname + '' + ds.lastname as 'direct supervisor' from dimemployee e inner join dimemployee ds on e.parentemployeekey = ds.employeekey;

2)

PRACTICE :

use testing

select tblA.PKROWID, ROWDETAILS as 'details' from tbla where rowdetails like '%two%' order by [details]

select * from HumanResources.Employee as e JOIN HumanResources.Employee as em ON e.EmployeeID = em.ManagerID

Lesson Summary :

The JOIN clause allows you to retrieve columns from related tables and group the results into a single result set.
JOIN type include INNER, LEFT OUTER, RIGHT OUTER, FULL OUTER, and CROSS
JOIN operators can combine more than two tables
A table can be joined to itself by defining different aliases for each reference to the table

MS SQL SERVER RELATED ARTICLES

2010-09-16T14:53:00.001-07:00

http://jefferychinet.blogspot.com/2010/08/tsql-sample.html

http://jefferychinet.blogspot.com/2010/07/win-cmd-script-ms-sql-server-database.html

http://jefferychinet.blogspot.com/2010/07/server-principal-is-not-able-to-access.html

http://jefferychinet.blogspot.com/2010/07/install-ms-sql-server-2008-on-2k3.html

http://jefferychinet.blogspot.com/2010/07/ms-sql-with-c.html

Study :

http://jefferychinet.blogspot.com/2010/07/ms-exam-70433.html

http://jefferychinet.blogspot.com/2010/09/ms-exam-70433-chapter-1-data-retrieval.html

colorpic

2010-09-11T02:28:00.001-07:00

http://www.iconico.com/download.aspx?app=ColorPic&type=free

JavaScript + Server Side Control

2010-09-08T17:22:00.000-07:00

If the data of a drop down box server control is populated from the client side, then you can't read its value from server side.

I normally add a hidden textbox to store the selected value of the drop down box, of course you need to write a javascript function that pass the value from the drop down box to the hidden textbox.

To learn list

2010-09-05T21:09:00.001-07:00

TypeConverter Class (1.1 ; 2.0; 3.0 ; 3.5)

http://msdn.microsoft.com/en-us/library/system.componentmodel.typeconverter.aspx

DateTimeStyles Enumeration

http://msdn.microsoft.com/en-us/library/91hfhz89(VS.71).aspx

DateTime Swap Problem :

 private static void IsValidDateValue(string userInputValue, CustomValidatorExtended custValidator, string errorMessage, ref bool isValid)

            Regex regexValue = new Regex(SHORT_DATE_VALUE);

            if (regexValue.IsMatch(userInputValue))

                Match match = regexValue.Match(userInputValue);

                int dayValue;

                if (!Int32.TryParse(match.Groups["date"].Value, out dayValue))

                    custValidator.ErrorMessage = errorMessage;

                    isValid = false;

                    return;

                int monthValue;

                if (!Int32.TryParse(ConvertMonthNameToNumber(match.Groups["month"].Value).ToString(), out monthValue))

                    custValidator.ErrorMessage = errorMessage;

                    isValid = false;

                    return;

                //this application is designed to handle only from year 2000 ~ 2020 and user only suppose to enter 2 digits for year

                int yearValue;

                if (!Int32.TryParse("20" + match.Groups["year"].Value, out yearValue))

                    custValidator.ErrorMessage = errorMessage;

                    isValid = false;

                    return;

                DateTime dtParse;

                if (!DateTime.TryParse(yearValue + "-" + monthValue + "-" + dayValue, out dtParse))

                    custValidator.ErrorMessage = errorMessage;

                    isValid = false;

                    return;

            else

                isValid = true;

                return;

http://msdn.microsoft.com/en-us/library/0yw3tz5k%28v=VS.80%29.aspx

sql temp table and table variable

2010-08-31T22:49:00.000-07:00

http://databases.aspfaq.com/database/should-i-use-a-temp-table-or-a-table-variable.html

You can find the integer value of an enum by casting

2010-08-30T16:22:00.001-07:00

int complexityValueToStore = (int)Complexity.Normal;

.NET Framework 4

2010-08-29T17:41:00.000-07:00

Page.RegisterRequiresControlState Method

public class Sample : Control {

    private int currentIndex = 0;

    protected override void OnInit(EventArgs e) {

        Page.RegisterRequiresControlState(this);

        base.OnInit(e);

    protected override object SaveControlState() {

        return currentIndex != 0 ? (object)currentIndex : null;

    protected override void LoadControlState(object state) {

        if (state != null) {

            currentIndex = (int)state;

http://msdn.microsoft.com/en-us/library/system.web.ui.page.registerrequirescontrolstate.aspx

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

using System;

using System.Collections.Generic;

using System.Security.Permissions;

using System.Text;

using System.Web;

using System.Web.UI;

namespace AnzNational.FLT.ServerControls

    /// <summary>

    /// This control provides PageState object

    /// </summary>

    [AspNetHostingPermission(SecurityAction.Demand, Level = AspNetHostingPermissionLevel.Minimal)]

    [AspNetHostingPermission(SecurityAction.InheritanceDemand, Level = AspNetHostingPermissionLevel.Minimal)]

    [ToolboxData("<{0}:PageState runat=server></{0}:PageState>")]

    public class PageState : UserControl

        List<object> pageState = null;

        protected void Page_Init(object sender, EventArgs e)

            if (pageState == null)

                pageState = new List<object>();

            Page.RegisterRequiresControlState(this);

        protected override object SaveControlState()

            return pageState;

        protected override void LoadControlState(object savedState)

            if (savedState == null)

                return;

            pageState = (List<object>)savedState;

        public object GetPageState(int index)

            if (pageState != null && index < pageState.Count)

                return pageState[index];

            return null;

        public void SetPageState(int index, object obj)

            if (pageState == null)

                pageState = new List<object>();

            if (index >= pageState.Count)

                for (int i = pageState.Count; i < index; i++)

                    pageState.Add(null);

                pageState.Add(obj);

            else

                pageState[index] = obj;

The idea behind using this feature is to retain the state of certain value even when ViewState has been turnned off on that page.

Install windows 2003 active directory

2010-08-28T20:28:00.000-07:00

TSQL SAMPLE

2010-08-25T14:53:00.000-07:00

select d.vcrDeliveryTeamName,COUNT(r.in2roleid) from tblRole r

inner join tblDeliveryTeam d on r.in2DeliveryTeamID = d.in2DeliveryTeamID

group by

d.vcrDeliveryTeamName

order by

COUNT(r.in2roleid) desc

Javascript drag and drop

2010-08-24T14:12:00.000-07:00

http://archive.dojotoolkit.org/nightly/dojotoolkit/dojox/grid/tests/test_grid_column_reorder.html

http://docs.jquery.com/UI/Draggable
http://code.google.com/p/tablednd/source/browse/trunk/stable/jquery.tablednd.js?r=7

Javascript Regular Expression and Date Type

2010-08-03T19:58:00.000-07:00

<script type="text/javascript">

/*

    Convert Month Name To Number Value

*/

    function ConvertMonthNameToNumber(strMonthNameAbbreviation) {

        var intMonthValue;

        switch (strMonthNameAbbreviation) {

            case "Jan":

                intMonthValue = 1;

                break;

            case "Feb":

                intMonthValue = 2;

                break;

            case "Mar":

                intMonthValue = 3;

                break;

            case "Apr":

                intMonthValue = 4;

                break;

            case "May":

                intMonthValue = 5;

                break;

            case "June":

                intMonthValue = 6;

                break;

            case "July":

                intMonthValue = 7;

                break;

            case "Aug":

                intMonthValue = 8;

                break;

            case "Sept":

                intMonthValue = 9;

                break;

            case "Oct":

                intMonthValue = 10;

                break;

            case "Nov":

                intMonthValue = 11;

                break;

            case "Dec":

                intMonthValue = 12;

                break;

        return intMonthValue;

    $(document).ready(function() {

        $("#linkToManageEmploymentStatus").hide();

        $("#spanTerminateDate").hide();

        $("#aspnetForm").submit(function() {

            var startDate = $("#ctl00_mainContent_dtHireDate").val();

            var endDate = $("#ctl00_mainContent_dtTerminateDate").val();

            var pattest = /(\d{1,2})\s([a-zA-Z]+)\s(\d{4}|\d{2})/;

            var startDateFormatted = new Date(startDate.match(pattest)[3], ConvertMonthNameToNumber(startDate.match(pattest)[2]), startDate.match(pattest)[1]);

            var endDateFormatted = new Date(endDate.match(pattest)[3], ConvertMonthNameToNumber(endDate.match(pattest)[2]), endDate.match(pattest)[1]);

            if (typeof (startDateFormatted) != "undefined" &&

               startDateFormatted != null &&

               startDateFormatted != "" &&

               typeof (endDateFormatted) != "undefined" &&

               endDateFormatted != null &&

               endDateFormatted != "") {

                   if (Date.parse(startDateFormatted) >= Date.parse(endDateFormatted)) {

                       $("#spanTerminateDate").show();

                       return false;

            var employmentStatusValue = $("#ctl00_mainContent_ddlEmploymentStatus").val();

            if (typeof (employmentStatusValue) != "undefined" && employmentStatusValue != null && employmentStatusValue != "") {

                $("#linkToManageEmploymentStatus").hide();

                return true;

            } else {

                $("#linkToManageEmploymentStatus").show();

                return false;

});

});

</script>

Jquery Tablesorter Persistent

2010-07-28T18:23:00.001-07:00

http://ybits.net/2009/10/making-jquery-tablesorter-persistent/

Win CMD script + MS Sql Server database

2010-07-26T20:44:00.000-07:00

@echo off

if '%1' == '' goto lblUsage

if '%2' == '' goto lblUsage

if '%3' == '' goto lblUsage

if '%4' == '' goto lblUsage

if '%5' == '' goto lblUsage

if '%6' == '' goto lblUsage

if '%7' == '' goto lblUsage

if '%8' == '' goto lblUsage

if '%9' == '' goto lblUsage

if '%10' == '' goto lblUsage

if '%1' == '/?' goto lblUsage

if '%1' == '-?' goto lblUsage

if '%1' == '?' goto lblUsage

if '%1' == '/help' goto lblUsage

:: Set Error Variables

set ErrValue=0

:: Delete directory for Install Reports

if exist "%~dp0Install" (

rmdir "%~dp0Install" /s /q

if %ERRORLEVEL%==1 (

set ErrValue=2

goto lblExit

:: Create directory for Install Reports

echo Creating Installation Reports Directory "%~dp0Install" ...

if not exist "%~dp0Install" (

md "%~dp0Install"

if %ERRORLEVEL%==1 (

set ErrValue=2

goto lblExit

:: Create Database and Setup Security

echo Creating "%2" Database on %1 Server and Configuring Security ...

echo Creating "%2" Database on %1 Server and Configuring Security ... >> %~dp0Install\Install.rpt

sqlcmd -S %1 -d master -E -b -e -i "%~dp0_CreateDB.sql" -o "%~dp0Install\_CreateDB.rpt" -vDBName=%2 DataPath=%4 LogPath=%5 AppAcct=%6 DevGrp=%7 Domain=%8 DeleteDB=%9

sqlcmd -S %1 -d master -E -b -e -i "%~dp0_CreateDB.sql" -o "%~dp0Install\_CreateDB.rpt" -vDBName=%2 DataPath=%4 LogPath=%5 AppAcct=%6 DevGrp=%7 Domain=%8 DeleteDB=%9  >> "%~dp0Install\Install.rpt"

if %ERRORLEVEL%==1 goto lblExit

echo            SUCCESS ... "%~dp0_CreateDB.sql" has run successfully>> %~dp0Install\Install.rpt

echo           SUCCESS ... "%~dp0_CreateDB.sql" has run successfully

echo. >>"%~dp0Install\Install.rpt"

:: Tables

call "%~dp0Tables\_CreateTables.cmd" %1 %2

if %ERRORLEVEL%==1 goto lblError

:: Functions

call "%~dp0Functions\_CreateFunctions.cmd" %1 %2

if %ERRORLEVEL%==1 goto lblError

:: Triggers

:: Indexes

call "%~dp0Indexes\_CreateIndexes.cmd" %1 %2

if %ERRORLEVEL%==1 goto lblError

:: StoredProcedures

call "%~dp0Procedures\_CreateProcedures.cmd" %1 %2

if %ERRORLEVEL%==1 goto lblError

:: InitialData

call "%~dp0InitialData\_CreateInitialData.cmd" %1 %2

if %ERRORLEVEL%==1 goto lblError

:: Run ANZ Standards Check

echo Checking Database "%2" against ANZ Standards ...

echo Checking Database "%2" against ANZ Standards ... >> %~dp0Install\Install.rpt

sqlcmd -S %1 -d %2 -E -b -e -i "%~dp0ANZStandardsCheck.sql" -o "%~dp0Install\ANZStandardsCheck.rpt"

sqlcmd -S %1 -d %2 -E -b -e -i "%~dp0ANZStandardsCheck.sql" -o "%~dp0Install\ANZStandardsCheck.rpt"  >> "%~dp0Install\Install.rpt"

if %ERRORLEVEL%==1 goto lblExit

echo            SUCCESS ... "%~dp0ANZStandardsCheck.sql" has run successfully>> %~dp0Install\Install.rpt

echo           SUCCESS ... "%~dp0ANZStandardsCheck.sql" has run successfully

echo. >>"%~dp0Install\Install.rpt"

goto lblExit

:lblUsage

echo.

echo Usage: _CreateDB.cmd  SQLServer DatabaseName TestData DataPath LogPath AppAcct DevGrp Domain DeleteDB

echo SQLServer: the name of the target SQL Server, e.g. DSSQL02\I2,49169

echo DBName: the name of the target DBName, eg. PIP

echo TestData: include creation of test data, e.g. Y or N

echo DataPath: the path for Data files, e.g. E:\MSSQL.1\Data (Default)

echo LogPath: the path for Log files, e.g. F:\MSSQL.1\Logs (Default)

echo AppAcct: the Application Account used by the Web Services, e.g. nzPIPsvcsservice (Default)

echo DevGrp: the Developer Support Group Name, e.g. Sat Sys Developer (Default)

echo Domain: the domain name for the implementation, e.g. DEVDOMAIN

echo DeleteDB: delete the database if it exists.

echo.

echo Example: _CreateDB.cmd "DSSQL02\I2,49169" FLT Y "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data" "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data" "FLTacc" "Sat Sys Developer"

echo.

echo.

:lblExit

if %ERRORLEVEL%==1 goto lblError

echo.

echo.

echo. >>"%~dp0Install\Install.rpt"

echo. >>"%~dp0Install\Install.rpt"

echo SUCCESS  .. Database creation has completed successfully >> %~dp0Install\Install.rpt

echo SUCCESS  .. Database creation has completed successfully

goto lblExitBuild

:lblError

echo.

echo.

echo FAILED  .. Database creation has failed

if not %ErrValue%==2 (

echo. >>"%~dp0Install\Install.rpt"

echo. >>"%~dp0Install\Install.rpt"

echo FAILED  .. Database creation has failed >> %~dp0Install\Install.rpt

 :lblExitBuild

exit /b %ERRORLEVEL%

The server principal " " is not able to access the database " " under the current security context. (Microsoft SQL Server, Error: 916)

2010-07-25T20:22:00.001-07:00

The server principal " " is not able to access the database " " under the current security context. (Microsoft SQL Server, Error: 916)

http://connect.microsoft.com/SQLServer/feedback/details/354291/the-server-principal-is-not-able-to-access-the-database-under-the-current-security-context-microsoft-sql-server-error-916

I create a database when I login as Administrator, the I login as domain user, this time the database I setup previously disappeared. And I saw the above error, so I login again as administrator this time and add my domain user account as database user.

Logout and login as domain user again, this time database works fine.

:)

Install MS Sql Server 2008 on 2k3 Server

2010-07-25T15:25:00.001-07:00

Database Connection String :

http://www.connectionstrings.com/sql-server-2005

ANZ Bank New Zealand Forward Load Tool Project

2010-07-25T14:39:00.001-07:00

Forward Load Tool

ASP.NET Web Form

.NET Framework 4

JQuery

DataSet

ANZ Bank New Zealand Projects

2010-07-25T14:38:00.000-07:00

APLAF

Personal Loan Form Application:

MVP

http://msdn.microsoft.com/en-us/magazine/cc188690.aspx

http://aspnetmvp.codeplex.com/

Ninject Inversion Control

MS SQL Server 2008

Visual Studio 2010

Cross Page Postbacks on a GridView

2010-07-21T22:10:00.000-07:00

Cross Page Postbacks on a GridView
http://www.codeproject.com/kb/aspnet/GridViewCrossPagePostBack.aspx
HyperLinkField Class
http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.hyperlinkfield.aspx

http://forums.asp.net/p/1092755/3985600.aspx#3985600

MS Exam 70433 Chapter 1 Data Retrieval - Query Data

2010-07-20T13:44:00.000-07:00

Lesson 1: Querying Data

If you want to exclude rows that have exact duplications of the data, you can use 'select distinct'.

If you want to view only colors and not see that there are NULL rows in the preceding sample, you can use the following code:

select distinct color from production.product where color is not NULL

Note working with null values

A null value is the absence of data in a column, when ANSI_NULLS setting is set to ON, the default configuration, you cannot equate values to NULL. If you try, the server retunrs 'unknown'. For example, in the previous code, if you replace 'is no' with <>, the query would not return any rows in a default configuration. if you executed the following commands together, you would get the same result set as the previous sample code:

set ansi_nulls off;

select distinct color from production.product where color <> null;

The where clause can include a variety of search conditions that can include boolean operators and predicates such as LIKE, BETWEEN, EXISTS, IS NULL, IS NO NULL and CONTAINS.
The 'CONTAINS' clauses is available only when you create a full text index on the column being compared.

Boolean operators, which include AND, OR, and NOT can be used to define more than one criterion in a WHERE clause.

select * from production.product where color ='silver' and listprice >200

Defining a WHERE Clause

Where clauses typically increases query performance by limiting the amount of data that needs to be sent back to the client application.

The where clause can include a variety of search conditions that can include Boolean operators can predicates such as LIKE, BETWEEN, EXISTS, IS NULL, IS NOT NULL and CONTAINS

Boolean operators, which include AND, OR and NOT, can be used to define more than one criterion in a WHERE clause.

select * from production.product where color ='silver' and (listprice > 200 or listprice = 0)

(if the parentheses were not added, the query would return silver products with a price over $200 and all colors of products with a list price of $0 because of the order in which the conditions are evaluated, which is based on the boolean order of operations)
(The CONTAINS clause in available only when you create a full text index on the column being compared.)

[when the database engine parses and compiles a query, conditions that include Boolean operators are evaluated int he following order]
NOT, AND, OR.

The order of operations is important to understand because misunderstanding this
can cause the query to return an unintended result set. You can use parenthese
to control the order of the operations.

Using AND operator typically results in a smaller result set, thus improving performance.
The NOT operator typically hurts performance because the query optimizer cannot use indexes for the WHERE clause when a NOT operator is specified !!

For indexes to be utilized when an OR operator is specified, all columns referenced by the OR condition must be included in an index or none of the indexes are used. (why ???)

The LIKE clause allows you to match a character string found in a column to a specified pattern in the WHERE clause.

Percent (%) : Replaces any number of characters (including 0 characters) in the string.
Underscore (_) : Replaces exactly one character in the string. For example, _at would match cat and hat, but it wourl not match that or at.
Square Brackets ([]) : Replaces any one character within a set or a range of characters. A set is frequently displayed as a stright list of characters, for example [abcd] ; but the characters can be separated by commas to add clarity, for example [a,b,c,d]. A range is separated by a dash, for example , [a-d].
Caret (^) Any character not within a set or range of characters. . For example , [^a-d] would be equal to [e-z]

Using square
brackets to search for wildcard characters
like clause	Searches for
like "5%"	5 followed by any string of 0 or more characters
like "5[%]"	5%
like "_n"	an, in, on, and so forth
like "[_]n"	_n
like "[a-cdf]"	a, b, c, d, or f
like "[-acdf]"	-, a, c, d, or f
like "[ [ ]"	[
like "[ ] ]"	]

Note: Neither leading wildcard characters nor NOT logic allow the query
optimizer to use indexes to optimize the search.

Using square
brackets to search for wildcard characters
like clause
Searches for
like "5%"
5 followed by any string of 0 or more
characters
like "5[%]"
5%
like "_n"
an, in, on, and so forth
like "[_]n"
_n
like "[a-cdf]"
a, b, c, d, or f
like "[-acdf]"
-, a, c, d, or f
like "[ [ ]"
[
like "[ ] ]"
]
http://manuals.sybase.com/onlinebooks/group-as/asg1250e/sqlug/@Generic__BookTextView/6988;pt=7086
Neither leading wildcard characters nor NOT logic allow the query optimizer to use indexes to optimize the search. They should be avoided.

"INCLUSIVE BETWEEN" : between clause is inclusive of the outer values specified in the range.

select

    EmployeeID,

    Title

from

    HumanResources.Employee

where

    Title like '[C-E]%'

order by

    Title

select * from HumanResources.Employee  where Title between 'C' and 'E' order by Title

MS SQL with C#

2010-07-19T19:03:00.000-07:00

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

Microsoft.Practices.ServiceLocation.ServiceLocator

2010-07-19T15:02:00.001-07:00

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

http://visualstudiogallery.msdn.microsoft.com/en-us/25e4b5e9-65e4-4950-967d-5f1e6a9dcbeb

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

http://webclientguidance.codeplex.com/

http://visualstudiogallery.msdn.microsoft.com/en-us/8fc2c9d6-5282-404b-9c58-e72b326b1e26

AI

2010-07-18T18:56:00.001-07:00

http://www.codeproject.com/KB/recipes/NeuralNetwork_1.aspx

Install Active Directory on Windows Server 2003

2010-07-18T18:21:00.001-07:00

For testing purpose, I need to install active directory on one of my windows server 2003.

http://technet.microsoft.com/en-us/library/aa998088(EXCHG.65).aspx

http://yuml.me/

2010-07-18T16:14:00.001-07:00

http://yuml.me/

MCTS Self-Paced Training Kit (Exam 70-433)

2010-07-18T14:43:00.001-07:00

http://avaxhome.ws/ebooks/0735626391.html

Free ebook

SOLID

2010-07-11T18:59:00.000-07:00

SRP : Single Responsbility Principle

There should never be more than one reason for a class to change.

OCP : Open Closed Principle

Software Entities (Classes, Modules, Functions, etc) should be Open for Extension, Closed for Modification.

LSP : Liskov's Substitution Principle

Functions that use References to Base Classes must be able to use Objects of derived classes without knowing it

ISP : Interface Substitution Principle

Clients should not be forced to depend upon interfaces that they do not use.

DIP : Dependency Inversion Principle

High level modules should not depend upon Love Level Modules,. Both should depend on Abstractions.
Abstractions should not dependupon details. Details shold depend upon Abstractions

TSQL Rename Table Column

2010-07-07T19:13:00.001-07:00

Run the following Tsql Script to rename the table column :

/*Rename table column*/
EXEC sp_rename
@objname = 'tblLoanApplication.decCustomerReceiveInHand',
@newname = 'decCustomerWillReceiveInHand',
@objtype = 'COLUMN'

/*Rename table*/
EXEC sp_rename 'OldTableName', 'NewTableName'

Here is an article from Microsoft about system stored procedure "sp_rename":

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

(Here is a list of database engine stored procedures)

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

TSQL one-to-one relationship

2010-07-07T15:28:00.000-07:00

I also want to find out how to implement one-to-one relationship in MS SQL SERVER.

Here is an excellent article on how to do this :

http://stackoverflow.com/questions/2137750/how-to-identify-one-to-one-one-to-relationship-using-information-schema-or-sy

/*
InheritedTable
*/
CREATE TABLE [dbo].[InheritedTable]
(
[InheritedId] [int] NOT NULL,
CONSTRAINT [PK_InheritedTable] PRIMARY KEY CLUSTERED
(
[InheritedId] ASC
)
WITH
(
PAD_INDEX = OFF,
STATISTICS_NORECOMPUTE = OFF,
IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON
) ON [PRIMARY]
)
ON [PRIMARY]
/*
BaseTable
*/
CREATE TABLE [dbo].[BaseTable]
(
[BaseId] [int] NOT NULL,
CONSTRAINT [PK_BaseTable] PRIMARY KEY CLUSTERED
(
[BaseId] ASC
)
WITH
(
PAD_INDEX = OFF,
STATISTICS_NORECOMPUTE = OFF,
IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON
) ON [PRIMARY]
)
ON [PRIMARY]
/*
Add relatinship between baseTable and InheritedTable
*/
ALTER TABLE
[dbo].[BaseTable]
WITH CHECK ADD
CONSTRAINT [FK_BaseTable_InheritedTable]
FOREIGN KEY
(
[BaseId]
)
REFERENCES
[dbo].[InheritedTable]
(
[InheritedId]
)

Jquery and unit testing

2010-07-05T18:12:00.001-07:00

http://api.jquery.com/jQuery.noConflict/

http://fireunit.org/

http://docs.jquery.com/QUnit

Microsoft naming standards :

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

Style sheet reset

http://meyerweb.com/eric/tools/css/reset/

On applying oop concepts to css

http://jeffcroft.com/blog/2009/may/20/applying-oop-concepts-css/

Database third normalisation

http://databases.about.com/od/specificproducts/a/3nf.htm

Microsoft anti-cross site scripting library :

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

Mocking with Rhino Mocks

2010-06-28T14:11:00.000-07:00

http://www.dimecasts.net/Content/WatchEpisode/12

(Introduction to Mocking with Rhino Mocks)

SharePoint WSP Builder

2010-06-23T17:38:00.000-07:00

Some articles about WSPBuilder, it gives you a start from somewhere :

http://www.michaelbowersox.com/2009/01/18/intro-to-wspbuilder/

http://www.datasprings.com/Resources/ArticlesInformation/Sharepoint2007CustomWebParts.aspx

http://blogs.msdn.com/b/wriju/archive/2008/07/01/how-to-find-public-key-token-for-a-net-dll-or-assembly.aspx

http://oidatsmyleg.wordpress.com/2009/07/23/wrap-a-user-control-inside-a-web-part-using-wspbuilder/

Programs

2010-06-03T06:21:00.000-07:00

Source code can be turned into an executable program in two ways:

Interpreters translate the source code into computer instructions, and the computer acts on those instructions immediately.
Alternatively, compilers translate source code into a program, which you can run at a later time. While interpreters are easier to work with, most serious programming is done with compilers because compiled code runs much faster

Old-fashioned programs forced the user to proceed step-by-step through a series of screens. Modern event-driven programs present all the choices at once and respond to the user's actions.

Object-oriented programming attempts to respond to these needs, providing techniques for managing enormous complexity, achieving reuse of software components, and coupling data with the tasks that manipulate that data.

The essence of object-oriented programming is to treat data and the procedures that act upon the data as a single "object"--a self-contained entity with an identity and certain characteristics of its own

Four pillars of object-oriented development:

Encapsulation,
Data hiding,
Inheritance,
Polymorphism.

The property of being a self-contained unit is called encapsulation. With encapsulation, we can accomplish data hiding. Data hiding is the highly valued characteristic that an object can be used without the user knowing or caring how it works internally. Just as you can use a refrigerator without knowing how the compressor works, you can use a well-designed object without knowing about its internal data members.

TortoiseSVN Manual

2010-06-03T01:04:00.000-07:00

http://www.poedit.net/download.php

TO DO LIST

2010-06-03T00:47:00.000-07:00

WCF

WPF

SILVERLIGHT

MOSS 2010

.NET FRAMEWORK 4

NZ Sharepoing User Group

2010-06-03T00:41:00.000-07:00

http://www.sharepointusergroup.net.nz/wellington/default.aspx

http://www.chakkaradeep.com/

(Sharepoing conference)
http://www.sharepointconference.co.nz/

http://www.dot.net.nz/default.aspx

Moss Screen Sho0t

2010-05-26T20:22:00.000-07:00

Style sheet position

2010-05-26T17:53:00.000-07:00

http://www.positioniseverything.net/

http://browsershots.org/

Good sharepoint blog

2010-05-26T17:45:00.000-07:00

http://www.chakkaradeep.com/

Deploy SharePoint solution

2010-05-26T00:44:00.001-07:00

Remind myself how to do this :

Step 1 : Create web application in sharepoint "Central Administration"

Step 2: Build WSP using "wsp builder"

Step 3: Deploy WSP

@echo off
echo.
echo (1 of 3) Installing TEST.SharePoint.Careers...
call add_deploy_wsp.bat
echo.
echo (2 of 3) Installing TEST.SharePoint....
cd ..\TEST.SharePoint\
call add_deploy_wsp.bat
echo.
echo (3 of 3) Performing iisreset...
iisreset
pause

@echo off

set stsadm="C:\Program Files\Common Files\microsoft shared\Web Server Extensions\12\BIN\"
set siteurl="http://Testcecareers"

echo.
echo stsadm: %stsadm%
echo siteurl: %siteurl%
echo.

echo retracting old solution...
%stsadm%stsadm -o retractsolution -name TEST.SharePoint.Careers.wsp -local -url %siteurl%

echo removing old solution...
%stsadm%stsadm -o deletesolution -name TEST.SharePoint.Careers.wsp

echo adding new solution...
%stsadm%stsadm -o addsolution -filename TEST.SharePoint.Careers.wsp

echo deploying new solution...
%stsadm%stsadm -o deploysolution -name TEST.SharePoint.Careers.wsp -allowGacDeployment -local -url %siteurl%

pause

Step 4 : Create site

Create_sitecollection.bat

@echo off
set stsadm="C:\Program Files\Common Files\microsoft shared\Web Server Extensions\12\BIN\"
set siteurl="http://Testcecareers"
set owneremail="administrator@Test.govt.nz"
echo.
echo stsadm: %stsadm%
echo siteurl: %siteurl%
echo owneremail: %owneremail%
echo.
echo Deleting old site collection...
%stsadm%\stsadm.exe -o deletesite -url %siteurl%
::-sitetemplate refers to the folder in which the template file is stored. in this case AirForceCareers the number refers to the actual definition
echo Creating new site collection...
%stsadm%\stsadm.exe -o createsite -url %siteurl% -ownerlogin Administrator -ownername Administrator -owneremail %owneremail% -sitetemplate TestCareers#0
pause

cannot open backup device operating system error 5 error not found

2010-05-25T14:37:00.000-07:00

I was trying to restore a .bak file when I logined as a domain user. Then I run into this error "cannot open backup device operating system error 5 error not found".

After some search on the net, "added NETWORK SERVICE to the folder" solved the problem.

AjaxLoad

2010-05-23T19:30:00.000-07:00

http://ajaxload.info

MOSS Development 5

2010-05-23T07:07:00.000-07:00

http://geekswithblogs.net/mcassell/archive/2007/08/22/Accessing-Sharepoint-Data-through-Web-Services.aspx

http://www.codeguru.com/csharp/csharp/cs_network/internetweb/article.php/c8805

http://www.c-sharpcorner.com/UploadFile/mahesh/WSSInNet01302007093018AM/WSSInNet.aspx

http://msdn.microsoft.com/en-us/library/ms479390%28office.12%29.aspx

http://www.developer.com/tech/article.php/3104621/SharePoint-and-Web-Services.htm

MOSS Development 4

2010-05-23T04:25:00.000-07:00

Feature
Microsoft also added capabilities to the Feature framework to deploy certain custom code solutions such as event receivers, document converters, and custom workflow templates.

This activation and deactivation of a Feature provides developers and site administrators with the capability to toggle functionality on or off with ease via the browser interface.

All SharePoint Features live in a special folder within the SharePoint 12 folder — specifically, in
[..]\12\TEMPLATE\FEATURES . The FEATURES folder contains folders for each Feature that has been deployed to the server. After a clean Office SharePoint Server (MOSS) 2007 installation, the FEATURES folder will contain more than 130 folders, each signifying a Feature that is part of the out - of - the - box (OOTB) MOSS 2007 installation.

To create a new Feature, create a new folder in the FEATURES folder such as MyFirstFeature . Every Feature must have a definition file containing all the information that SharePoint needs to know about the Feature.

The following Collaborative Application Markup Language (CAML)


< ?xml version="1.0" encoding="utf-8"? >
< Feature xmlns="http://schemas.microsoft.com/sharepoint/" Id="32DECDEF-C37C-4AC3-BA65-D49639668E7C"
Title="My First Feature"
Description="The simplest Feature ever."
Hidden="FALSE"
Scope="Web">
< /Feature >

Once the definition has been created and saved into a new folder within the FEATURES folder, SharePoint must then be made aware of the Feature. This is done by installing the Feature using STSADM.EXE and the installfeature operation:
stsadm.exe – o installfeature – name MyFirstFeature

Feature Scope

Web (SharePoint site) --Applies to a specific SharePoint site .

Site (site collection) -- Applies to a SharePoint site collection and all SharePoint sites within the
site collection .

WebApplication --Applies to a SharePoint extended Web application, all site collections within
the Web application, and all sites within those site collections .

Farm -- Applies to a SharePoint farm, all SharePoint extended Web applications, all
site collections, and all SharePoint sites within the SharePoint farm .

Element Manifests

Element manifests, another type of XML file found in a Feature ’ s folder, contains CAML that defines site elements. The SharePoint Feature schema contains many different types of site elements.

Once an element manifest file has been created, it needs to be associated with the Feature. To do this, create a ElementManifests node that contains ElementManifest nodes containing a reference to the element manifest files in the Feature


< ?xml version=”1.0” encoding=”utf-8”? >
< Feature xmlns=”http://schemas.microsoft.com/sharepoint/”
Id=”32DECDEF-C37C-4ac3-BA65-D49639668E7C”
Title=”My First Feature”
Description=”The simplest Feature ever.”
Hidden=”FALSE”
Scope=”Web” >
< ElementManifests >
< ElementManifest Location=”elements.xml”/ >
< /ElementManifests >
< /Feature >

Feature Receivers

Microsoft anticipated such as scenario and added the capability for developers to write event
handlers for certain events within an assembly.

FeatureInstalled
FeatureActivated
FeatureDeactivating
FeatureUninstalling

developers must create a new class that inherits from Microsoft.SharePoint.SPFeatureReceiver and implements all four events


using System;
using Microsoft.SharePoint;
namespace WROX
{
public class MyFirstFeatureReceiver : SPFeatureReceiver
{
    public override void FeatureActivated (SPFeatureReceiverProperties properties)
    {
    SPWeb site = properties.Feature.Parent as SPWeb;
    // save current site’s title
    site.Properties["SiteTitle"] = site.Title;
    site.Properties.Update();
    // change the site title
    site.Title = DateTime.Now.ToString();
    site.Update();
    }

    public override void FeatureDeactivating (SPFeatureReceiverProperties properties)
    {
    SPWeb site = properties.Feature.Parent as SPWeb;
    // reset the site’s title
    site.Title = site.Properties["SiteTitle"].ToString();
    site.Update();
    }

    public override void FeatureInstalled (SPFeatureReceiverProperties properties)
    {
    // do nothing
    }

    public override void FeatureUninstalling (SPFeatureReceiverProperties properties)
    {
    // do nothing
    }
}
}

Once the assembly containing the Feature receiver has been compiled and deployed to the GAC, the Feature must be configured to call the event handlers in the Feature receiver class. To do this, add two new attributes to the <> node in the feature.xml definition file: ReceiverAssembly , which contains the assembly ’ s strong name (aka its four - part name) and the ReceiverClass , which contains a fully qualified name to the Feature receiver,


< ?xml version=”1.0” encoding=”utf-8”? >
< Feature xmlns=”http://schemas.microsoft.com/sharepoint/”
Id=”32DECDEF-C37C-4ac3-BA65-D49639668E7C”
Title=”My First Feature”
Description=”The simplest Feature ever.”
Hidden=”FALSE”
Scope=”Web”
ReceiverAssembly=”MyFirstFeature, Version=1.0.0.0, Culture=neutral,
PublicKeyToken=c591e70cfdf9ce4f”
ReceiverClass=”WROX.MyFirstFeatureReceiver” >
< /Feature >

Features can only be installed in one of three ways: using STSADM.EXE , using WSS solution
packages (covered later in the chapter), or via the SharePoint API.

STSADM.EXE operation installfeature / uninstallfeature

stsadm.exe -o activatefeature -name myfirstfeature -url http://wss1

Another capability at the disposal of SharePoint developers and administrators is the visibility of a Feature. Within the Feature definition file, feature.xml , the < hidden=" ”"> attribute can be used to hide or show a Feature in the browser interface. By default, all Features are visible ( Hidden=FALSE ). When would a Feature need to be hidden? Consider a Feature that added functionality or a site element to a site collection; its activation state should not be delegated to site owners; instead, SharePoint farm administrators should be the ones required to activate or deactivate this special Feature for a site collection.

Feature Dependencies and Stapling Features


< ?xml version=”1.0” encoding=”utf-8”? >
< Feature xmlns=”http://schemas.microsoft.com/sharepoint/”
Id=”32DECDEF-C37C-4ac3-BA65-D49639668E7C”
Title=”My First Feature”
Description=”The simplest Feature ever.”
Hidden=”FALSE”
Scope=”Web” >
< ElementManifests >
< ElementManifest Location=”elements.xml”/ >
< /ElementManifests >
< ActivationDependencies >
< ActivationDependency FeatureId=”00BFEA71-7E6D-4186-9BA8-C047AC750105” / >
< /ActivationDependencies >
< /Feature >

Once a Feature has been stapled to a site template, any future sites
provisioned using the site template will automatically activate the stapled Feature. This enables
developers to customize site templates without actually changing the site template itself; instead they
can append functionality without touching the source files that make up the site template.


< ?xml version=”1.0” encoding=”utf-8”? >
< Elements xmlns=”http://schemas.microsoft.com/sharepoint/” >
< FeatureSiteTemplateAssociation Id=”32DECDEF-C37C-4ac3-BA65-D49639668E7C”
TemplateName=”STS#1” / >
< /Elements >

Creating Features Using Visual Studio

When using Visual Studio to create projects, use either the VB.NET/C# Class Library (when creating a Feature that contains any compiled code) or the Empty Project template (when the Feature won ’ t contain any compiled code). With a project created, mimic the folder structure under the SharePoint 12 folder in the project.

A WSS solution package contains two things: all the files required in the deployment and an instruction file telling SharePoint what to do with these files. Everything is packaged together into a Microsoft cabinet file with a file extension of *.WSP (for WSS solution package). This package is then added to the SharePoint farm ’ s solution store using STSADM.EXE .

Assemblies
Anything to the SharePoint 12 folder
Custom Code Access Security policies CAS policies are typically stored in the [..]\12\
CONFIG folder, but what is special about the WSS solution package deployment method is that developers include what additions to make to a CAS policy and SharePoint adds the changes to a copy of the currently used CAS policy
Web Part definitions and resource - Deployment of Web Parts can include many different
files. Web Part definition files ( *.webpart ) can be deployed to a site collection ’ s Web Part
Gallery (to deploy a Web Part to a specific site collection) or to the wpcatalog directory within a Web application ’ s webroot on the file system (to deploy the Web Part to all site collections within a SharePoint extended Web application).

MOSS Development 3

2010-05-23T04:00:00.001-07:00

Collaboration — Document libraries/tasks/calendars, blogs, wikis, e - mail integration, project management “ lite, ” Office Outlook 2007 integration, offline documents, and lists.
Portal — Enterprise portal template, site directory, my sites, social networking, and privacycontrol .
Search — Enterprise scalability, contextual relevance, rich people and business data search
Content Management — Integrated document management, records management, WCM with policies and workflow .
Business Forms — Rich and Web - forms - based front ends, line of business (LOB) actions, pluggable single sign - on (SSO) .
Business Intelligence — Server - based Office Excel 2007 spreadsheets and data visualization, report center, BI Web Parts, key performance indicators (KPIs)/dashboards .

Microsoft.SharePoint.Publishing.PublishingSite

Provides access to Publishing Features on a SPSite object .

Microsoft.SharePoint.Publishing.PublishingWeb

Provides access to Publishing Features on a SPWeb object — e.g., accessing the pages collection,
accessing other objects in the hierarchy, or executing queries directly .

Microsoft.SharePoint.Publishing.PublishingPage

Provides access to Publishing Features on a SPListItem object. A page is an extended SPList object.

Enumerating Publishing sites


using System;
using System.ComponentModel;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Microsoft.SharePoint;
using Microsoft.SharePoint.Publishing;
namespace EnumerateSites
{
  public class EnumerateSitesInSiteCollection : WebControl
  {

      protected void ListWebs (PublishingWeb pubWeb, HtmlTextWriter output)
      {
          output.Write(string.Format("< A href=\"{0}\"> {1} < /A >", pubWeb.Url,pubWeb.Title));
          foreach (PublishingWeb childPubWeb in pubWeb.GetPublishingWebs())
          {
              ListWebs(childPubWeb, output);
          }
      }

      protected override void RenderContents (HtmlTextWriter output)
      {
          using (SPSite site = SPContext.Current.Site)
          {
              output.Write("< H1 > Sites in Site Collection < /H1 > < BR > ");
              foreach (SPWeb site in site.AllWebs)
              {
                  if (PublishingWeb.IsPublishingWeb(site))
                  {
                      PublishingWeb publishingWeb = PublishingWeb.GetPublishingWeb(site);
                      ListWebs(publishingWeb, output);
                  }
              }
          }
      }
  }
}

Creating Publishing sites


using (SPWeb web = SPControl.GetContextWeb(Context))
{
  PublishingWeb pubWeb = PublishingWeb.GetPublishingWeb(web);
  PublishingWeb newWeb = pubWeb.GetPublishingWebs().Add(“SiteName”);
  newWeb.Title = “Display Name”;
  newWeb.Description = “Description of Site”;
  newWeb.Update();
}

Creating Publishing pages


using (SPWeb web = SPControl.GetContextWeb(HttpContext.Current))
{
  PublishingWeb pubWeb = PublishingWeb.GetPublishingWeb(web);
  PageLayout layout = null;
  SPContentTypeId contentType = new SPContentTypeId();
  PageLayout[] layouts = pubWeb.GetAvailablePageLayouts(contentType);
  if (layouts != null & & layouts.Length > 0)
  {
      layout = layouts[0];
      PublishingPage newPage;
      newPage = pubWeb.GetPublishingPages().Add("SiteName", layout);
      newPage.Description = "Description of site";
      newPage.ListItem["Page Content"] = " Sample Content Here";
      newPage.Update();
  }
}

Setting properties and publishing pages


using (SPWeb web = SPControl.GetContextWeb(HttpContext.Current)) 
{
    PublishingWeb pubWeb = PublishingWeb.GetPublishingWeb(web);
    PageLayout layout = null;
    SPContentTypeId contentType = new SPContentTypeId();
    PageLayout[] layouts = pubWeb.GetAvailablePageLayouts(contentType);
    if (layouts != null & & layouts.Length > 0) 
    {
        layout = layouts[0];
        PublishingPage newPage;
        newPage = pubWeb.GetPublishingPages().Add("SiteName", layout);
        newPage.Description = "Description of site";
        newPage.ListItem["Page Content"] = " Sample Content Here";
        newPage.Update();
    }
}

MOSS Development 2

2010-05-21T02:10:00.001-07:00

There are essentially four different administration interfaces within a SharePoint environment:

Central Administration

[This site is primarily used by farm administrators to manage all the servers in the SharePoint server farm, as well as the SharePoint services on those servers.],

Site Settings
[Users can be assigned as the owners of site collections, with
the authority to administer the site, but not granted rights to the Central Administration site.]
[The Site Settings page is accessible from the Site Actions menu or by
entering the URL http://[site URL]/_layouts/settings.aspx; security of a site, create new lists and libraries, customize the site ’ s navigation,
manage the site columns and content types, and activate/deactivate site - scoped Features.]

List Settings
[From the List Settings page, users can also configure the workflow
settings, such as associating workflow templates previously deployed to the site collection with the
list, and configure their startup options, such as automatically when new list items are created or
updated, or manually. Users]
,
STSADM.EXE
[Every
WSS 3.0 install includes STSADM.EXE , which can be found in the following directory: c:\Program
Files\Common Files\Microsoft Shared\web server extensions\12\bin\ . STSADM.EXE is
based on the premise of operations.]

stsadm.exe – help enumformtemplates

Master Pages
All SharePoint sites are based on the same
initial master page called default.master found in the [..]\12\TEMPLATE\GLOBAL directory
This master page contains many content placeholders required in most master pages leveraged within SharePoint.

Membership Provider Model
Moreover, SharePoint provides an additional capability
that enables multiple entry points into a single site collection via different URLs, each configured with
a different authentication mechanism, such as Active Directory, forms - based authentication, or LDAP

Code Access Security
Code access security (CAS), included with the .NET Framework, enables developers and administrators to grant specific permissions and rights to managed code. Another type of security most people are familiar with is user - based security, whereby code assumes the rights and permissions that the current user has been assigned. Using CAS effectively enables administrators to restrict what managed code is allowed to do, limiting the surface area of attack and vulnerability on a system.

By default, new SharePoint Web applications are configured to run within a very low and restricted level of trust called WSS_Minimal . For example, some things are not possible out - of - the - box (OOTB), such as consuming a Web service that exists outside the current domain or connecting to a SQL Server database.

Create a custom CAS policy that assigns the necessary permissions to the assembly(s) containing the managed code attempting to perform such an action.
Change the SharePoint Web application CAS policy from WSS_Minimal to WSS_Medium or Full (which is the least secure and most pervasive). This affects all assemblies within the Web application, not just the specific assembly needing elevated permissions.
Deploy the assembly containing the managed code attempting to perform such an action to
the server ’ s GAC, thus granting the assembly full trust and making it globally available
on the server.

Safe Mode Parser

While ASP.NET 2.0 sites generally live on the file system, SharePoint sites are virtualized within a content database. These virtualized files exist in one of two states: customized or uncustomized.

Types of Pages

While SharePoint is built on top of ASP.NET 2.0, it has a unique concept of two types of pages: site pages and application pages .

Site pages are those types of pages that support customization or personalization, and thus can be themed and host Web Parts. These are also the types of pages that developers and designers can modify and edit within SharePoint Designer, because they are virtualized within the site ’ s logical architecture and live within the site collection ’ s content database either as customized or uncustomized pages.

Application Pages live within the layouts virtual directory that exists within each SharePoint site. Applications pages, unlike site pages, cannot be customized or personalized, as these files do not live within a site ’ s content database. This explains why the layouts virtual directory is not seen within SharePoint Designer.

When a new SharePoint site is provisioned, either when it is created as the top - level site within a new site collection or as a subsite within an existing site collection, most files start off in an uncustomized state. This means that while the file lives within the logical structure of a SharePoint site and is seen from within SharePoint Designer (and thus, is in the content database), the entry in the content database simply points to the file it is based off of on the file system. This file is sometimes referred to as a template file or file definition because by itself it is not very usable.

The most common way to customize a file is to open it in SharePoint Designer, make any changes, and then save the file. When someone saves a file in SharePoint Designer, the source of the updated file is saved to the content database.

Subsequent requests for the file result in the SPVirtualPathProvider (SharePoint ’ s custom
virtual path provider) retrieving the source of the file from the content database, rather than the file system.
http://msdn.microsoft.com/en-us/library/bb892189%28office.12%29.aspx (to read)


using System;
using System.IO;
using Microsoft.SharePoint;
namespace Listing2_a
{
class Program
{
  static void Main (string[] args)
  {
  using (SPSite siteCollection = new SPSite("http://wss"))
  {
      using (SPWeb site = siteCollection.RootWeb)
      {
          MemoryStream fileStream = new MemoryStream();
          StreamWriter fileWriter = new StreamWriter(fileStream);
          // write the source of the page (include meta:progid so SharePoint    Designer understands this file
          fileWriter.WriteLine("< %@ Page MasterPageFile=\"~masterurl/default.master\" meta:progid=\”SharePoint.WebPartPage.Document\" % >");
          fileWriter.WriteLine("< asp:Content runat=\"server\" ContentPlaceHolderID=\”PlaceHolderMain\">");
          fileWriter.WriteLine("< h1 > WROX < /h1 > ");
          fileWriter.WriteLine("< /asp:Content > ");
          fileWriter.Flush();
          // save the file to SharePoint
          site.Files.Add("ApiGeneratedPage.aspx", fileStream);
          // cleanup
          fileWriter.Close();
          fileWriter.Dispose();
          fileStream.Close();
          fileStream.Dispose();
      } // SPWeb using statement
  } // SPSite using statement
} // method “Main”
}
}


using System;
using Microsoft.SharePoint;
namespace Listing2_b
{
class Program
{
    static void Main (string[] args)
    {
        using (SPSite siteCollection = new SPSite("http://wss"))
        {
            using (SPWeb site = siteCollection.RootWeb)
            {
                SPFile file = site.GetFile(“default.aspx”);
                // if file is customized, revert to underlying template file
                if (file.CustomizedPageStatus == SPCustomizedPageStatus.Customized)
                file.RevertContentStream();
            } // SPWeb using statement
        } // SPSite using statement
    } // method “Main”
}
}

SharePoint Customization

As previously covered, when files are customized, they exist within the SharePoint site ’ s content database. While some may have originally been based on an underlying template, the source of the customized file still lives within the database.

SharePoint Development

In order to keep files within a SharePoint site uncustomized, they must be created as physical files on the file system.

Microsoft.SharePoint Namespace

The SharePoint API is how the provided tools and interfaces interact with SharePoint, including
the browser - based interface, the included Web services, and the command - line utility STSADM.EXE .

The core of the SharePoint API is the Microsoft.SharePoint namespace, which is found in the
Microsoft.SharePoint.dll assembly located in [..]\12\ISAPI .

Microsoft.SharePoint namespace
SPSite => for site collections
SPWeb =>for SharePoint sites.
SPList =>for lists,
SPListItem =>for items within lists,
SPDocumentLibrary =>for documents within document libraries,
SPQuery=> for creating queries using Collaborative Markup Language (CAML),
SPGroup and SPUser =>for SharePoint groups and users, respectively.

Debugging assemblies deployed to the Global Assembly Cache (GAC) is a bit more challenging and requires some additional work. Before attaching the debugger to the application pool process, the debugger symbols ( *.PDB files) must be copied to a specific directory. To find the directory, select Start Run and enter the following:

%systemroot%\Assembly\GAC

MOSS Development 1

2010-05-20T23:29:00.000-07:00

When installing SharePoint, all the application files are installed into a directory nested deep within the
Program Files path: c:\Program Files\Common Files\Microsoft Shared\web server
extensions\12

Web applications are used
as the HTTP entry point to a SharePoint site and define certain aspects that are shared across all
SharePoint sites hosted within the Web application, such as HTTP handlers and modules, authentication
configuration, and a list of which controls have been registered with SharePoint ’ s safe mode page parser.

The location of sharepoint dlls are in

C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\ISAPI

_vti_bin — This exposes SharePoint Web services and assemblies to SharePoint and
non - SharePoint applications alike; this virtual directory points to the path c:\Program Files\Common Files\Microsoft Shared\web server extensions\12\ISAPI (sharepoint default features)
_controltemplates — This points to a shared folder within the SharePoint 12 directory structure that only contains (user defined)ASP.NET 2.0 user controls; this virtual directory points to the path c:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\CONTROLTEMPLATES .
_layouts — This points to a shared folder within the SharePoint 12 directory structure
containing application pages, this virtual directory points to the path c:\Program Files\Common Files\Microsoft Shared\web server extensions\
12\TEMPLATE\LAYOUTS
_wpresources — This points to a shared folder that contains resources used by Web Partsdeployed globally to the server; this virtual directory points to the path c:\Program Files\Common Files\Microsoft Shared\web server extensions\wpresources .
The SharePoint 12 folder contains everything necessary to run MOSS and WSS, including
Features , images, Cascading Style Sheets (CSS), Web services, and all assemblies
containing the compiled logic necessary for SharePoint to execute

SDK - Administration:


using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using Microsoft.SharePoint;
using Microsoft.SharePoint.Administration;

namespace WindowsFormsApplicationSharePoint
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            SPWebApplication oWebApplication = SPWebApplication.Lookup(new Uri("http://one:34349"));
            oWebApplication.MaximumFileSize = 100;
            oWebApplication.AlertsMaximum = 1000;
            oWebApplication.Update();
        }
    }
}

As previously stated, site collections are used for both administrative and management purposes.
However, at their core, SharePoint site collections simply contain SharePoint sites. When a new site
collection is created, the user is immediately directed to enter information such as the display name, the
description, and the owner of the site. This site is called the top - level or root site within the site collection.

Developers can use the Microsoft.SharePoint.SPSite class to obtain a reference to an existing site
collection, and Microsoft.SharePoint.SPWeb to obtain a reference to a site within a site collection.

SPWebApplication Class
Represents an Internet Information Services (IIS) load-balanced Web application that is installed on the server farm

SPSite Class
Represents a collection of sites in a Web application, including a top-level Web site and all its subsites. Each SPSite object, or site collection, is represented within an SPSiteCollection object that consists of the collection of all site collections in the Web application


 private void button3_Click(object sender, EventArgs e)
        {
            SPSite oSiteCollection = new SPSite("http://one:34349");
            SPWebCollection collWebsites = oSiteCollection.AllWebs;
            StringBuilder sb = new StringBuilder();
            sb.Append( "Total Num of SPWebCollection : " + collWebsites.Count.ToString());
            int i = 0;
            foreach (SPWeb oWebsite in collWebsites)
            {
                i = i + 1;
                sb.Append("\r\n Num + "+i.ToString()+" SPWeb Description : " + oWebsite.Description);
                SPListCollection collLists = oWebsite.Lists;
                sb.Append("\r\n Num + " + i.ToString() + " SPListCollection Count : " + collLists.Count.ToString());
                foreach (SPList oList in collLists)
                {
                    int j = 0;
                    if (oList.BaseType == SPBaseType.DocumentLibrary)
                    {
                        j = j + 1;
                        
                        sb.Append("\r\n  ------ " + " SPList Name : " + oList.Description);
                        try
                        {
                            //cast list item to document library
                            SPDocumentLibrary oDocumentLibrary = (SPDocumentLibrary)oList;
                            if (!oDocumentLibrary.IsCatalog && oList.BaseTemplate != SPListTemplateType.XMLForm)
                            {
                                 SPListItemCollection collListItems = oDocumentLibrary.Items;
                                 sb.Append("\r\n  -------- " + " SPListItemCollection Count : " + collListItems.Count.ToString());

                                 foreach (SPListItem oListItem in collListItems)
                                 {
                                     sb.Append("\r\n  ---------------- SPListe Name  " + oListItem.Name);
                                 }

                            }
                        }
                        catch (Exception ex)
                        {
                            MessageBox.Show(ex.ToString());
                        }
                    }
                }
                oWebsite.Dispose();
            }
            label1.Text = sb.ToString();
        }

MOSS 2007 administration

2010-05-19T00:51:00.000-07:00

asp.net has the ability to ensure that pages are not compiled into a dynamic link library before wss 3 can use them, instead, the page is parsed and the allowed conrols in the control tree are rendered on the page.

web parts : a custom control assembly that uses a web part description file in either the wss (.dwp) or the asp.net 2 format (.webpart)
the web part description file can be stored and referenced on any computer; it contains xml data that describs an instance of the web part, the web part .net assembly is a dll that must be installed and registered on each wss computer the uses the web part.

Metadata : it provides context for data so taht it can be interpreted and understodd when it comes time to use it. Metadata also supports the ability to intelligently index and quickly search large databases by automating the classificiation and organization of like kinds of information.

Versioning :
1) major / minor versioning, only major versions can be published. Minor versions can be viewed by thos who have the right to view the monior versions of the document or list item, but these versions cannot be published, nor can they be viewed by those who have only rader access to this list.

2) Simple versioning, each version is a full copy of the document and the versions are numbered sequentially.

Check out :
Draft (minor version):
Published (major version):

Versioning : it allows user to tell the system which changes are minor chagnes and which changes are major chagnes to a document.

Auditing is the process of tracking which user made a change to a document, regardless of the importance of that change.

__________________________________________________________________

- Content and metadata for crawled content is held in sql content databases
- The binaries for the program are held on the file server - by default in c:\program files\office sharepoint server\bin
- The content indexes are helf on the file serve - by default, in c:\program files\office sharepoint server \data
-The web application files are held on the file server - by default, in c:\intpub\wwwroot\wss\virtualdirectories
-The configuration information for the web application is held in the metabase.
- The farm configuration information is held in the sql configdb database

Backup and disk space:

-1 gb of data will need 1 gb of disk space
-another 1gb of free disk space is needed for sql maintenance utilities to run propertly, need 100% free disk space relative to the size of your largest database.
-you'll be indexing this data, so assume your index is 20 % percent the size of the content being indexed, actual figures ranging from as little as 10% up to as high as 40%. In this example, assume you need one search server and two query servers, which means you'ill need 400mb of disk space because the index will be held twice, once of the search server and once on the query server.
- your farm will need to be backed up, in this example, consumes another 1.2 gb of disk space.
You will need 3.8 gb of disk space for every 1gb of data.

__________________________________________________________

pluggable authentication

single sign o authentication,replacing default sso in sharepoint 2007 invoves implementing the microsoft.sharepoint.portal.singlesinon.issoprovider interface.

Although all the binary code is installed on each server, the Topology manager ensures that each server has "turn on" or "turn off" thos portions of the code that are reuiqred or nto needed for the server to fulfill its assigned duties in the farm.

MOSS logical architecture can by physically deployed to a single machine serving as all three tiers environment, or on any number of machines serving one or more of the tiers cooperatively.

(p.81)

http://www.greydc.govt.nz/ is alive !

2010-05-17T21:03:00.000-07:00

http://www.greydc.govt.nz/ is alive today ! Another one of my EPIServer projects is in production ..... happy happy ...

Firebug repository

2010-05-03T18:46:00.000-07:00

Firebug repository
http://getfirebug.com/releases/firebug/1.5X/

JQuery + URL Plugin

2010-04-25T14:48:00.000-07:00

I need to use Jquery to do some URL value changing in my current project.

Found some libraries that do that :

http://plugins.jquery.com/project/query-object

http://www.oakcitygraphics.com/jquery/jqURL/jqURLdemo.html?var1=1&var2=2&var3=3

This one is not Jquery Library :

http://www.htmlgoodies.com/beyond/javascript/article.php/11877_3755006_3

.NET Framework Reflection

2010-04-15T18:04:00.000-07:00

http://msdn.microsoft.com/en-us/magazine/cc163759.aspx

(Applied Reflection: Creating a dynamic Web service to simplify code)
http://www.crowsprogramming.com/archives/66

Http Handler CompressionModule

2010-04-14T20:28:00.001-07:00


#region Using

using System;
using System.IO;
using System.IO.Compression;
using System.Net;
using System.Web;
using System.Web.UI;

#endregion

namespace Cff.SaferTrader.Web
{
    /// <summary>
    /// Compresses the output using standard gzip/deflate.
    /// Ported from http://blog.madskristensen.dk/post/HTTP-compression-of-WebResourceaxd-and-pages-in-ASPNET.aspx
    /// </summary>
    public sealed class CompressionModule : IHttpModule
    {
        private const string DEFLATE = "deflate";
        private const string GZIP = "gzip";

        /// <summary>
        /// Compress the page when the request is not an AJAX request and the response is not an excel file
        /// </summary>
        private static void context_PreSendRequestContent(object sender, EventArgs e)
        {
            HttpApplication application = (HttpApplication)sender;
            if (application.Context.CurrentHandler is Page
                && application.Request["HTTP_X_MICROSOFTAJAX"] == null
                && !application.Response.ContentType.Equals("application/xls")
                && !application.Response.ContentType.Equals("application/xlsx"))
            {
                if (IsEncodingAccepted(DEFLATE))
                {
                    application.Response.Filter = new DeflateStream(application.Response.Filter, CompressionMode.Compress);
                    SetEncoding(DEFLATE);
                }
                else if (IsEncodingAccepted(GZIP))
                {
                    application.Response.Filter = new GZipStream(application.Response.Filter, CompressionMode.Compress);
                    SetEncoding(GZIP);
                }
            }
        }

        private static bool IsEncodingAccepted(string encoding)
        {
            bool isEncodingAccepted = false;
            HttpContext context = HttpContext.Current;
            if (context != null)
            {
                isEncodingAccepted = context.Request.Headers["Accept-encoding"] != null &&
                   context.Request.Headers["Accept-encoding"].Contains(encoding);
            }
            return isEncodingAccepted;
        }

        private static void SetEncoding(string encoding)
        {
            HttpContext.Current.Response.AppendHeader("Content-encoding", encoding);
        }

        /// <summary>
        /// Compress WebResource.axd
        /// </summary>
        private static void context_BeginRequest(object sender, EventArgs e)
        {
            var app = (HttpApplication) sender;
            if (app.Request.Path.Contains("WebResource.axd"))
            {
                SetCachingHeaders(app);

                if (IsBrowserSupported() && app.Context.Request.QueryString["c"] == null &&
                    (IsEncodingAccepted(DEFLATE) || IsEncodingAccepted(GZIP)))
                    app.CompleteRequest();
            }
        }
        
        private static void context_EndRequest(object sender, EventArgs e)
        {
            if (!IsBrowserSupported() || (!IsEncodingAccepted(DEFLATE) && !IsEncodingAccepted(GZIP)))
                return;

            var app = (HttpApplication) sender;
            string key = app.Request.QueryString.ToString();
            if (app.Request.Path.Contains("WebResource.axd") && app.Context.Request.QueryString["c"] == null)
            {
                if (app.Application[key] == null)
                {
                    AddCompressedBytesToCache(app, key);
                }

                SetEncoding((string)app.Application[key + "enc"]);
                app.Context.Response.ContentType = "text/javascript";
                app.Context.Response.BinaryWrite((byte[]) app.Application[key]);
            }
        }

        /// <summary>
        /// Sets the caching headers and monitors the If-None-Match request header,
        /// to save bandwidth and CPU time.
        /// </summary>
        private static void SetCachingHeaders(HttpApplication app)
        {
            string etag = "\"" + app.Context.Request.QueryString.ToString().GetHashCode() + "\"";
            string incomingEtag = app.Request.Headers["If-None-Match"];

            app.Response.Cache.VaryByHeaders["Accept-Encoding"] = true;
            app.Response.Cache.SetExpires(DateTime.Now.AddDays(30));
            app.Response.Cache.SetCacheability(HttpCacheability.Public);
            app.Response.Cache.SetLastModified(DateTime.Now.AddDays(-30));
            app.Response.Cache.SetETag(etag);

            if (String.Compare(incomingEtag, etag, StringComparison.OrdinalIgnoreCase) == 0)
            {
                app.Response.StatusCode = (int) HttpStatusCode.NotModified;
                app.Response.End();
            }
        }

        /// <summary>
        /// Check if the browser is Internet Explorer 6 that have a known bug with compression
        /// </summary>
        /// <returns></returns>
        private static bool IsBrowserSupported()
        {
            // Because of bug in Internet Explorer 6
            HttpContext context = HttpContext.Current;
            return !(context.Request.UserAgent != null && context.Request.UserAgent.Contains("MSIE 6"));
        }

        /// <summary>
        /// Adds a compressed byte array into the application items.
        /// <remarks>
        /// This is done for performance reasons so it doesn't have to
        /// create an HTTP request every time it serves the WebResource.axd.
        /// </remarks>
        /// </summary>
        private static void AddCompressedBytesToCache(HttpApplication app, string key)
        {
            var request = (HttpWebRequest) WebRequest.Create(app.Context.Request.Url.OriginalString + "&c=1");
            using (var response = request.GetResponse() as HttpWebResponse)
            {
                if (response != null)
                {
                    
                    Stream responseStream = response.GetResponseStream();
                    using (MemoryStream ms = CompressResponse(responseStream, app, key))
                    {
                        byte[] buffer = ms.ToArray();
                        if (buffer.Length == 0)
                        {
                            buffer = new[] { byte.MinValue };
                        }
                        app.Application.Add(key, buffer);
                    }
                }
            }
        }

        /// <summary>
        /// Compresses the response stream if the browser allows it.
        /// </summary>
        private static MemoryStream CompressResponse(Stream responseStream, HttpApplication app, string key)
        {
            var dataStream = new MemoryStream();
            StreamCopy(responseStream, dataStream);
            responseStream.Dispose();

            byte[] buffer = dataStream.ToArray();
            dataStream.Dispose();

            var ms = new MemoryStream();
            Stream compress = null;

            if (IsEncodingAccepted(DEFLATE))
            {
                compress = new DeflateStream(ms, CompressionMode.Compress);
                app.Application.Add(key + "enc", DEFLATE);
            }
            else if (IsEncodingAccepted(GZIP))
            {
                compress = new GZipStream(ms, CompressionMode.Compress);
                app.Application.Add(key + "enc", GZIP);
            }

            if (compress != null)
            {
                compress.Write(buffer, 0, buffer.Length);
                compress.Dispose();
            }
            return ms;
        }

        /// <summary>
        /// Copies one stream into another.
        /// </summary>
        private static void StreamCopy(Stream input, Stream output)
        {
            var buffer = new byte[2048];
            int read;
            do
            {
                read = input.Read(buffer, 0, buffer.Length);
                output.Write(buffer, 0, read);
            } while (read > 0);
        }

        #region IHttpModule Members

        /// <summary>
        /// Disposes of the resources (other than memory) used by the module 
        /// that implements <see cref="T:System.Web.IHttpModule"></see>.
        /// </summary>
        void IHttpModule.Dispose()
        {
            // Nothing to dispose; 
        }

        /// <summary>
        /// Initializes a module and prepares it to handle requests.
        /// </summary>
        /// <param name="context">An <see cref="T:System.Web.HttpApplication"></see> 
        /// that provides access to the methods, properties, and events common to 
        /// all application objects within an ASP.NET application.
        /// </param>
        void IHttpModule.Init(HttpApplication context)
        {
            // For WebResource.axd compression
            context.BeginRequest += context_BeginRequest;
            context.EndRequest += context_EndRequest;
            context.PreSendRequestContent += context_PreSendRequestContent;
        }

        #endregion
    }
}

.NET Framework Reflection Assemblies and Modules Multi files Assembly

2010-04-13T00:55:00.000-07:00

Download sources code of producing (Multi file assembly)

Use as infinite loops

2010-04-06T17:36:00.000-07:00


        private void PRSDK_EnumerateDevices(ref List<string> names)
        {
            UInt32 err = (UInt32)prError.prOK;
            UInt32 bufSize = 0;
            prType.prDeviceList pGetDevList = new prType.prDeviceList();

            for (; ; )
            {
                /* Enumerate camera devices by PS-ReC SDK */
                err = prAPI.PR_GetDeviceList(ref bufSize, ref pGetDevList);
                if (err == (UInt32)prError.prOK)
                {
                    break;
                }
                if ((err & (UInt32)prError.prERROR_ERRORID_MASK) != (UInt32)prError.prINSUFFICIENT_BUFFER)
                {
                    HandleError("PR_GetDeviceList", err);
                    return;
                }
            }

            if (pGetDevList.NumList > 0)
            {
                for (int i = 0; i < (pGetDevList.NumList); i++)
                {
                    // Create a SDKInfo structure for each DeviceInfo object in the device list
                    SDKInfo pDeviceInfo = new SDKInfo();
                    pDeviceInfo.SelectedSDK = SDKType.PRSDK;
                    pDeviceInfo.PRSDK_Src = pGetDevList.DeviceInfo[i];

                    // Add the SDKInfo object to the devices arraylist
                    names.Add(pDeviceInfo.PRSDK_Src.ModelName);
                    devices.Add(pDeviceInfo);
                }
            }

        }

Stream Buffer

2010-04-06T16:15:00.000-07:00

Just to remind myself about Reading Stream, Buffer

http://www.yoda.arachsys.com/csharp/readbinary.html

/// <summary>

/// Reads data from a stream until the end is reached. The

/// data is returned as a byte array. An IOException is

/// thrown if any of the underlying IO calls fail.

/// </summary>

/// <param name="stream">The stream to read data from</param>

public static byte[] ReadFully (Stream stream)

{

byte[] buffer = new byte[32768];

using (MemoryStream ms = new MemoryStream())

{

while (true)

{

int read = stream.Read (buffer, 0, buffer.Length);

if (read <= 0)

return ms.ToArray();

ms.Write (buffer, 0, read);

}

}

}

WSS SharePoint site Remove 'View All Site Content' on home page

2010-04-06T16:12:00.000-07:00

Here is an excellent article about how to do that :

http://www.crsw.com/mark/Lists/Posts/Post.aspx?ID=36

Click Once Application

2010-04-06T00:07:00.001-07:00

Windows XP, Windows Server 2003 - clean install (and upgrades from Windows 2000 and Windows 98)
Roaming-enabled stores =
\Documents and Settings\\Application Data
Nonroaming stores =
\Documents and Settings\\Local Settings\Application Data

IsolatedStorageFileStream :


  private void RecordDateTimeInstalled()
        {
            //IsolatedStorageFile isoFile = IsolatedStorageFile.GetStore(IsolatedStorageScope.User IsolatedStorageScope.Assembly IsolatedStorageScope.Domain,typeof(System.Security.Policy.Url),typeof(System.Security.Policy.Url));
            //using (IsolatedStorageFile isoFile = IsolatedStorageFile.GetUserStoreForApplication())
            using (IsolatedStorageFile isoFile = IsolatedStorageFile.GetStore(IsolatedStorageScope.User  IsolatedStorageScope.Assembly  IsolatedStorageScope.Domain, typeof(System.Security.Policy.Url), typeof(System.Security.Policy.Url)))
            {
                if (isoFile.GetDirectoryNames("jefferycxl").Length == 0)
                {
                    isoFile.CreateDirectory("jefferycxl");
                }
                using (IsolatedStorageFileStream strm1 = new IsolatedStorageFileStream(@"jefferycxl\AFWTEST.Desktop.Data", FileMode.Create, isoFile))
                {
                    BinaryFormatter bf1 = new BinaryFormatter();
                    bf1.Serialize(strm1, DateTime.Now);
                }
            }
        }

        private string ReadInstalledRecored()
        {
            string s = string.Empty;
            DateTime dt = DateTime.MinValue;
            //using (IsolatedStorageFile store = IsolatedStorageFile.GetUserStoreForApplication())
            using(IsolatedStorageFile store = IsolatedStorageFile.GetStore(IsolatedStorageScope.User  IsolatedStorageScope.Assembly  IsolatedStorageScope.Domain, typeof(System.Security.Policy.Url), typeof(System.Security.Policy.Url)))
            {
                using (IsolatedStorageFileStream source = new IsolatedStorageFileStream(@"jefferycxl\AFWTEST.Desktop.Data", FileMode.Open, store))
                {
                    BinaryFormatter bf = new BinaryFormatter();
                    dt = Convert.ToDateTime(bf.Deserialize(source));
                    s = dt.ToString() + "Is the source file readable?" +  (source.CanRead ? "true" : "false") +  " Current Data Size : " + store.CurrentSize.ToString() + " Maximum Size : " + store.MaximumSize.ToString() + " Scope : " + store.Scope.ToString();
                }
            }
            return s;
        }

Open XML SDK

2010-04-04T02:46:00.000-07:00

http://msdn.microsoft.com/en-us/library/documentformat.openxml.openxmlelement_members(v=office.14).aspx

http://blogs.msdn.com/brian_jones/default.aspx

http://msdn.microsoft.com/library/bb508943.aspx#XL2007OpenXMLInsertingValueIntoCell_CodeIt

JQuery

2010-04-03T20:23:00.000-07:00


$("p:even");
This selector selects all even <p> elements.
$("tr:nth-child(1)");
This selector selects the first row of each table.
$("body > div");
This selector selects direct <div> children of <body>.
$("a[href$=pdf]");
This selector selects links to PDF files.
$("body > div:has(a)")
This selector selects direct <div> children of <body>-containing links.

Microsoft US - Open XML Developer

2010-03-30T18:24:00.000-07:00

https://openxmldeveloper.org/

Join me on this site and explore open xml !

Basic Heap vs. Stack

2010-03-30T15:44:00.001-07:00

http://www.c-sharpcorner.com/UploadFile/rmcochran/csharp_memory01122006130034PM/csharp_memory.ASPx

SharePoint + CAML

2010-03-30T15:31:00.001-07:00

http://msdn.microsoft.com/en-us/library/dd588092(v=office.11).aspx

ASP.NET Export DataTable To CSV file

2010-03-29T20:45:00.000-07:00

Piece of code from microsoft demo project, just to remind myself.
  public void ExportCSV(DataTable data, string fileName)
  {

    HttpContext context = HttpContext.Current;

    context.Response.Clear();
    context.Response.ContentType = "text/csv";
    context.Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName + ".csv");

    //rite column header names
    for (int i = 0; i < data.Columns.Count - 1; i++)
    {
      if (i > 0)
      {
        context.Response.Write(",");
      }
      context.Response.Write(data.Columns[i].ColumnName);
    }
    context.Response.Write(Environment.NewLine);

    //Write data
    foreach (DataRow row in data.Rows)
    {

      for (int i = 0; i < data.Columns.Count - 1; i++)
      {
        if (i > 0)
        {
          context.Response.Write(",");
        }
        context.Response.Write(data.Columns[i].ColumnName);
      }
      context.Response.Write(Environment.NewLine);
    }
    context.Response.End();

  }

ADO.NET part 2

2010-03-29T19:47:00.001-07:00


OleDb - access SQL Server 6.5 (and earlier versions), SyBase, DB2/400, and Microsoft Access.

Odbc - general-purpose data access to many data sources. This provider is typically used when no newer provider is available.
//excel database

SQL Server - lasses are tuned for SQL Server 7.0 and later data access. SQL Server 6.5 and earlier must use the OleDb provider

Oracle - This provider is similar to the OleDb provider but provides better performance.





base classes :

DbConnection
DbCommand
DbDataReader
DbTransaction
DbParameter
DbParameterCollection
DbDataAdapter
DbCommandBuilder
DbConnectionStringBuilder
DBDataPermission


sqlclient classes ;

SqlConnection
SqlCommand
SqlDataReader
SqlTransaction
SqlParameter
SqlParameterCollection
SqlDataAdapter
SqlCommandBuilder
SqlConnectionStringBuilder
SqlPermission


You can close the connection by executing the Close method or by executing the Dispose method. It’s common to create a “using” block to force the Dispose method to execute,


using (connection)
{ connection.Open();
//cool commands here... 
}

Driver={Microsoft Text Driver (*.txt; *.csv)};DBQ=C:\\Sample\\MySampleFolder;

Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\\program files\\mySampleApp\\northwind.mdb

//oracle database
Driver={Microsoft ODBC for Oracle};Server=ORACLE8i7;UID=john;PWD=s3$W%1Xz

Driver={Microsoft Excel Driver (*.xls)}; DBQ=C:\\Samples\\MyBook.xls

Working with Sample OLEDB Connection Strings This connection string uses the settings stored in the MyAppData.udl file. (The .udl extension stands for universal data link.)
FILE NAME=C:\Program Files\MyApp\MyAppData.udl


Encrypt - A setting in which, if Encrypt is set to true and SQL Server has a certificate installed, all communication between the client and server is SSL-encrypted.


Integrated Security, trusted_connection - A secure connection to SQL Server, in which authentication is via the user’s domain account. Can be set to
true, false, or sspi. The default is false.


Working with Connection Pools Creating and opening a connection to a data store can be a time-consuming and resource-intensive proposition, especially on Web-based systems, if you require separate connections to the data store on a user-by-user basis. It’s easy to get into a situation where every user has one or more open connections to the database and the database server is consuming too many resources just managing connections. Ideally, the data store should be spending most of its time delivering data and as little time as possible maintaining connections. This is where connection pooling can help.

Where Is the Pool Located? Connection pooling is a client-side technology, which means that the connection pool exists on the machine that initiates the DbConnection object’s Open statement. The database server has no idea that there might be one or more connection pools involved in your application.
When Is the Pool Created? A connection pool group is an object that manages the connection pools for a specific ADO.NET provider. When the first connection is instantiated, a connection pool group is created, but the first connection pool is not created until the first connection is opened.
Do Connections Stay in the Pool? A connection is removed from the pool of available connections for use and then returned to the pool of available connections. When a connection is returned to the connection pool, it has a default idle lifetime of four to eight minutes, which is an intentionally random time span to ensure that idle connections are not held indefinitely. You can set the connection string’s Min Pool Size to one or greater when you want to make sure that at least one connection is available when your application is idle for long periods.



//C#
protected void Button10_Click(object sender, EventArgs e)
{ Label lbl = GetLabel(275, 20); ConnectionStringSettings pubs =
ConfigurationManager.ConnectionStrings["PubsDataMars"];
DbConnection connection = new SqlConnection(pubs.ConnectionString);
DbCommand cmd = connection.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT au_id, au_lname, au_fname FROM Authors";
connection.Open();
DbDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
DbCommand salesCmd = connection.CreateCommand();
salesCmd.CommandType = CommandType.Text;
salesCmd.CommandText =
"SELECT SUM(royaltyper) FROM titleauthor WHERE (au_id = @auId)";
DbParameter parm = salesCmd.CreateParameter();
parm.ParameterName = "@auId";
parm.Value = (string)rdr["au_id"];
salesCmd.Parameters.Add(parm);
object qtyRoyalties = salesCmd.ExecuteScalar();
lbl.Text += (string)rdr["au_lname"] + ", " + (string)rdr["au_fname"]
+ ": " + string.Format("{0:C}",qtyRoyalties) + "<br />";
}
connection.Close();
}



//C#
protected void Button11_Click(object sender, EventArgs e) { ConnectionStringSettings pubs = ConfigurationManager.ConnectionStrings["PubsData"]; DbConnection connection = new SqlConnection(pubs.ConnectionString); ConnectionStringSettings bulkCopy = ConfigurationManager.ConnectionStrings["PubsData"]; SqlConnection bulkCopyConnection =
new SqlConnection(bulkCopy.ConnectionString);
DbCommand cmd = connection.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT stor_name FROM Stores";
connection.Open();
bulkCopyConnection.Open();
//make sure that table exists and is empty
//in case button is clicked more that once
SqlCommand cleanup = bulkCopyConnection.CreateCommand();
cleanup.CommandText =
"IF EXISTS ( SELECT * FROM sys.objects "
+
" WHERE object_id = OBJECT_ID('dbo.StoreList') "
+
" AND type in ('U')) "
+
"DROP TABLE dbo.StoreList "
+ "CREATE TABLE dbo.StoreList(stor_name varchar(40) NOT NULL )";
cleanup.ExecuteNonQuery();
//do the bulkcopy
DbDataReader rdr = cmd.ExecuteReader();
SqlBulkCopy bc = new SqlBulkCopy(bulkCopyConnection);
bc.DestinationTableName = "StoreList";
bc.WriteToServer(rdr);
connection.Close();
bulkCopyConnection.Close();
Label lbl = GetLabel(275, 20);
lbl.Text = "Done with bulk copy";
}

//C#
protected void Button13_Click(object sender, EventArgs e) { ConnectionStringSettings pubs =
ConfigurationManager.ConnectionStrings["PubsData"];
DbConnection connection = new SqlConnection(pubs.ConnectionString);
SqlCommand cmd = (SqlCommand)connection.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT * FROM Publishers";
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet pubsDataSet = new DataSet("Pubs");
SqlCommandBuilder bldr = new SqlCommandBuilder(da);
da.Fill(pubsDataSet, "publishers");
//Modify data here - added time to assure change
pubsDataSet.Tables["publishers"].Rows[0]["pub_name"]
= "Hello" + DateTime.Now.ToLongTimeString();
//Add a row - use seconds in id
pubsDataSet.Tables["publishers"].Rows.Add(
"99" + DateTime.Now.Second.ToString(),
"Tailspin Toys", "Paris", null, "France");
da.Update(pubsDataSet, "publishers");
Label lbl = GetLabel(275, 20);
lbl.Text = "Update Complete";
}

//C#
public SqlDataAdapter da = new SqlDataAdapter(); public System.Text.StringBuilder sb = new System.Text.StringBuilder();
private void rowUpdated(object sender, SqlRowUpdatedEventArgs e) { sb.Append("Rows: " + e.RecordsAffected.ToString() + "\r\n"); }
protected void Button14_Click(object sender, EventArgs e)
{ //event subscription is normally placed in constructor but is here //to encapsulate the sample da.RowUpdated += new SqlRowUpdatedEventHandler(rowUpdated);ConnectionStringSettings pubs =
ConfigurationManager.ConnectionStrings["PubsData"];
DbConnection connection = new SqlConnection(pubs.ConnectionString);
SqlCommand cmd = (SqlCommand)connection.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT * FROM Publishers";
da.SelectCommand = cmd;
DataSet pubsDataSet = new DataSet("Pubs");
SqlCommandBuilder bldr = new SqlCommandBuilder(da);
da.Fill(pubsDataSet, "publishers");
//Modify data here
foreach (DataRow dr in pubsDataSet.Tables["publishers"].Rows)
{
dr["pub_name"] = "Updated Toys "
+ DateTime.Now.Minute.ToString()
+ DateTime.Now.Second.ToString();
}
da.UpdateBatchSize = 3;
da.Update(pubsDataSet, "publishers");
//if event subscription is in the contructor, no need to
//remove it here....
da.RowUpdated -= new SqlRowUpdatedEventHandler(rowUpdated);
Label lbl = GetLabel(275, 20);
lbl.Text = sb.ToString();
}

//C#
protected void Button7_Click(object sender, EventArgs e)
{ OleDbDataAdapter da = new OleDbDataAdapter(); DataSet ds = new DataSet(); // set reference to adodb.dll and // add using ADODB ADODB.Connection adoCn = new ADODB.Connection(); ADODB.Recordset adoRs = new ADODB.Recordset(); adoCn.Open(
"Provider=Microsoft.Jet.OLEDB.4.0;"
+
"Data Source="
+
MapPath("App_Data/Northwind.mdb") + ";"
+
"Persist Security Info=False", "", "", -1);
adoRs.Open("SELECT * FROM Customers", adoCn, ADODB.CursorTypeEnum.adOpenForwardOnly, ADODB.LockTypeEnum.adLockReadOnly, 1);
da.Fill(ds, adoRs, "Customers");
adoCn.Close();
GridView gv = GetGridView(275, 20);
gv.DataSource = ds;
gv.DataMember = "Customers";
gv.DataBind();
}

//C#
DataTable providersList = null;
protected void Button16_Click(object sender, EventArgs e)
{ providersList = DbProviderFactories.GetFactoryClasses(); GridView gv = GetGridView(275, 20); gv.Width = 400; gv.DataSource = providersList;gv.DataBind();
}

//Enumerating Data Source
//C#
protected void Button17_Click(object sender, EventArgs e)
{
DbProviderFactory factory =
DbProviderFactories.GetFactory("System.Data.SqlClient");
//get SQL Server instances
DataTable sources =
factory.CreateDataSourceEnumerator().GetDataSources();
GridView gv = GetGridView(275, 20);
gv.DataSource = sources;
gv.DataBind();
}




//C#
protected void Button18_Click(object sender, EventArgs e)
{ Label errLabel = GetLabel(275, 20); GridView errGrid = GetGridView(275, 100); ConnectionStringSettings pubs =
ConfigurationManager.ConnectionStrings["PubsData"];
SqlConnection connection = new SqlConnection(pubs.ConnectionString);

//attach to event handler
connection.InfoMessage +=new SqlInfoMessageEventHandler(connection_InfoMessage);
DbCommand cmd = connection.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT job_id, job_desc FROM Jobs;"
+
"Print 'Hello Everyone';"
+
"Raiserror('Info Error Occured', 10,1 )"
+
"Print GetDate()";
connection.Open();
DbDataReader rdr = cmd.ExecuteReader();
DataTable publishers = new DataTable();
publishers.Load(rdr, LoadOption.Upsert);
connection.Close();
GridView gv = GetGridView(275, 200);
gv.DataSource = publishers;
gv.DataBind();
errLabel.Text = errMessage;
errGrid.DataSource = errCollection;
errGrid.DataBind();
}
private string errMessage = string.Empty;private List<SqlError> errCollection = new List<SqlError>();
void connection_InfoMessage(object sender, SqlInfoMessageEventArgs e)
{ errMessage += "Message: " + e.Message + "<br />"; foreach(SqlError err in e.Errors) errCollection.Add(err);
}


//C#
protected void Button20_Click(object sender, EventArgs e)
{ Label lbl = GetLabel(275, 20);ConnectionStringSettings cnSetting =
ConfigurationManager.ConnectionStrings["PubsData"];
using (SqlConnection cn = new SqlConnection())
{
cn.ConnectionString = cnSetting.ConnectionString;
cn.Open();
using (SqlTransaction tran = cn.BeginTransaction())
{
try
{
//work code here
using (SqlCommand cmd = cn.CreateCommand())
{
cmd.Transaction = tran;
cmd.CommandText = "UPDATE jobs SET min_lvl=min_lvl * 1.1";
int count = (int)cmd.ExecuteNonQuery();
lbl.Text = "Count = " + count.ToString(); }//if we made it this far, commit tran.Commit();
}
catch (Exception xcp)
{
tran.Rollback();
//cleanup code
lbl.Text = xcp.Message;
}
}
}
}

Synchronous vs. Asynchronous Access
Commands are normally executed synchronously, which causes the command to “block” program execution until the command has completed. Blocking execution keeps the program from continuing until the command has finished executing. This simplifies the writing of the code because the developer simply thinks about code execution in a rather procedural, step-by-step fashion, as shown in


Asynchronous command execution does not block program execution because it takes place on a new thread, which is another path of execution for your code. This means the original thread can continue executing while the new thread is waiting for its command to complete,

My first SharePoint internet site

2010-03-29T19:44:00.001-07:00

http://emis.projects.intergen.net.nz/default.aspx

is my first sharepoint wss internet site . simple configuration.

ADO.NET Disconnected Classes

2010-03-28T18:16:00.000-07:00


private DataTable GetDataTable()
{
    //Create the DataTable named "employee" DataTable employee = new DataTable("Employee");
    //Add the DataColumn using all properties
    DataColumn eid = new DataColumn("Eid");
    eid.DataType = typeof(string);
    eid.MaxLength = 10;
    eid.Unique = true;
    eid.AllowDBNull = false;
    eid.Caption = "EID";
    employee.Columns.Add(eid);
    //Add the DataColumn using defaults
    DataColumn firstName = new DataColumn("FirstName");
    firstName.MaxLength = 35;
    firstName.AllowDBNull = false;
    employee.Columns.Add(firstName);
    DataColumn lastName = new DataColumn("LastName");
    lastName.AllowDBNull = false;
    employee.Columns.Add(lastName);
    //Add the decimal DataColumn using defaults
    DataColumn salary = new DataColumn("Salary", typeof(decimal));
    salary.DefaultValue = 0.00m;
    employee.Columns.Add(salary);
    //Derived column using expression
    DataColumn lastNameFirstName = new DataColumn("LastName and FirstName");
    lastNameFirstName.DataType = typeof(string);
    lastNameFirstName.MaxLength = 70;
    lastNameFirstName.Expression = "lastName + ', ' + firstName";
    employee.Columns.Add(lastNameFirstName);
    return employee;
}


/*
¦ DataType String
¦
MaxLength –1, which means that no maximum length check is performed
¦
Unique False, which allows duplicate values
¦
AllowDBNull True, which means that the DataColumn does not need to have a value
¦
Caption The DataColumn object, which is the ColumnName property value
*/

//C#
//Set the Primary Key
employee.PrimaryKey = new DataColumn[] {eid};

//C#
//Add New DataRow by creating the DataRow first 
DataRow newemployee = employee.NewRow();
newemployee["Eid"] = "123456789A";
newemployee["FirstName"] = "Nancy";
newemployee["LastName"] = "Davolio";
newemployee["Salary"] = 10.00m;
employee.Rows.Add(newemployee);
//Add New DataRow by simply adding the values 
employee.Rows.Add("987654321X", "Andrew", "Fuller", 15.00m);
//Load DataRow, replacing existing contents, if existing
employee.LoadDataRow(
new object[] { "987654321X", "Janet", "Leverling", 20.00m },
LoadOption.OverwriteChanges);



The DataRow can hold up to three versions, or copies, of the data: Original, Current, and Proposed. When the DataRow is created, it contains a single copy of the data, which is the Current version. When the DataRow is placed into edit mode by executing its BeginEdit method, changes to the data are placed in a second version of the data, called the Proposed version. When the EndEdit method is executed, the Current version becomes the Original version, the Proposed version becomes the Current version, and the Proposed version no longer exists. After EndEdit has completed its execution, there are two versions of the DataRow data: Original and Current. If the BeginEdit method is called again, the Current version of the data is copied to a third version of the data, which is the Proposed version. Calling EndEdit again causes the Proposed version to become the Current version and the Proposed version to no longer exist.


//C#
private string GetDataRowInfo(DataRow row, string columnName) {
string retVal = string.Format(
"RowState: {0}<br />",
row.RowState);
foreach (string versionString in
Enum.GetNames(typeof(DataRowVersion)))
{
DataRowVersion version = (
DataRowVersion)Enum.Parse(
typeof(DataRowVersion), versionString);
if (row.HasVersion(version))
{
retVal += string.Format(
"Version: {0} Value: {1}<br />",
version, row[columnName, version]);
}
else
{
retVal += string.Format(
"Version: {0} does not exist.<br />",
version);
}
}
return retVal;
}



DataTable copy = employee.Copy( );


You often require a copy of the DataTable schema without the data. You can accomplish this by invoking the Clone method on the DataTable. Use this method when an empty copy of the DataTable is required and to which DataRow objects will be added at a later time. The following code shows the Clone method:
'VB
Dim clone as DataTable = employee.Clone( )
//C#
DataTable clone = employee.Clone( );


DataTable employee = GetDataTable(); employee.WriteXml(Server.MapPath("employee.xml")); Response.Redirect("employee.xml");


//C#
protected void Button7_Click(object sender, EventArgs e)
{
    DataTable employee = GetDataTable();
    employee.TableName = "Person";
    employee.Columns["Eid"].ColumnMapping = MappingType.Attribute;
    employee.Columns["FirstName"].ColumnMapping = MappingType.Attribute;
    employee.Columns["LastName"].ColumnMapping = MappingType.Attribute;
    employee.Columns["Salary"].ColumnMapping = MappingType.Attribute;
    employee.Columns["LastName and FirstName"].ColumnMapping =
    MappingType.Hidden;
    employee.WriteXml(Server.MapPath("PersonWithSchema.xml"), XmlWriteMode.WriteSchema);
    Response.Redirect("PersonWithSchema.xml");
}


<?xml version="1.0" standalone="yes"?> <NewDataSet> <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:MainDataTable="Person" msdata:UseCurrentLocale="true"> <xs:complexType> <xs:choice minOccurs="0" maxOccurs="unbounded"> <xs:element name="Person"> <xs:complexType> <xs:attribute name="Eid" msdata:Caption="EID" use="required"><xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="10" /> </xs:restriction>
</xs:simpleType> </xs:attribute> <xs:attribute name="FirstName" use="required">
<xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="35" /> </xs:restriction>
</xs:simpleType> </xs:attribute> <xs:attribute name="LastName" type="xs:string" use="required" /> <xs:attribute name="Salary" type="xs:decimal" default="0.00" /> <xs:attribute name="LastName_x0020_and_x0020_FirstName"
msdata:ReadOnly="true" msdata:Expression="lastName + ', ' + firstName" use="prohibited">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="70" />
</xs:restriction>
</xs:simpleType>
</xs:attribute>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//Person" />
<xs:field xpath="@Eid" />
</xs:unique>
</xs:element>
</xs:schema>
<Person Eid="123456789A" FirstName="Nancy" LastName="Davolio"
Salary="10.00" /> <Person Eid="987654321X" FirstName="Janet" LastName="Leverling" Salary="20.00" /> </NewDataSet>

The DataView object provides a window into a DataTable that can be sorted and filtered using the Sort, RowFilter, and RowStateFilter properties. A DataTable can have many DataView objects assigned to it, allowing the data to be viewed in many different ways without requiring the data to be reread from the database.

//C#
view.RowFilter = "LastName like 'A%' and Salary > 15";
The RowStateFilter provides a filter based on the DataRow object’s RowState property. This filter provides an extremely easy way to retrieve specific version information within the DataTable using one of the DataViewRowState enumeration values, which are as follows:


private DataSet GetDataSet()
{
DataSet companyData = new DataSet("CompanyList");
DataTable company = companyData.Tables.Add("company");
company.Columns.Add("Id", typeof(Guid));
company.Columns.Add("CompanyName", typeof(string));
company.PrimaryKey = new DataColumn[] { company.Columns["Id"] };
DataTable employee = companyData.Tables.Add("employee");
employee.Columns.Add("Id", typeof(Guid));
employee.Columns.Add("companyId", typeof(Guid));
employee.Columns.Add("LastName", typeof(string));
employee.Columns.Add("FirstName", typeof(string));
employee.Columns.Add("Salary", typeof(decimal));
employee.PrimaryKey = new DataColumn[] { employee.Columns["Id"] };
companyData.Relations.Add(
"Company_Employee",
company.Columns["Id"],
employee.Columns["CompanyId"]);
return companyData;
}

The first DataTable in the DataSet is rendered when you issue the DataBind method on the control, but you can be more specific about the Data-Table to use by assigning the name of the DataTable to the DataMember property of the data-bound control.


You can provide an XML Schema Definition (XSD) file to generate the typed DataSet class. You can use the DataSet Editor to graphically create and modify an XSD file, which, in turn, can be used to generate the typed DataSet class.


Cascading Updates and Deletes There are many scenarios where you want the deletion of a parent DataRow object to force the deletion of child DataRow objects. You can accomplish this by setting the DeleteRule on the ForeignKeyConstraint to Cascade (default). The following is a list of the Rule enumeration members:

The XML document is well formed and its root node is called CompanyList, which you can change by changing the DataSetName property.


//C#
protected void Button5_Click(object sender, EventArgs e)
{ //get dataset and populate//get the dataset and populateDataSet
companyList = GetDataSet();
PopulateDataSet(companyList);
//format xml
companyList.Relations["Company_Employee"].Nested = true;
foreach (DataTable dt in companyList.Tables)
{
foreach (DataColumn dc in dt.Columns)
{
dc.ColumnMapping = MappingType.Attribute;
}
}
//write to xml file
companyList.WriteXml(MapPath("CompanyListNested.xml"));
//display file
Response.Redirect("CompanyListNested.xml");
}

companyList.WriteXml( MapPath("CompanyListNestedWithSchema.xml"), XmlWriteMode.WriteSchema);


Instead of embedding the schema in the XML file, you can create a separate XSD file to load before loading the data. You can use the DataSet object’s WriteXmlSchema method to extract the XML schema definition to a separate file,


companyList.WriteXmlSchema( MapPath("CompanyListSchema.xsd"));



//C#
protected void Button8_Click(object sender, EventArgs e)
{ //get the dataset and populate DataSet companyList = GetDataSet(); DataTable company = companyList.Tables["company"]; company.Rows.Add(Guid.NewGuid(), "UnchangedCompany"); company.Rows.Add(Guid.NewGuid(), "ModifiedCompany"); company.Rows.Add(Guid.NewGuid(), "DeletedCompany"); companyList.AcceptChanges(); company.Rows[1]["CompanyName"] = "ModifiedCompany1"; company.Rows[2].Delete(); company.Rows.Add(Guid.NewGuid(), "AddedCompany");
//format xml
companyList.Relations["Company_Employee"].Nested = true;
foreach (DataTable dt in companyList.Tables)
{
foreach (DataColumn dc in dt.Columns) { dc.ColumnMapping = MappingType.Attribute; }}
    //write to xml diffgram file
    companyList.WriteXml( MapPath("CompanyListDiffGram.xml"), XmlWriteMode.DiffGram);
    //display file
    Response.Redirect("CompanyListDiffGram.xml");
}

/*
The DiffGram is mostly used in an environment where a user occasionally connects to a database to synchronize a disconnected DataSet object with the current information that is contained in the database. When the user is not connected to the database, the DataSet object is stored locally as a DiffGram to ensure that you still have the original data, because the original data is needed when it’s time to send your changes back to the database.
*/

//C#
protected void Button9_Click(object sender, EventArgs e)
{ //add grids to form GridView gvCompany = GetGridView(275, 20); GridView gvEmployee = GetGridView(275, 125);
//get the dataset and populate schema
DataSet companyList = new DataSet();
companyList.ReadXmlSchema(MapPath("CompanyListSchema.xsd"));
//populate from file
companyList.ReadXml(MapPath("CompanyListNested.xml"));
//display
gvCompany.DataSource = companyList;
gvCompany.DataMember = "Company";
gvEmployee.DataSource = companyList;
gvEmployee.DataMember = "Employee";
gvCompany.DataBind();
gvEmployee.DataBind();
}

//C#
//Added the following using statements to the top of the file using System.Runtime.Serialization.Formatters.Binary; using System.IO;
protected void Button10_Click(object sender, EventArgs e)
{ //get dataset and populate//get the dataset and populateDataSet
    companyList = GetDataSet();
    PopulateDataSet(companyList);
//set output to binary else this will be xml
    companyList.RemotingFormat = SerializationFormat.Binary;
//write to binary file
    using (FileStream fs = new FileStream(MapPath("CompanyList.bin"), FileMode.Create))
    {
        BinaryFormatter fmt = new BinaryFormatter();
        fmt.Serialize(fs, companyList);
    }
    //feedback
    Label lbl = GetLabel(275, 20);
    lbl.Text = "File Saved.";
}


//C#
protected void Button12_Click(object sender, EventArgs e)
{ //add grids to form GridView gvcompany = GetGridView(275, 20); GridView gvemployee = GetGridView(275, 125);
//get the dataset
DataSet original = GetDataSet();
//add AdventureWorks
original.Tables["Company"].Rows.Add(
Guid.NewGuid(), "AdventureWorks");
//copy the dataset
DataSet copy = original.Copy();

//modify the copy
DataRow aw = copy.Tables["Company"].Rows[0];
aw["CompanyName"] = "AdventureWorks Changed";
Guid empId;
empId = Guid.NewGuid();
copy.Tables["Employee"].Rows.Add(empId, aw["Id"],
"MarkLast", "MarkFirst", 90.00m);
empId = Guid.NewGuid();
copy.Tables["employee"].Rows.Add(empId, aw["Id"],
"SueLast", "SueFirst", 41.00m);
//merge changes back to the original
original.Merge(copy, false, MissingSchemaAction.AddWithKey);
//display
gvcompany.DataSource = original;
gvcompany.DataMember = "Company";
gvemployee.DataSource = original;
gvemployee.DataMember = "Employee";
gvcompany.DataBind();
gvemployee.DataBind();
}

Greymouth District Council Website Sign off

2010-03-28T03:56:00.000-07:00

My client has signed off http://greydcepi.preview.intergen.net.nz/ , one step forward to go live !

http://greydcepi.preprod.intergen.net.nz/

Some SharePoint Code

2010-03-24T14:12:00.001-07:00


 // open the root site 
          using (SPWeb spWeb = spSite.OpenWeb())




 // get the list from the site
        SPList spList = spWeb.Lists[paramList];
        
        
         string line = fileRdr.ReadLine();
            string[] fieldNames = line.Split(splitArray);

            // get an array of field from the list - this assumes the field names match
            // we need the field Id when inserting rows
            SPField[] spFields = new SPField[fieldNames.Length];
            for (int looper = 0; looper < fieldNames.Length; looper++)
            {
              string strName = fieldNames[looper];
              SPField field = spList.Fields.GetField(strName);
              spFields[looper] = field;
            }
            
            
SPTreeView


  SPWeb web = SPContext.Current.Web;
  
   SPList uploadDocumentList = web.Lists[UploadedDocuments];
   
    foreach (SPListItem item in uploadDocumentList.Items)
            {
              dropDownList.Items.Add(
               new ListItem(item.DisplayName, item.ID.ToString()));
            }
            
            
            
              SPDocumentLibrary workingDocumentLibrary =
            (SPDocumentLibrary)workingDocumentList;


SPWeb web = SPContext.Current.Web;
      SPList taskList = web.Lists[TaskList];
      SPListItem task = taskList.Items.Add();
      task["Title"] = "Please review the file " + copiedFile.File.Name;
      task["Status"] = "Not Started";
      if (!String.IsNullOrEmpty(AssignedUser))
      {
        SPUser user = web.AllUsers[AssignedUser];
        task["Assigned To"] = user;
      }

      task["Start Date"] = DateTime.Now;
      task["Due Date"] = DateTime.Now.AddDays(7);
      task["Description"] = "A document was uploaded. Can you please review it.";

      SPFieldUrlValue url = new SPFieldUrlValue();
      url.Description = copiedFile.DisplayName;
      url.Url = web.Url + "/" + copiedFile.Url;
      task["Document"] = url;

      task.Update();

.NET Framework type of the day SortedList

2010-03-23T21:36:00.000-07:00

It is like hashTable with sort functionality :

http://msdn.microsoft.com/en-us/library/system.collections.sortedlist.aspx

CFF Project Excel Export Tool

2010-03-23T18:39:00.001-07:00

http://www.codeproject.com/KB/office/excelxmllibrary.aspx

SharePoint 2007Access Folders

2010-03-23T03:02:00.000-07:00


 private void DisplayAllFolders()
        {
            SPSite oSiteCollection = SPContext.Current.Site;
            SPWebCollection collWebsites = oSiteCollection.AllWebs;
            string s = string.Empty;
            foreach (SPWeb oWebsite in collWebsites)
            {
                SPFolderCollection collFolders = oWebsite.Folders;

                foreach (SPFolder oFolder in collFolders)
                {
                    SPFileCollection collFiles = oFolder.Files;

                    long lngTotalFileSize = 0;

                    for (int intIndex = 0; intIndex < collFiles.Count; intIndex++)
                    {
                        lngTotalFileSize += collFiles[intIndex].Length;
                    }

                    s = s+ " Web: " +
                        SPEncode.HtmlEncode(oWebsite.Name)
                        + " Folder: " +
                        SPEncode.HtmlEncode(oFolder.Name) + " Number: "
                        + oFolder.Files.Count +
                        " Size: " + lngTotalFileSize + "<BR>";
                }
                oWebsite.Dispose();
            }
            Response.Write(s);
        }

SharePoint SDK

2010-03-22T17:22:00.000-07:00

http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.splist.aspx
Represents a list on a SharePoint Web site.
SPList Class (Microsoft.SharePoint)

http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.splistitem.aspx
Represents an item or row in a list.
SPListItem Class (Microsoft.SharePoint)

SPWeb rootWeb = SPContext.Current.Site.RootWeb;
if (rootWeb.ListExists(Lists.ContactUsTopics))
{
drpdownTopics.Items.Clear();
SPList contactmeTopicsList = rootWeb.Lists[Lists.ContactUsTopics];
foreach (SPListItem topic in contactmeTopicsList.Items)
{
drpdownTopics.Items.Add(topic.Title);
}
drpdownTopics.SelectedIndex = 0;
}

Problem with configuring VSeWSS 1.3 CTP w/ VS 2008

2010-03-22T13:04:00.000-07:00

1. Created a new application pool "VSeWSS" with default settings
2. Install VSeWSS 1.3 using the app pool "VSeWSS"8. Deploy webpart - works!Windows 2008, VS2008

http://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/3a11085b-9dd3-4879-83be-fd44f0da1a0e

http://blogs.msdn.com/steve_fox/archive/2009/03/18/vsewss-1-3-post-install-configuration.aspx

C# + MVP + Unit Testing

2010-03-20T05:56:00.000-07:00

Here are basic resources required to carry on unit test :

1) Rhino Mocks : http://www.ayende.com/projects/rhino-mocks/downloads.aspx

2) Nunit : http://nunit.org/?p=download

3) TestDriven http://www.testdriven.net/

4) WatiN Auto UI Testing http://watin.sourceforge.net/

Here is my sample code
http://airforcewing.com/downloads/jefferyProjects_1.zip

C# + Why to use using Statement

2010-03-20T05:46:00.000-07:00

When you are using an object that encapsulates any resource, you have to make sure that when you are done with the object, the object's Dispose method is called. This can be done more easily using the using statement in C#. The using statement simplifies the code that you have to write to create and then finally clean up the object. The using statement obtains the resource specified, executes the statements and finally calls the Dispose method of the object to clean up the object.

using (TextWriter w = File.CreateText("log.txt")){ w.WriteLine("This is line one");}

Here is an excellent article :

http://www.codeproject.com/KB/cs/tinguusingstatement.aspx

SharePoint Development Resources

2010-03-18T01:26:00.000-07:00

SharePoint 2007
http://www.microsoft.com/click/sharepointdeveloper

Labs
http://www.microsoft.com/downloads/details.aspx?FamilyId=B885DCE8-C93F-48AA-B798-4422FEBCC200&displaylang=en

Blog Post
http://blogs.msdn.com/pandrew/archive/2008/06/11/mssharepointdeveloper-content.aspx

Video Series
http://msdn.microsoft.com/en-us/sharepoint/ee663870.aspx

Tools
http://msdn.microsoft.com/en-us/library/bb530302.aspx

SharePoint 2010
http://msdn.microsoft.com/en-us/sharepoint/ee514561.aspx

http://msdn.microsoft.com/en-us/sharepoint/ee513147.aspx

Stripped down master page
http://www.heathersolomon.com/blog/articles/BaseMasterPages.aspx

http://sharepointers.blogspot.com/2008/04/creating-and-deploying-custom-master.html

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

Very useful visual stuido add in
http://stsdev.codeplex.com/

http://www.codeplex.com/wspbuilder

http://spvisualdev.codeplex.com/

http://ulsviewer.codeplex.com/

http://code.msdn.microsoft.com/ULSViewer/Release/ProjectReleases.aspx?ReleaseId=3308

How to create customised master page template

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

What is onet.xml
http://msdn.microsoft.com/en-us/library/ms474369.aspx

Here is my sample project of sharePoint using sharePoint SDK

http://airforcewing.com/downloads/SharePointMedical_2.zip

SharePoint Web Part

2010-03-16T17:55:00.001-07:00

One of senior sharepoint developer at work produced this codeplex package on the

http://spjquerywebparts.codeplex.com

SharePoint DisableLoopbackCheck

2010-03-16T16:35:00.000-07:00

One of the problem I had with setting up SharePoint site is, If I create a site with different host name and try to visit it on the same hosting machine. It will always ask me to provide login details, but nomatter what I enter in the login pop, I will nevery be able to see the site.

This is caused by "DisableLoopbackCheck " issue, which can be fixed by following the instruction below :

http://support.microsoft.com/kb/896861#letmefixit

ASP.NET output Javascript

2010-03-16T14:12:00.000-07:00

http://dotnetslackers.com/articles/aspnet/JavaScript_with_ASP_NET_2_0_Pages_Part1.aspx

Integration of SVN to visual studio 2008

2010-03-15T17:59:00.001-07:00

Here is a free svn plugin can be used in visual studio 2008

http://blogs.open.collab.net/svn/2008/07/ankhsvn-20-fina.html

(This one is not free, but it supposes to be good ! )
http://www.visualsvn.com/

C# string format

2010-03-15T00:55:00.000-07:00

http://www.dijksterhuis.org/formatting-strings-stringformat/

http://www.csharp-examples.net/string-format-int/

Add zeroes before number

System.Web.UI.WebControls.BoundField - changing dataformatstring at runtime fails

2010-03-15T00:21:00.001-07:00

https://connect.microsoft.com/VisualStudio/feedback/details/333263/system-web-ui-webcontrols-boundfield-changing-dataformatstring-at-runtime-fails

HttpContext..::.User Property

2010-03-13T23:26:00.000-08:00

The User property provides programmatic access to the properties and methods of the IPrincipal interface. Because ASP.NET pages contain a default reference to the System.Web namespace (which contains the HttpContext class), you can reference the members of HttpContext on an .aspx page without using the fully qualified class reference to HttpContext. For example, you can use User.Identity.Name to get the name of the user on whose behalf the current process is running. However, if you want to use the members of IPrincipal from an ASP.NET code-behind module, you must include a reference to the System.Web namespace in the module and a fully qualified reference to both the currently active request/response context and the class in System.Web that you want to use. For example, in a code-behind page you must specify the fully qualified name HttpContext.Current.User.Identity.Name.

MVP Architects

2010-03-13T03:19:00.001-08:00

Now I am working on some enterprise level application, I finally have chance to access to program arachitect.

Here are some resources from Microsoft:

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

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

http://msdn.microsoft.com/en-us/magazine/cc188690.aspx

Unit Testing

http://www.nmock.org/cheatsheet.html

http://www.c-sharpcorner.com/UploadFile/markuskalina/NUnitP1MK12052005043822AM/NUnitP1MK.aspx

ASP.NET Browser Auto Testing, Unit Testing

2010-03-13T02:36:00.000-08:00

In CFF project, for the first time, I have experienced the power of auto web browser testing tool.

http://watin.sourceforge.net/

In this project,we also used NUNIT testing tool for unit testing.

http://www.nunit.org/

Here are some articles teach you how to use it.

http://tangent-studios.com/programming/csharp/NUnit2Tut/NUnitV2Tut.htm

http://www.c-sharpcorner.com/UploadFile/markuskalina/NUnitP1MK12052005043822AM/NUnitP1MK.aspx

http://www.c-sharpcorner.com/UploadFile/markuskalina/NUnitP2MK12052005022324AM/NUnitP2MK.aspx

CFF Projects

2010-03-13T01:18:00.000-08:00

string name;
System.ArgumentOutOfRangeException(name)

System.Colleciton.Generic.Dictionary.ContainKey()


using System;
using System.Collections.Generic;

public class Example
{
    public static void Main()
    {
        // Create a new dictionary of strings, with string keys.
        //
        Dictionary<string, string> openWith = 
            new Dictionary<string, string>();

        // Add some elements to the dictionary. There are no 
        // duplicate keys, but some of the values are duplicates.
        openWith.Add("txt", "notepad.exe");
        openWith.Add("bmp", "paint.exe");
        openWith.Add("dib", "paint.exe");
        openWith.Add("rtf", "wordpad.exe");

        // The Add method throws an exception if the new key is 
        // already in the dictionary.
        try
        {
            openWith.Add("txt", "winword.exe");
        }
        catch (ArgumentException)
        {
            Console.WriteLine("An element with Key = \"txt\" already exists.");
        }

        // The Item property is another name for the indexer, so you 
        // can omit its name when accessing elements. 
        Console.WriteLine("For key = \"rtf\", value = {0}.", 
            openWith["rtf"]);

        // The indexer can be used to change the value associated
        // with a key.
        openWith["rtf"] = "winword.exe";
        Console.WriteLine("For key = \"rtf\", value = {0}.", 
            openWith["rtf"]);

        // If a key does not exist, setting the indexer for that key
        // adds a new key/value pair.
        openWith["doc"] = "winword.exe";

        // The indexer throws an exception if the requested key is
        // not in the dictionary.
        try
        {
            Console.WriteLine("For key = \"tif\", value = {0}.", 
                openWith["tif"]);
        }
        catch (KeyNotFoundException)
        {
            Console.WriteLine("Key = \"tif\" is not found.");
        }

        // When a program often has to try keys that turn out not to
        // be in the dictionary, TryGetValue can be a more efficient 
        // way to retrieve values.
        string value = "";
        if (openWith.TryGetValue("tif", out value))
        {
            Console.WriteLine("For key = \"tif\", value = {0}.", value);
        }
        else
        {
            Console.WriteLine("Key = \"tif\" is not found.");
        }

        // ContainsKey can be used to test keys before inserting 
        // them.
        if (!openWith.ContainsKey("ht"))
        {
            openWith.Add("ht", "hypertrm.exe");
            Console.WriteLine("Value added for key = \"ht\": {0}", 
                openWith["ht"]);
        }

        // When you use foreach to enumerate dictionary elements,
        // the elements are retrieved as KeyValuePair objects.
        Console.WriteLine();
        foreach( KeyValuePair<string, string> kvp in openWith )
        {
            Console.WriteLine("Key = {0}, Value = {1}", 
                kvp.Key, kvp.Value);
        }

        // To get the values alone, use the Values property.
        Dictionary<string, string>.ValueCollection valueColl =
            openWith.Values;

        // The elements of the ValueCollection are strongly typed
        // with the type that was specified for dictionary values.
        Console.WriteLine();
        foreach( string s in valueColl )
        {
            Console.WriteLine("Value = {0}", s);
        }

        // To get the keys alone, use the Keys property.
        Dictionary<string, string>.KeyCollection keyColl =
            openWith.Keys;

        // The elements of the KeyCollection are strongly typed
        // with the type that was specified for dictionary keys.
        Console.WriteLine();
        foreach( string s in keyColl )
        {
            Console.WriteLine("Key = {0}", s);
        }

        // Use the Remove method to remove a key/value pair.
        Console.WriteLine("\nRemove(\"doc\")");
        openWith.Remove("doc");

        if (!openWith.ContainsKey("doc"))
        {
            Console.WriteLine("Key \"doc\" is not found.");
        }
    }
}

/* This code example produces the following output:

An element with Key = "txt" already exists.
For key = "rtf", value = wordpad.exe.
For key = "rtf", value = winword.exe.
Key = "tif" is not found.
Key = "tif" is not found.
Value added for key = "ht": hypertrm.exe

Key = txt, Value = notepad.exe
Key = bmp, Value = paint.exe
Key = dib, Value = paint.exe
Key = rtf, Value = winword.exe
Key = doc, Value = winword.exe
Key = ht, Value = hypertrm.exe

Value = notepad.exe
Value = paint.exe
Value = paint.exe
Value = winword.exe
Value = winword.exe
Value = hypertrm.exe

Key = txt
Key = bmp
Key = dib
Key = rtf
Key = doc
Key = ht

Remove("doc")
Key "doc" is not found.
 */

SharePoint Development 13.03.2007

2010-03-13T00:13:00.001-08:00

http://msdn.microsoft.com/en-us/library/e59b22c5(VS.80).aspx

The extern modifier is used to declare a method that is implemented externally. A common use of the extern modifier is with the DllImport attribute when using Interop services to call into unmanaged code; in this case, the method must also be declared as static, as shown in the following example:

[DllImport("advapi32.dll", CharSet = CharSet.Unicode)]
internal static extern ulong GetTraceLoggerHandle([In] IntPtr Buffer);

unsafe
The unsafe keyword denotes an unsafe context, which is required for any operation involving pointers.

You can use the unsafe modifier in the declaration of a type or a member. The entire textual extent of the type or member is therefore considered an unsafe context. For example, the following is a method declared with the unsafe modifier:

internal unsafe delegate uint EtwProc(WMIDPREQUESTCODE requestCode, IntPtr requestContext, uint* bufferSize, IntPtr buffer);

[MarshalAs(UnmanagedType.ByValTStr, SizeConst = 0x20)]
internal string wzExeName;

Platform Invoke Tutorial
Platform Invocation Services (PInvoke) allows managed code to call unmanaged functions that are implemented in a DLL.

base

The base keyword is used to access members of the base class from within a derived class:

Call a method on the base class that has been overridden by another method.
Specify which base-class constructor should be called when creating instances of the derived class.


using System;
   public class Person 
   {
      protected string ssn = "444-55-6666";
      protected string name = "John L. Malgraine";

      public virtual void GetInfo() 
      {
         Console.WriteLine("Name: {0}", name);
         Console.WriteLine("SSN: {0}", ssn);
      }
   }
   class Employee: Person 
   {
      public string id = "ABC567EFG";

      public override void GetInfo() 
      {
         // Calling the base class GetInfo method:
         base.GetInfo();
         Console.WriteLine("Employee ID: {0}", id);
      }
   }

class TestClass {
   public static void Main() 
   {
      Employee E = new Employee();
      E.GetInfo();
   }
}


// keywords_base2.cs
using System;
public class MyBase
{
   int num;

   public MyBase() 
   {
      Console.WriteLine("in MyBase()");
   }

   public MyBase(int i )
   {
      num = i;
      Console.WriteLine("in MyBase(int i)");
   }

   public int GetNum()
   {
      return num;
   }
}

public class MyDerived: MyBase
{
   // This constructor will call MyBase.MyBase()
   public MyDerived() : base()
   {
   }

    // This constructor will call MyBase.MyBase(int i)
   public MyDerived(int i) : base(i)
   {
   }

   public static void Main() 
   {
      MyDerived md = new MyDerived();
      MyDerived md1 = new MyDerived(1);
   }
}

SharePoint - SharePoinPermission attributes


 public override BaseFieldControl FieldRenderingControl
        {
            [SharePointPermission(SecurityAction.LinkDemand, ObjectModel = true)]
            get
            {
                BaseFieldControl fieldControl = Activator.CreateInstance(typeof(BaseControl<T>)) as BaseControl<T>;

                if (fieldControl != null)
                {
                    fieldControl.TemplateName = InternalName;

                    return fieldControl;
                }

                return null;
            }
        }

The override modifier is required to extend or modify the abstract or virtual implementation of an inherited method, property, indexer, or event.

The virtual keyword is used to modify a method, property, indexer or event declaration, and allow it to be overridden in a derived class. For example, this method can be overridden by any class that inherits it:

readonly


// cs_readonly_keyword.cs
// Readonly fields
using System;
public class ReadOnlyTest 
{
   class MyClass 
   {
      public int x;
      public readonly int y = 25; // Initialize a readonly field
      public readonly int z;

      public MyClass() 
      {
         z = 24;   // Initialize a readonly instance field
      }

      public MyClass(int p1, int p2, int p3) 
      {
         x = p1; 
         y = p2; 
         z = p3;
      }
   }

   public static void Main() 
   {
      MyClass p1= new MyClass(11, 21, 32);   // OK
      Console.WriteLine("p1: x={0}, y={1}, z={2}" , p1.x, p1.y, p1.z);   
      MyClass p2 = new MyClass();
      p2.x = 55;   // OK
      Console.WriteLine("p2: x={0}, y={1}, z={2}" , p2.x, p2.y, p2.z);
   }
}

p1: x=11, y=21, z=32
p2: x=55, y=25, z=24
p2.y = 66;        // Error

ASP.NET Detect Which Control Caused PostBack

2010-03-10T13:03:00.000-08:00


using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.SessionState;
using System.Web.SessionState;
using System.Web.UI;

namespace webappServerControls
{
    public class Global : HttpApplication
    {

        public static System.Web.UI.Control GetPostBackControl(System.Web.UI.Page page)
        {
            Control control = null;
            string ctrlname = page.Request.Params["__EVENTTARGET"];
            if (ctrlname != null && ctrlname != String.Empty)
            {
                control = page.FindControl(ctrlname);
            }
            // if __EVENTTARGET is null, the control is a button type and we need to  
            // iterate over the form collection to find it 
            else
            {
                string ctrlStr = String.Empty;
                Control c = null;
                foreach (string ctl in page.Request.Form)
                { // handle ImageButton controls ... 
                    if (ctl.EndsWith(".x")  ctl.EndsWith(".y"))
                    {
                        ctrlStr = ctl.Substring(0, ctl.Length - 2); c = page.FindControl(ctrlStr);
                    }
                    else
                    {
                        c = page.FindControl(ctl);
                    }
                    if (c is System.Web.UI.WebControls.Button  c is System.Web.UI.WebControls.ImageButton)
                    {
                        control = c; break;
                    }
                }
            }
            return control;
        }


        protected void Application_Start(object sender, EventArgs e)
        {

        }

        protected void Session_Start(object sender, EventArgs e)
        {

        }

        protected void Application_BeginRequest(object sender, EventArgs e)
        {

        }

        protected void Application_AuthenticateRequest(object sender, EventArgs e)
        {

        }

        protected void Application_Error(object sender, EventArgs e)
        {

        }

        protected void Session_End(object sender, EventArgs e)
        {

        }

        protected void Application_End(object sender, EventArgs e)
        {

        }
    }
}


using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

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

            if(IsPostBack)
            {
                Label1.Text=Global.GetPostBackControl(this).ID.ToString();
            }

        }

        protected void Button2_Click(object sender, EventArgs e)
        {
            Response.Write("Content Page Response");
        }
    }
}

http://www.factor.co.nz/ Debtor Management

2010-03-09T21:19:00.000-08:00

http://www.factor.co.nz/ Debtor Management

http://www.factor.co.nz/index.asp?s1=DEBTOR%20MANAGEMENT

CruiseControl.NET for Automated Continuous Integration server
(cruiseControl.net)
SVN for Source Control
Telerik datagrid
(telerik)
ASP.NET 3.5 MVP Application
With MS Ajax, JQuery, Json

SharePoint SDK

2010-03-08T12:04:00.000-08:00

http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spfile.aspx

Recursive Program Folder Structure

2010-03-07T11:57:00.000-08:00

Recursive Code Output TreeView.Node object for file structure :


 private void PopulateTree()
        {
            DirectoryInfo rootFolder = new DirectoryInfo(Server.MapPath(VirtualImageRoot));

            TreeNode root = AddNodeAndDescendents(rootFolder, null);
            TreeView1.Nodes.Add(root);
        }


private TreeNode AddNodeAndDescendents(DirectoryInfo folder, TreeNode parentNode)
        {
            string virtualFolderPath = null;
            if (parentNode == null)
            {
                virtualFolderPath = VirtualImageRoot;
            }
            else
            {
                virtualFolderPath = parentNode.Value + "/" + folder.Name + "/";
            }
            TreeNode node = new TreeNode(folder.Name, virtualFolderPath);
            DirectoryInfo[] subFolders = folder.GetDirectories();
            foreach (DirectoryInfo subFolder in subFolders)
            {
                TreeNode child = AddNodeAndDescendents(subFolder, node);
                node.ChildNodes.Add(child);
            }
            return node;
        }

EPI 5 Tips

2010-03-05T19:38:00.000-08:00

I want to create an item in my navigation that points to the home page, but I do not want to modify my navigation menu code, which generates items below the selected home page node.

The tip is :

1. Create a page in CMS use the 'start page template'
2. Go to tab 'Shortcut/External link' and choose 'Link type' to 'Shortcut to page in EPiServer CMS'.
3. Choose 'home page' in 'Internal shortcut/Fetch data from'

Then you will get a page that looks exactly like the home page with different title.