Blog Easyciel for .NET

From your Visual Studio’s projet (.NET 2003 or 2005), add a reference to the pre-registered dll DSOFILE.DLL downloaded from : Support Microsoft You can use this sample which do the following : Open a office document in read-only mode Compare the custom property named ‘connectionStringCustomProperty’ with a new value If the value is already set : return Else re-open the document in read-write mode and set the new value private void UpdateConnectionString(string filePath,string connectionStringCustomProperty, string newConnectionString) { OleDocumentPropertiesClass document = new OleDocumentPropertiesClass(); bool mustUpdate = false; try         { //Verifions si la modification est nécessaire en mode read-only document.Open(filePath, true, dsoFileOpenOptions.dsoOptionDefault); foreach (CustomProperty property in document.CustomProperties) { if (property.Name == connectionStringCustomProperty)... [More]

Office Office

Presentation video on coding4fun :

News News

The SDK can be downloaded on : http://www.microsoft.com/downloads

News News

Personnalisez votre portail grâce aux contrôles utilisateur et aux composants WebPart personnalisés http://www.microsoft.com/france/msdn/aspnet/webpart_aspnet20.mspx

SharePoint, .NET Projects SharePoint, .NET Projects

Calculate the age of a person from his date of birth. Parameters : @dateNaissance = Date of birth @dateActuelle = Current date (from GetDate()) CREATE FUNCTION [dbo].[fnGetAge] (@dateNaissance SMALLDATETIME, @dateActuelle SMALLDATETIME) RETURNS INT AS BEGIN DECLARE @age INT SET @age = FLOOR(DateDiff(dd,@dateNaissance,@dateActuelle)/365.25) IF (Day(@dateNaissance) = Day(@dateActuelle)) AND (Month(@dateNaissance) = Month(@dateActuelle))    BEGIN       SET @age = @age + 1    END RETURN @age END

DAL, Sql DAL, Sql

10 useful addins for Visual Studio .NET : http://msdn.microsoft.com/msdnmag/issues/05/12/VisualStudioAddins/default.aspx

Developer Tools Developer Tools

function SelectAll(value) { var formblock; var forminputs; formblock = document.forms[0]; forminputs = formblock.getElementsByTagName(‘input’); for (i = 0; i { var regex = new RegExp(‘checkbox’, ‘i’); if (regex.test(forminputs[i].getAttribute(‘type’))) { if (value == ‘1′) { forminputs[i].checked = true; } else { forminputs[i].checked = false; } } } } Keywords : javascript selectall input form checkbox

Javascript, css Javascript, css

If you want to execute a portion of code in a différent sécurity context, you can use this class “Impersonate”. Just create a instance in a using block. using(new Impersonate(domain, user, password)){      //Code with different execution rights} Download the class here : Impersonate.cs in zip Under Windows Server 2003, you will prefer : WindowsIdentity.Impersonate() Warning : an error 1314 can occured on Windows 2000 system : Read the note at the end of this article and read this articleYou can change the ‘Act as part of the operating system’ in :- From Administrative Tools, open Local Security Policy. If the Administrative Tools window is no longer open, navigate to Start > Settings > Control Panel> Administrative Tools> Local Security Policy.- Navigate to Security settings > Local Policies > User Rights Assignment- Double-click Act as part of the operating system under the policy column in the... [More]

.NET Projects, .NET Projects .NET Projects, .NET Projects

FOCUSING ON EVENTS Articles : http://msdn.microsoft.com/library/default.asp?url=/library/en-us/spptsdk/html/tsptDocLibEvents_SV01034973.asp Samples : Episode 1 : The recycle bin MSDN Article : http://msdn.microsoft.com/msdnmag/issues/05/02/RecycleBinforWSS/default.aspx FOCUSING ON SQL SERVER Impact of direct SQL access to SharePoint’s SQL Server database Read this article : http://blogs.msdn.com/mikefitz/archive/2005/04/01/404802.aspx. It talks about this tool : A few lines on locks : http://www.mssqlcity.com/Articles/General/sql2000_locking.htm

SharePoint SharePoint

A lot of tools useful for developers ! For example : ADO.NET CsvFileTester .NET FormatDesigner XmlSerializerPreCompiler Filter Files With Unknown Extensions For XP .NET ResourceExplorer Scancode Mapper TAPI Explorer .NET XsdClassesGen Giving VS.NET That XP Look .NET CollectionGen RegexDesigner.NET .NET IM Client Classes Genghis SafeFormatter for .NET VS.NET Fun Facts CorPub UrlRun .NET XML Checker and Validator Setting the Completion Character … Goto : http://www.sellsbrothers.com/tools/

.NET Projects .NET Projects