Day to day good stuff I find regarding my work

Wednesday, April 12, 2006

Move Excel to SQLserver

Introduction to Excel Services,

Start look at

Office 2003 XML Reference Schemas
http://www.microsoft.com/office/xml/default.mspx

How to import data from Excel to SQL Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;321686

Loading and reading the Microsoft Excel file contents using C#
http://www.codeproject.com/useritems/Excel_Application_in_C_.asp

Convert Excel to XML file/XML Schema, and validate Excel against XML Schema
http://www.codeproject.com/csharp/excel2xml.asp

Using the Excel 2003 XML Tools Add-in Version 1.1
http://msdn.microsoft.com/office/default.aspx?pull=/library/en-us/odc_xl2003_ta/html/OfficeExcelXMLToolAddin.asp

Office 2003: XML Reference Schemas
http://www.microsoft.com/downloads/details.aspx?FamilyId=FE118952-3547-420A-A412-00A2662442D9&displaylang=en


SQL DTS
http://www.sqldts.com/

Tuesday, April 11, 2006

Demo of office and ribbons

http://www.microsoft.com/office/preview/ui/demo.mspx

Friday, April 07, 2006

New version developers toolbar IE

A very good tool debugging pages

also check in Windows Live. Atlas Great Overview Video from ScottGu

Misc

Dating Design Patterns list


I have problems with turkish entities ....
Some pages HTML Authoring ...

WIKI Turkish Characters

Thursday, April 06, 2006

Ndoc problem

Ndoc

Got a problem generating documentation. Fixed when restarting and did some changes to the assembly ...



Request for the permission of type System.Web.AspNetHostingPermission, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.

at System.Security.CodeAccessSecurityEngine.CheckTokenBasedSetHelper(Boolean ignoreGrants, TokenBasedSet grants, TokenBasedSet denied, TokenBasedSet demands)

at System.Security.CodeAccessSecurityEngine.CheckSetHelper(PermissionSet grants, PermissionSet denied, PermissionSet demands)

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

Wednesday, April 05, 2006

Cool tools for c#

nDoc for documenting the code...
and GhostDoc that automatically generates C# documentation based on the name and parameters of what you are documenting.


FxCop code analysis tool FxCop Blog

DevMetrics measure complexity of code

see also Must have tools

O/R Mapping NHibernate

ScottGU List of cool tools

Maybe also Eight tips to make you more efficient as an ASP.NET developer

PROCESS MAPPING BY TUBE

Cool idea of using the tube layoyut for describing processes.

http://www.kaywebs.co.uk/process_maps.htm