CONVERT(varchar(32), date_field, 101) as FieldName
The different possible formats are available at: http://msdn.microsoft.com/en-us/library/ms187928.aspx
Best jQuery Calendar Plugin
October 13th, 2011 So far to date this is the best jQuery calendar plugin I have seen. It has day, week and month views. It also looks like it would be easily customizable to add additional attributes onto events. You can also create, update and remove events using drag and drop. It also supports all day events and event overlapping. This seems like it would make a perfect solution for manufacturing schedules, etc.
http://www.web-delicious.com/jquery-events-calendar-wdcalendar/
Returning IDENTITY After SqlCommand Insert
October 10th, 2011 Returning the identity for the row you just inserted is easily accomplished by using output parameters. Create your command and connection as usual. Terminate your insert statement with a semi-colon and insert a select statement that sets the SCOPE_IDENTITY() equal to an output parameter. Execute the command using ‘ExecuteScalar’ because it expects one return value. After executing the command simply retrieve your parameters value.
Dim id as Int64
Dim cmd as New SqlCommand(”INSERT INTO (fields, etc) VALUES (@fields, @etc); SELECT @ID = SCOPE_IDENTITY()”)
Dim pID as New SqlParameter(”@ID”, SqlDbType.Int64) ‘or whatever data type your id is…
pID.Direction = ParameterDirection.Output
cmd.Parameters.Add(pID)
cmd.ExecuteScalar
ID = cmd.Parameters(”ID”).value
Note: Don’t use @@IDENTITY in this case because it’s the last ID generated at the database level and very well may not be the ID you’re expecting.
Securing ASP.NET Applications
May 22nd, 2010 Blog post about different security threat scenarios – http://www.novologies.com/post/2009/04/08/Securing-ASPNET-Applications.aspx
Web Security Tool on CodePlex
Passive Vulnerability Scanner – http://websecuritytool.codeplex.com/
Generating an iCalendar file on the fly in ASP.Net
May 21st, 2010 At work last week I had to build ICS files on the fly based on events stored in a database. I used Sam’s post here to get started. http://webdevel.blogspot.com/2006/02/how-to-generate-icalendar-file-aspnetc.html
To finish it up I used the IIS Url Rewriting Module to take urls that matched my meeting#.ics pattern and and transform them into the ashx file extension for ASP.Net to work its magic on. The result is a sweet way to have a file built on the fly – and I’ve already thought of many other ways to implement this with filetypes other than the ICS.
SharePoint Server
May 12th, 2010 Microsoft Office SharePoint Server 2007
http://msdn.microsoft.com/en-us/library/bb931736%28v=office.12%29.aspx
Microsoft Enterprise Search Resources
May 9th, 2010 Enterprise Search
http://www.microsoft.com/enterprisesearch/en/us/default.aspx
Enterprise Search Technical Resources
http://www.microsoft.com/enterprisesearch/en/us/technical-resources.aspx
Enterprise Search Resource Center
http://msdn.microsoft.com/en-us/office/bb335345.aspx
The Microsoft Search Server 2008 Software Development Kit (SDK)
http://msdn.microsoft.com/en-us/library/bb931107.aspx
Microsoft Search Server 2008 SDK Samples
http://code.msdn.microsoft.com/mss2008sdksamples
Enterprise Search Query Object Model Overview
http://msdn.microsoft.com/en-us/library/ms544561.aspx
FullTextSqlQuery Class (Microsoft.Office.Server.Search.Query)
http://msdn.microsoft.com/en-us/library/microsoft.office.server.search.query.fulltextsqlquery.aspx
Getting Started with the Enterprise Search Administration Object Model
http://msdn.microsoft.com/en-us/library/ms501355.aspx#CommunityContent
Custom Security Trimming for Enterprise Search Results Overview
http://msdn.microsoft.com/en-us/library/aa981236.aspx
Enterprise Search Security Model
http://msdn.microsoft.com/en-us/library/aa981314.aspx
Walkthrough: Using a Custom Security Trimmer for Search Results
http://msdn.microsoft.com/en-us/library/aa981563(v=office.12).aspx
Security Notes:
- Results can be security trimmed.
- Trimming happens automatically durin crawling for documents that Microsoft Search Server Express can obtain security information on. (Fileshares, SharePoint, Lotus Notes, etc)
- Another type of trimming is done at the query time, and is appropriately called “Query Time Trimming”.
You can modify the appearance of the search page and results by using the SharePoint designer.
