Tuesday, November 18, 2008 Here's an easy way to check or uncheck all items in a CheckBoxList.
JavaScript
function CheckBoxListSelect(cbControl, state)
{
var chkBoxList = document.getElementById(cbControl);
var chkBoxCount = chkBoxList.getElementsByTagName("input");
for(var i=0; i < chkBoxCount.length; i++)
{
chkBoxCount[i].checked = state;
}
return false;
}
ASP.Net CheckBoxList
<div>
<a href="javascript:void(0)" onclick="javascript: CheckBoxListSelect('<%=chkStates.ClientID %>', true)">Select All</a> | <a href="javascript:void(0)" onclick="javascript: CheckBoxListSelect('<%=chkStates.ClientID %>', false)">Select None</a>
</div>
<div>
<asp:CheckBoxList ID="chkStates" RepeatColumns="6" Width="100%" runat="server" />
</div> Tuesday, November 11, 2008 I ran into a situation today where I needed to have an Excel Source for an Excel file that would not always exist at the path specified in the ExcelFilePath property. This would cause the SSIS package to fail when the Excel file did not exist since the Data Flow Task could not validate the Excel file.
The simple fix was to right click the Data Flow Task and go to Properties and set the DelayValidation property to True. Tuesday, November 11, 2008 "If you have used SSIS to import Excel data into SQL Server you may have run into the issue of having to convert data from Unicode to non-Unicode."
This article discusses some different options for handling Unicode to non-Unicode warning messages that are fairly common if you deal with importing data from one source to another, for example from Excel to SQL.
In my case today I ended up just having to add a Data Conversion transformation between my Excel Source and SQL Server Destination to convert my data-types accordingly. Thursday, October 30, 2008
This site has tons of great info about Team System and Team Foundation Server.
I happened to come across it when reading about source control and "shelving".
Enjoy! Thursday, October 30, 2008 Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created.
"This is by design and can be quickly fixed in Management Studio by unchecking a property. To fix this in Management Studio, go to Tools -> Options then go to the Designer Page and uncheck Prevent saving changes that require table re-creation." Tuesday, October 21, 2008 Here's another good article article written by Scott Mitchell discussing the new date data types available in Microsoft SQL Server 2008.
"This article explores the time and date data types and shows how they can be used and formatted from within an ASP.NET page. This article also includes a short discussion on the datetime2 and datetimeoffset and compares and constrasts SQL Server 2008's six different date data types."
Tuesday, October 21, 2008 Friday, October 3, 2008 "Lightbox is a simple, unobtrusive script used to overlay images on the current page. It's a snap to setup and works on all modern browsers."
http://www.huddletogether.com/projects/lightbox2 Wednesday, September 24, 2008 Spry is a JavaScript-based framework that enables the rapid development of Ajax-powered web pages. Not a JavaScript guru? No problem. Spry was designed to feel like an extension of HTML and CSS, so anyone with basic web-production skills can create next-generation web experiences by adding the power of Ajax to their pages.
Spry can be used with any server-side technology (ColdFusion, PHP, ASP.Net etc.). By building the front-end of your web application with Spry you enable a more efficient designer-developer workflow by keeping UI separated from back-end application logic.
Home:
http://labs.adobe.com/technologies/spry/home.html
Demos:
http://labs.adobe.com/technologies/spry/samples/ Wednesday, September 24, 2008 The Yahoo! User Interface (YUI) Library is a set of utilities and controls, written in JavaScript, for building richly interactive web applications using techniques such as DOM scripting, DHTML and AJAX. The YUI Library also includes several core CSS resources. All components in the YUI Library have been released as open source under a BSD license and are free for all uses.
|