Using the Form onLoad Event to Default Task Values Friday, Sep 1 2006


Articles on SQL Reporting Services Thursday, Jun 29 2006 

Great articles on SQL Reporting Services

Introduction to create a simple report Thursday, Jun 29 2006 

Here’s a great article on how to create a report for beginners:

Using the SQL Server 2000 Reporting Services

Copying Ship To Address to Bill To Address Tuesday, Jun 6 2006 

Do you have Billing and Shipping Addresses on any of your forms? Do you have customers that keep asking if there is a way to click a button and copy the address from one to the other if they are the same? Well, here is a sample piece of code I built that will do just that. This assumes that you are making the Billing Address the same as the Shipping Address, but you can modify it to fit any scenario and adjust the fields included as needed.

Thanks to David Pritchett from ePartners to providing me with this code for the blog.

1) Create an attribute (I used a bit –Yes/No). Call it something like “Billing Same As Shipping.”

2) Put this attribute on your form where the addresses are.

3) Add the following code to the OnChange event of this new attribute and enable:

/* Declare your variables to store the data from the Address fields on the form so we can reference them later */

var osaddress1_line1 = document.crmForm.all.address1_line1.DataValue;

var osaddress1_line2 = document.crmForm.all.address1_line2.DataValue;

var osaddress1_line3 = document.crmForm.all.address1_line3.DataValue;

var osaddress1_city = document.crmForm.all.address1_city.DataValue;

var osaddress1_stateorprovince = document.crmForm.all.address1_stateorprovince.DataValue;

var osaddress1_county = document.crmForm.all.address1_county.DataValue;

var osaddress1_postalcode = document.crmForm.all.address1_postalcode.DataValue;

var osaddress1_country = document.crmForm.all.address1_country.DataValue;

var osaddress1_fax = document.crmForm.all.address1_fax.DataValue;

var osaddress1_telephone = document.crmForm.all.address1_telephone1.DataValue;

/* Declare your variable to capture the data from the attribute being changed – Billing Same As Shipping in this case */

var oField = event.srcElement;

/* If the value of the Billing Same As Shipping field you captured is 1 (Yes), then update all of the corresponding Billing Address fields with the data from the Address fields */

if (oField.DataValue == 1)


document.crmForm.all.address2_line1.DataValue = osaddress1_line1;

document.crmForm.all.address2_line2.DataValue = osaddress1_line2;

document.crmForm.all.address2_line3.DataValue = osaddress1_line3;

document.crmForm.all.address2_city.DataValue= osaddress1_city;

document.crmForm.all.address2_stateorprovince.DataValue = osaddress1_stateorprovince;

document.crmForm.all.address2_county.DataValue = osaddress1_county;

document.crmForm.all.address2_postalcode.DataValue = osaddress1_postalcode;

document.crmForm.all.address2_country.DataValue = osaddress1_country;

document.crmForm.all.address2_fax.DataValue = osaddress1_fax;

document.crmForm.all.address2_telephone1.DataValue = osaddress1_telephone;


There you have it! All of the data from the Shipping Address fields will be copied to the Billing Address fields when you select the “Yes” option on your new attribute.


Author: Ben Vollmer


Gridview with Object Data Source Friday, May 19 2006

How to add a Login, Roles and Profiles system Thursday, May 11 2006

Membership/Role Management using Object Data Source Wednesday, May 10 2006 

You can find articles and source code here for membership/role management using Object Data Source/ASP.NET 2.0

Deploying Web Application to Tomcat 4.0 Wednesday, May 10 2006 

Deploying Web Applications to Tomcat by James Goodwill — James Goodwill takes us through the web application deployment process for the Apache Tomcat Web server.

Accessing the different controls inside a GridView control Wednesday, May 10 2006 

Are you curious on how to access label, text box or other controls in Gridview? I have found an article showing all the details. If you are too curious, click here

How to remove duplicate rows from a table in SQL Server Wednesday, May 3 2006 


Microsoft SQL Server tables should never contain duplicate rows, nor non-unique primary keys. For brevity, we will sometimes refer to primary keys as "key" or "PK" in this article, but this will always denote "primary key." Duplicate PKs are a violation of entity integrity, and should be disallowed in a relational system. SQL Server has various mechanisms for enforcing entity integrity, including indexes, UNIQUE constraints, PRIMARY KEY constraints, and triggers.

Despite this, under unusual circumstances duplicate primary keys may occur, and if so they must be eliminated. One way they can occur is if duplicate PKs exist in non-relational data outside SQL Server, and the data is imported while PK uniqueness is not being enforced. Another way they can occur is through a database design error, such as not enforcing entity integrity on each table.

Often duplicate PKs are noticed when you attempt to create a unique index, which will abort if duplicate keys are found. This message is:

Msg 1505, Level 16, State 1 Create unique index aborted on duplicate key.

If you are using SQL Server 2000 or SQL Server 2005, you may receive the following error message:

Msg 1505, Level 16, State 1 CREATE UNIQUE INDEX terminated because a duplicate key was found for object name '%.*ls' and index name '%.*ls'. The duplicate key value is %ls.

This article discusses how to locate and remove duplicate primary keys from a table. However, you should closely examine the process which allowed the duplicates to happen in order to prevent a recurrence.


« Previous PageNext Page »