I'm having the worst time trying to get this simple page working right. I have a page that has two controls one is a ASP Form and another is a RadGrid. I have a suspicious feeling that having these one the same page are the root of the problem, because no mater what I put on the VB code behind page for the RadGrid, nothing behaves. Ultimately I am trying to pull data from a Datasource query and based on the condition/value of the RadGrid field/column to either make a check box checked or not. I have left all my attempts and code just for reference on everything I have tried. I don't get any errors, but I can not get the RadGrid to behave.
The Code Behind and ASPX pages below:
The Code Behind and ASPX pages below:
Imports Telerik.Web.UI
Public Class ContactEdit
Inherits System.Web.UI.Page
Protected Sub ToggleRowSelection(ByVal sender As Object, ByVal e As EventArgs)
TryCast(TryCast(sender, CheckBox).NamingContainer, GridItem).Selected = TryCast(sender, CheckBox).Checked
Dim checkHeader As Boolean = True
For Each dataItem As GridDataItem In RadGrid1.MasterTableView.Items
If Not TryCast(dataItem.FindControl("CATSELECTION"), CheckBox).Checked Then
checkHeader = False
Exit For
End If
Next
Dim headerItem As GridHeaderItem = TryCast(RadGrid1.MasterTableView.GetItems(GridItemType.Header)(0), GridHeaderItem)
TryCast(headerItem.FindControl("headerChkbox"), CheckBox).Checked = checkHeader
End Sub
Protected Sub ToggleSelectedState(ByVal sender As Object, ByVal e As EventArgs)
Dim headerCheckBox As CheckBox = TryCast(sender, CheckBox)
For Each dataItem As GridDataItem In RadGrid1.MasterTableView.Items
TryCast(dataItem.FindControl("CATSELECTION"), CheckBox).Checked = headerCheckBox.Checked
dataItem.Selected = headerCheckBox.Checked
Next
End Sub
Protected Sub RadGrid1_PreRender(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridCommandEventArgs)
Dim headerCheckBox As CheckBox = TryCast(sender, CheckBox)
For Each dataItem As GridDataItem In RadGrid1.MasterTableView.Items
TryCast(dataItem.FindControl("CATSELECTION"), CheckBox).Checked = True
' dataItem.Selected = headerCheckBox.Checked
dataItem.FindControl("CategoryName").Visible = False
Next
End Sub
Protected Sub RadGrid1_ItemDataBound(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridCommandEventArgs)
Dim item As GridDataItem = TryCast(e.Item, GridDataItem)
item.Selected = True
Dim CategoryName As String = item("CategoryName").Text
CategoryName = "test"
If TypeOf e.Item Is GridDataItem Then
'CATSELECTION
'CategoryName
'ContactServiceID
' Dim CategoryName As String = item("CategoryName").Text
'Dim CATSELECTION As CheckBox = item("CATSELECTION")
Dim contactServiceID As String = item("ContactServiceID").Text
'TryCast(TryCast(sender, CheckBox).NamingContainer, GridItem).Selected = TryCast(sender, CheckBox).Checked
Dim catselection As CheckBox = CType(item.FindControl("CATSELECTION"), CheckBox)
Dim headerCheckBox As CheckBox = TryCast(sender, CheckBox)
For Each dataItem As GridDataItem In RadGrid1.MasterTableView.Items
TryCast(dataItem.FindControl("CATSELECTION"), CheckBox).Checked = headerCheckBox.Checked
dataItem.Selected = headerCheckBox.Checked
Next
If contactServiceID <> 0 Then
catselection.Checked = True
item.Selected = True
Else
catselection.Checked = False
item.Selected = False
End If
catselection.Checked = True
End If
End Sub
End Class
<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="ContactEdit.aspx.vb" Inherits="MCDContacts.ContactEdit" %>
<!DOCTYPE html>
<
html
xmlns
=
"http://www.w3.org/1999/xhtml"
>
<
head
runat
=
"server"
>
<
title
></
title
>
<
style
type
=
"text/css"
>
.auto-style1 {
width: 100%;
border-collapse: collapse;
height: 395px;
}
.auto-style2 {
height: 21px;
}
.auto-style5 {
width: 257px;
}
.auto-style6 {
height: 21px;
width: 257px;
}
.auto-style7 {
width: 76px;
}
.auto-style8 {
height: 21px;
width: 76px;
}
.auto-style9 {
width: 257px;
height: 22px;
}
.auto-style10 {
width: 76px;
height: 22px;
}
.auto-style11 {
height: 22px;
}
#form1 {
margin-right: 698px;
width: 816px;
}
.auto-style12 {
width: 100%;
}
.auto-style13 {
width: 198px;
}
.auto-style14 {
width: 504px;
}
</
style
>
</
head
>
<
body
>
<
form
id
=
"form1"
runat
=
"server"
>
<
asp:ScriptManager
ID
=
"ScriptManager1"
runat
=
"server"
>
</
asp:ScriptManager
>
<
div
>
</
div
>
<
asp:SqlDataSource
ID
=
"SqlDataSource1"
runat
=
"server"
ConflictDetection
=
"CompareAllValues"
ConnectionString="<%$ ConnectionStrings:MCD_Contacts_2010ConnectionString %>"
DeleteCommand="DELETE FROM [ContactDetailsTable] WHERE [ContactServiceID] = @original_ContactServiceID AND (([FirstName] = @original_FirstName) OR ([FirstName] IS NULL AND @original_FirstName IS NULL)) AND (([MiddleName] = @original_MiddleName) OR ([MiddleName] IS NULL AND @original_MiddleName IS NULL)) AND (([LastName] = @original_LastName) OR ([LastName] IS NULL AND @original_LastName IS NULL)) AND (([Prefix] = @original_Prefix) OR ([Prefix] IS NULL AND @original_Prefix IS NULL)) AND (([Suffix] = @original_Suffix) OR ([Suffix] IS NULL AND @original_Suffix IS NULL)) AND (([WorkAddressCity] = @original_WorkAddressCity) OR ([WorkAddressCity] IS NULL AND @original_WorkAddressCity IS NULL)) AND (([WorkAddressCountry] = @original_WorkAddressCountry) OR ([WorkAddressCountry] IS NULL AND @original_WorkAddressCountry IS NULL)) AND (([WorkAddressPOB] = @original_WorkAddressPOB) OR ([WorkAddressPOB] IS NULL AND @original_WorkAddressPOB IS NULL)) AND (([WorkAddressZip] = @original_WorkAddressZip) OR ([WorkAddressZip] IS NULL AND @original_WorkAddressZip IS NULL)) AND (([WorkAddressState] = @original_WorkAddressState) OR ([WorkAddressState] IS NULL AND @original_WorkAddressState IS NULL)) AND (([WorkAddressStreet] = @original_WorkAddressStreet) OR ([WorkAddressStreet] IS NULL AND @original_WorkAddressStreet IS NULL)) AND (([HomeAddressCity] = @original_HomeAddressCity) OR ([HomeAddressCity] IS NULL AND @original_HomeAddressCity IS NULL)) AND (([HomeAddressCountry] = @original_HomeAddressCountry) OR ([HomeAddressCountry] IS NULL AND @original_HomeAddressCountry IS NULL)) AND (([HomeAddressPOB] = @original_HomeAddressPOB) OR ([HomeAddressPOB] IS NULL AND @original_HomeAddressPOB IS NULL)) AND (([HomeAddressZip] = @original_HomeAddressZip) OR ([HomeAddressZip] IS NULL AND @original_HomeAddressZip IS NULL)) AND (([HomeAddressState] = @original_HomeAddressState) OR ([HomeAddressState] IS NULL AND @original_HomeAddressState IS NULL)) AND (([HomeAddressStreet] = @original_HomeAddressStreet) OR ([HomeAddressStreet] IS NULL AND @original_HomeAddressStreet IS NULL)) AND (([OtherAddressCity] = @original_OtherAddressCity) OR ([OtherAddressCity] IS NULL AND @original_OtherAddressCity IS NULL)) AND (([OtherAddressCountry] = @original_OtherAddressCountry) OR ([OtherAddressCountry] IS NULL AND @original_OtherAddressCountry IS NULL)) AND (([OtherAddressPOB] = @original_OtherAddressPOB) OR ([OtherAddressPOB] IS NULL AND @original_OtherAddressPOB IS NULL)) AND (([OtherAddressZip] = @original_OtherAddressZip) OR ([OtherAddressZip] IS NULL AND @original_OtherAddressZip IS NULL)) AND (([OtherAddressState] = @original_OtherAddressState) OR ([OtherAddressState] IS NULL AND @original_OtherAddressState IS NULL)) AND (([OtherAddressStreet] = @original_OtherAddressStreet) OR ([OtherAddressStreet] IS NULL AND @original_OtherAddressStreet IS NULL)) AND (([PhoneNum1] = @original_PhoneNum1) OR ([PhoneNum1] IS NULL AND @original_PhoneNum1 IS NULL)) AND (([BusinessPhone2] = @original_BusinessPhone2) OR ([BusinessPhone2] IS NULL AND @original_BusinessPhone2 IS NULL)) AND (([CallbackNum] = @original_CallbackNum) OR ([CallbackNum] IS NULL AND @original_CallbackNum IS NULL)) AND (([PhoneNum4] = @original_PhoneNum4) OR ([PhoneNum4] IS NULL AND @original_PhoneNum4 IS NULL)) AND (([ISDNNum] = @original_ISDNNum) OR ([ISDNNum] IS NULL AND @original_ISDNNum IS NULL)) AND (([PhoneNum5] = @original_PhoneNum5) OR ([PhoneNum5] IS NULL AND @original_PhoneNum5 IS NULL)) AND (([PrimaryPhoneNum] = @original_PrimaryPhoneNum) OR ([PrimaryPhoneNum] IS NULL AND @original_PrimaryPhoneNum IS NULL)) AND (([RadioPhoneNum] = @original_RadioPhoneNum) OR ([RadioPhoneNum] IS NULL AND @original_RadioPhoneNum IS NULL)) AND (([TelexNum] = @original_TelexNum) OR ([TelexNum] IS NULL AND @original_TelexNum IS NULL)) AND (([PhoneNum6] = @original_PhoneNum6) OR ([PhoneNum6] IS NULL AND @original_PhoneNum6 IS NULL)) AND (([DisplaySelectors] = @original_DisplaySelectors) OR ([DisplaySelectors] IS NULL AND @original_DisplaySelectors IS NULL)) AND (([EmailDisplayAs1] = @original_EmailDisplayAs1) OR ([EmailDisplayAs1] IS NULL AND @original_EmailDisplayAs1 IS NULL)) AND (([EmailDisplayAs2] = @original_EmailDisplayAs2) OR ([EmailDisplayAs2] IS NULL AND @original_EmailDisplayAs2 IS NULL)) AND (([EmailDisplayAs3] = @original_EmailDisplayAs3) OR ([EmailDisplayAs3] IS NULL AND @original_EmailDisplayAs3 IS NULL)) AND (([ContactNotes] = @original_ContactNotes) OR ([ContactNotes] IS NULL AND @original_ContactNotes IS NULL)) AND (([ReferredBy] = @original_ReferredBy) OR ([ReferredBy] IS NULL AND @original_ReferredBy IS NULL)) AND (([LeadSource] = @original_LeadSource) OR ([LeadSource] IS NULL AND @original_LeadSource IS NULL)) AND (([PrefContactMethod] = @original_PrefContactMethod) OR ([PrefContactMethod] IS NULL AND @original_PrefContactMethod IS NULL)) AND [DoNotCall] = @original_DoNotCall AND [DoNotEmail] = @original_DoNotEmail AND [DoNotFax] = @original_DoNotFax AND [DoNotSendLetter] = @original_DoNotSendLetter AND (([AreaOfInterest] = @original_AreaOfInterest) OR ([AreaOfInterest] IS NULL AND @original_AreaOfInterest IS NULL)) AND (([Profession] = @original_Profession) OR ([Profession] IS NULL AND @original_Profession IS NULL)) AND (([ManagerName] = @original_ManagerName) OR ([ManagerName] IS NULL AND @original_ManagerName IS NULL)) AND (([AssistantName] = @original_AssistantName) OR ([AssistantName] IS NULL AND @original_AssistantName IS NULL)) AND (([Birthday] = @original_Birthday) OR ([Birthday] IS NULL AND @original_Birthday IS NULL)) AND (([WeddingAnniversary] = @original_WeddingAnniversary) OR ([WeddingAnniversary] IS NULL AND @original_WeddingAnniversary IS NULL)) AND (([HomeAddress] = @original_HomeAddress) OR ([HomeAddress] IS NULL AND @original_HomeAddress IS NULL)) AND (([OtherAddress] = @original_OtherAddress) OR ([OtherAddress] IS NULL AND @original_OtherAddress IS NULL)) AND (([EmailListType] = @original_EmailListType) OR ([EmailListType] IS NULL AND @original_EmailListType IS NULL)) AND (([AddressBookEmailAddress1] = @original_AddressBookEmailAddress1) OR ([AddressBookEmailAddress1] IS NULL AND @original_AddressBookEmailAddress1 IS NULL)) AND (([AddressBookEmailAddress2] = @original_AddressBookEmailAddress2) OR ([AddressBookEmailAddress2] IS NULL AND @original_AddressBookEmailAddress2 IS NULL)) AND (([AddressBookEmailAddress3] = @original_AddressBookEmailAddress3) OR ([AddressBookEmailAddress3] IS NULL AND @original_AddressBookEmailAddress3 IS NULL)) AND (([AddressBookEmailAddress4] = @original_AddressBookEmailAddress4) OR ([AddressBookEmailAddress4] IS NULL AND @original_AddressBookEmailAddress4 IS NULL)) AND (([AddressBookEmailAddress5] = @original_AddressBookEmailAddress5) OR ([AddressBookEmailAddress5] IS NULL AND @original_AddressBookEmailAddress5 IS NULL)) AND (([AddressBookEmailAddress6] = @original_AddressBookEmailAddress6) OR ([AddressBookEmailAddress6] IS NULL AND @original_AddressBookEmailAddress6 IS NULL)) AND (([EmailAddressType1] = @original_EmailAddressType1) OR ([EmailAddressType1] IS NULL AND @original_EmailAddressType1 IS NULL)) AND (([EmailAddressType2] = @original_EmailAddressType2) OR ([EmailAddressType2] IS NULL AND @original_EmailAddressType2 IS NULL)) AND (([EmailAddressType3] = @original_EmailAddressType3) OR ([EmailAddressType3] IS NULL AND @original_EmailAddressType3 IS NULL)) AND (([EmailAddressType4] = @original_EmailAddressType4) OR ([EmailAddressType4] IS NULL AND @original_EmailAddressType4 IS NULL)) AND (([EmailAddressType5] = @original_EmailAddressType5) OR ([EmailAddressType5] IS NULL AND @original_EmailAddressType5 IS NULL)) AND (([EmailAddressType6] = @original_EmailAddressType6) OR ([EmailAddressType6] IS NULL AND @original_EmailAddressType6 IS NULL)) AND (([AddressBookEntryId1] = @original_AddressBookEntryId1) OR ([AddressBookEntryId1] IS NULL AND @original_AddressBookEntryId1 IS NULL)) AND (([AddressBookEntryId2] = @original_AddressBookEntryId2) OR ([AddressBookEntryId2] IS NULL AND @original_AddressBookEntryId2 IS NULL)) AND (([AddressBookEntryId3] = @original_AddressBookEntryId3) OR ([AddressBookEntryId3] IS NULL AND @original_AddressBookEntryId3 IS NULL)) AND (([AddressBookEntryId4] = @original_AddressBookEntryId4) OR ([AddressBookEntryId4] IS NULL AND @original_AddressBookEntryId4 IS NULL)) AND (([AddressBookEntryId5] = @original_AddressBookEntryId5) OR ([AddressBookEntryId5] IS NULL AND @original_AddressBookEntryId5 IS NULL)) AND (([AddressBookEntryId6] = @original_AddressBookEntryId6) OR ([AddressBookEntryId6] IS NULL AND @original_AddressBookEntryId6 IS NULL)) AND (([MessageDeliveryTime] = @original_MessageDeliveryTime) OR ([MessageDeliveryTime] IS NULL AND @original_MessageDeliveryTime IS NULL)) AND (([CustomerID] = @original_CustomerID) OR ([CustomerID] IS NULL AND @original_CustomerID IS NULL)) AND (([PostalAddressStreet] = @original_PostalAddressStreet) OR ([PostalAddressStreet] IS NULL AND @original_PostalAddressStreet IS NULL)) AND (([PostalAddressCity] = @original_PostalAddressCity) OR ([PostalAddressCity] IS NULL AND @original_PostalAddressCity IS NULL)) AND (([PostalAddressState] = @original_PostalAddressState) OR ([PostalAddressState] IS NULL AND @original_PostalAddressState IS NULL)) AND (([PostalAddressCountry] = @original_PostalAddressCountry) OR ([PostalAddressCountry] IS NULL AND @original_PostalAddressCountry IS NULL)) AND (([PostalAddressPOB] = @original_PostalAddressPOB) OR ([PostalAddressPOB] IS NULL AND @original_PostalAddressPOB IS NULL)) AND (([AssignedTo] = @original_AssignedTo) OR ([AssignedTo] IS NULL AND @original_AssignedTo IS NULL)) AND (([IMAddress] = @original_IMAddress) OR ([IMAddress] IS NULL AND @original_IMAddress IS NULL)) AND (([OfficeLocation] = @original_OfficeLocation) OR ([OfficeLocation] IS NULL AND @original_OfficeLocation IS NULL)) AND (([Nickname] = @original_Nickname) OR ([Nickname] IS NULL AND @original_Nickname IS NULL)) AND (([Children] = @original_Children) OR ([Children] IS NULL AND @original_Children IS NULL)) AND (([Hobby] = @original_Hobby) OR ([Hobby] IS NULL AND @original_Hobby IS NULL)) AND (([Spouse] = @original_Spouse) OR ([Spouse] IS NULL AND @original_Spouse IS NULL)) AND (([ReferredEntryId] = @original_ReferredEntryId) OR ([ReferredEntryId] IS NULL AND @original_ReferredEntryId IS NULL)) AND (([CompressedRichText] = @original_CompressedRichText) OR ([CompressedRichText] IS NULL AND @original_CompressedRichText IS NULL)) AND (([User1] = @original_User1) OR ([User1] IS NULL AND @original_User1 IS NULL)) AND (([User2] = @original_User2) OR ([User2] IS NULL AND @original_User2 IS NULL)) AND (([User3] = @original_User3) OR ([User3] IS NULL AND @original_User3 IS NULL)) AND (([User4] = @original_User4) OR ([User4] IS NULL AND @original_User4 IS NULL)) AND (([PercentComplete] = @original_PercentComplete) OR ([PercentComplete] IS NULL AND @original_PercentComplete IS NULL)) AND (([YomiFirstName] = @original_YomiFirstName) OR ([YomiFirstName] IS NULL AND @original_YomiFirstName IS NULL)) AND (([YomiLastName] = @original_YomiLastName) OR ([YomiLastName] IS NULL AND @original_YomiLastName IS NULL)) AND (([YomiCompanyName] = @original_YomiCompanyName) OR ([YomiCompanyName] IS NULL AND @original_YomiCompanyName IS NULL)) AND (([Territory] = @original_Territory) OR ([Territory] IS NULL AND @original_Territory IS NULL)) AND (([TypeOfEntity] = @original_TypeOfEntity) OR ([TypeOfEntity] IS NULL AND @original_TypeOfEntity IS NULL)) AND (([AccountNumber] = @original_AccountNumber) OR ([AccountNumber] IS NULL AND @original_AccountNumber IS NULL)) AND (([Revenue] = @original_Revenue) OR ([Revenue] IS NULL AND @original_Revenue IS NULL)) AND (([TickerSymbol] = @original_TickerSymbol) OR ([TickerSymbol] IS NULL AND @original_TickerSymbol IS NULL)) AND (([Employees] = @original_Employees) OR ([Employees] IS NULL AND @original_Employees IS NULL)) AND (([YomiAccountName] = @original_YomiAccountName) OR ([YomiAccountName] IS NULL AND @original_YomiAccountName IS NULL)) AND (([OpportunityType] = @original_OpportunityType) OR ([OpportunityType] IS NULL AND @original_OpportunityType IS NULL)) AND (([Probability] = @original_Probability) OR ([Probability] IS NULL AND @original_Probability IS NULL)) AND (([OpportunityStage] = @original_OpportunityStage) OR ([OpportunityStage] IS NULL AND @original_OpportunityStage IS NULL)) AND (([OpportunityStatus] = @original_OpportunityStatus) OR ([OpportunityStatus] IS NULL AND @original_OpportunityStatus IS NULL)) AND (([OpportunityCloseDate] = @original_OpportunityCloseDate) OR ([OpportunityCloseDate] IS NULL AND @original_OpportunityCloseDate IS NULL)) AND (([Competition] = @original_Competition) OR ([Competition] IS NULL AND @original_Competition IS NULL)) AND (([PaymentTerms] = @original_PaymentTerms) OR ([PaymentTerms] IS NULL AND @original_PaymentTerms IS NULL)) AND (([ExpirationDate] = @original_ExpirationDate) OR ([ExpirationDate] IS NULL AND @original_ExpirationDate IS NULL)) AND (([DeliveryDate] = @original_DeliveryDate) OR ([DeliveryDate] IS NULL AND @original_DeliveryDate IS NULL)) AND (([ProjectStartDate] = @original_ProjectStartDate) OR ([ProjectStartDate] IS NULL AND @original_ProjectStartDate IS NULL)) AND (([ProjectDueDate] = @original_ProjectDueDate) OR ([ProjectDueDate] IS NULL AND @original_ProjectDueDate IS NULL)) AND (([Priority] = @original_Priority) OR ([Priority] IS NULL AND @original_Priority IS NULL)) AND (([ProjectStatus] = @original_ProjectStatus) OR ([ProjectStatus] IS NULL AND @original_ProjectStatus IS NULL)) AND (([ProjectType] = @original_ProjectType) OR ([ProjectType] IS NULL AND @original_ProjectType IS NULL))" InsertCommand="INSERT INTO [ContactDetailsTable] ([ContactServiceID], [FirstName], [MiddleName], [LastName], [Prefix], [Suffix], [WorkAddressCity], [WorkAddressCountry], [WorkAddressPOB], [WorkAddressZip], [WorkAddressState], [WorkAddressStreet], [HomeAddressCity], [HomeAddressCountry], [HomeAddressPOB], [HomeAddressZip], [HomeAddressState], [HomeAddressStreet], [OtherAddressCity], [OtherAddressCountry], [OtherAddressPOB], [OtherAddressZip], [OtherAddressState], [OtherAddressStreet], [PhoneNum1], [BusinessPhone2], [CallbackNum], [PhoneNum4], [ISDNNum], [PhoneNum5], [PrimaryPhoneNum], [RadioPhoneNum], [TelexNum], [PhoneNum6], [DisplaySelectors], [EmailDisplayAs1], [EmailDisplayAs2], [EmailDisplayAs3], [ContactNotes], [ReferredBy], [LeadSource], [PrefContactMethod], [DoNotCall], [DoNotEmail], [DoNotFax], [DoNotSendLetter], [AreaOfInterest], [Profession], [ManagerName], [AssistantName], [Birthday], [WeddingAnniversary], [HomeAddress], [OtherAddress], [EmailListType], [AddressBookEmailAddress1], [AddressBookEmailAddress2], [AddressBookEmailAddress3], [AddressBookEmailAddress4], [AddressBookEmailAddress5], [AddressBookEmailAddress6], [EmailAddressType1], [EmailAddressType2], [EmailAddressType3], [EmailAddressType4], [EmailAddressType5], [EmailAddressType6], [AddressBookEntryId1], [AddressBookEntryId2], [AddressBookEntryId3], [AddressBookEntryId4], [AddressBookEntryId5], [AddressBookEntryId6], [MessageDeliveryTime], [CustomerID], [PostalAddressStreet], [PostalAddressCity], [PostalAddressState], [PostalAddressCountry], [PostalAddressPOB], [AssignedTo], [IMAddress], [OfficeLocation], [Nickname], [Children], [Hobby], [Spouse], [ReferredEntryId], [CompressedRichText], [User1], [User2], [User3], [User4], [PercentComplete], [YomiFirstName], [YomiLastName], [YomiCompanyName], [Territory], [TypeOfEntity], [AccountNumber], [Revenue], [TickerSymbol], [Employees], [YomiAccountName], [OpportunityType], [Probability], [OpportunityStage], [OpportunityStatus], [OpportunityCloseDate], [Competition], [PaymentTerms], [ExpirationDate], [DeliveryDate], [ProjectStartDate], [ProjectDueDate], [Priority], [ProjectStatus], [ProjectType]) VALUES (@ContactServiceID, @FirstName, @MiddleName, @LastName, @Prefix, @Suffix, @WorkAddressCity, @WorkAddressCountry, @WorkAddressPOB, @WorkAddressZip, @WorkAddressState, @WorkAddressStreet, @HomeAddressCity, @HomeAddressCountry, @HomeAddressPOB, @HomeAddressZip, @HomeAddressState, @HomeAddressStreet, @OtherAddressCity, @OtherAddressCountry, @OtherAddressPOB, @OtherAddressZip, @OtherAddressState, @OtherAddressStreet, @PhoneNum1, @BusinessPhone2, @CallbackNum, @PhoneNum4, @ISDNNum, @PhoneNum5, @PrimaryPhoneNum, @RadioPhoneNum, @TelexNum, @PhoneNum6, @DisplaySelectors, @EmailDisplayAs1, @EmailDisplayAs2, @EmailDisplayAs3, @ContactNotes, @ReferredBy, @LeadSource, @PrefContactMethod, @DoNotCall, @DoNotEmail, @DoNotFax, @DoNotSendLetter, @AreaOfInterest, @Profession, @ManagerName, @AssistantName, @Birthday, @WeddingAnniversary, @HomeAddress, @OtherAddress, @EmailListType, @AddressBookEmailAddress1, @AddressBookEmailAddress2, @AddressBookEmailAddress3, @AddressBookEmailAddress4, @AddressBookEmailAddress5, @AddressBookEmailAddress6, @EmailAddressType1, @EmailAddressType2, @EmailAddressType3, @EmailAddressType4, @EmailAddressType5, @EmailAddressType6, @AddressBookEntryId1, @AddressBookEntryId2, @AddressBookEntryId3, @AddressBookEntryId4, @AddressBookEntryId5, @AddressBookEntryId6, @MessageDeliveryTime, @CustomerID, @PostalAddressStreet, @PostalAddressCity, @PostalAddressState, @PostalAddressCountry, @PostalAddressPOB, @AssignedTo, @IMAddress, @OfficeLocation, @Nickname, @Children, @Hobby, @Spouse, @ReferredEntryId, @CompressedRichText, @User1, @User2, @User3, @User4, @PercentComplete, @YomiFirstName, @YomiLastName, @YomiCompanyName, @Territory, @TypeOfEntity, @AccountNumber, @Revenue, @TickerSymbol, @Employees, @YomiAccountName, @OpportunityType, @Probability, @OpportunityStage, @OpportunityStatus, @OpportunityCloseDate, @Competition, @PaymentTerms, @ExpirationDate, @DeliveryDate, @ProjectStartDate, @ProjectDueDate, @Priority, @ProjectStatus, @ProjectType)" OldValuesParameterFormatString="original_{0}"
SelectCommand="SELECT * FROM [ContactDetailsTable] WHERE ([ContactServiceID] = @ContactServiceID)"
UpdateCommand="UPDATE [ContactDetailsTable] SET
[FirstName] = @FirstName,
[MiddleName] = @MiddleName,
[LastName] = @LastName,
[Prefix] = @Prefix,
[Suffix] = @Suffix,
[WorkAddressCity] = @WorkAddressCity,
[WorkAddressCountry] = @WorkAddressCountry,
[WorkAddressPOB] = @WorkAddressPOB,
[WorkAddressZip] = @WorkAddressZip,
[WorkAddressState] = @WorkAddressState,
[WorkAddressStreet] = @WorkAddressStreet,
[PhoneNum1] = @PhoneNum1,
[BusinessPhone2] = @BusinessPhone2,
[EmailDisplayAs1] = @EmailDisplayAs1,
[EmailDisplayAs2] = @EmailDisplayAs2,
[ContactNotes] = @ContactNotes,
[AddressBookEmailAddress1] = @AddressBookEmailAddress1,
[AddressBookEmailAddress2] = @AddressBookEmailAddress2,
[CustomerID] = @CustomerID,
[PostalAddressStreet] = @PostalAddressStreet,
[PostalAddressCity] = @PostalAddressCity,
[PostalAddressState] = @PostalAddressState,
[PostalAddressCountry] = @PostalAddressCountry,
[PostalAddressPOB] = @PostalAddressPOB
WHERE [ContactServiceID] = @original_ContactServiceID ">
<
DeleteParameters
>
<
asp:Parameter
Name
=
"original_ContactServiceID"
Type
=
"Int32"
/>
<
asp:Parameter
Name
=
"original_FirstName"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_MiddleName"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_LastName"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_Prefix"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_Suffix"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_WorkAddressCity"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_WorkAddressCountry"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_WorkAddressPOB"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_WorkAddressZip"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_WorkAddressState"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_WorkAddressStreet"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_HomeAddressCity"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_HomeAddressCountry"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_HomeAddressPOB"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_HomeAddressZip"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_HomeAddressState"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_HomeAddressStreet"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_OtherAddressCity"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_OtherAddressCountry"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_OtherAddressPOB"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_OtherAddressZip"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_OtherAddressState"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_OtherAddressStreet"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_PhoneNum1"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_BusinessPhone2"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_CallbackNum"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_PhoneNum4"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_ISDNNum"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_PhoneNum5"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_PrimaryPhoneNum"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_RadioPhoneNum"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_TelexNum"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_PhoneNum6"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_DisplaySelectors"
Type
=
"Object"
/>
<
asp:Parameter
Name
=
"original_EmailDisplayAs1"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_EmailDisplayAs2"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_EmailDisplayAs3"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_ContactNotes"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_ReferredBy"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_LeadSource"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_PrefContactMethod"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_DoNotCall"
Type
=
"Boolean"
/>
<
asp:Parameter
Name
=
"original_DoNotEmail"
Type
=
"Boolean"
/>
<
asp:Parameter
Name
=
"original_DoNotFax"
Type
=
"Boolean"
/>
<
asp:Parameter
Name
=
"original_DoNotSendLetter"
Type
=
"Boolean"
/>
<
asp:Parameter
Name
=
"original_AreaOfInterest"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_Profession"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_ManagerName"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_AssistantName"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_Birthday"
Type
=
"DateTime"
/>
<
asp:Parameter
Name
=
"original_WeddingAnniversary"
Type
=
"DateTime"
/>
<
asp:Parameter
Name
=
"original_HomeAddress"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_OtherAddress"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_EmailListType"
Type
=
"Int32"
/>
<
asp:Parameter
Name
=
"original_AddressBookEmailAddress1"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_AddressBookEmailAddress2"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_AddressBookEmailAddress3"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_AddressBookEmailAddress4"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_AddressBookEmailAddress5"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_AddressBookEmailAddress6"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_EmailAddressType1"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_EmailAddressType2"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_EmailAddressType3"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_EmailAddressType4"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_EmailAddressType5"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_EmailAddressType6"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_AddressBookEntryId1"
Type
=
"Object"
/>
<
asp:Parameter
Name
=
"original_AddressBookEntryId2"
Type
=
"Object"
/>
<
asp:Parameter
Name
=
"original_AddressBookEntryId3"
Type
=
"Object"
/>
<
asp:Parameter
Name
=
"original_AddressBookEntryId4"
Type
=
"Object"
/>
<
asp:Parameter
Name
=
"original_AddressBookEntryId5"
Type
=
"Object"
/>
<
asp:Parameter
Name
=
"original_AddressBookEntryId6"
Type
=
"Object"
/>
<
asp:Parameter
Name
=
"original_MessageDeliveryTime"
Type
=
"DateTime"
/>
<
asp:Parameter
Name
=
"original_CustomerID"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_PostalAddressStreet"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_PostalAddressCity"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_PostalAddressState"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_PostalAddressCountry"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_PostalAddressPOB"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_AssignedTo"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_IMAddress"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_OfficeLocation"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_Nickname"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_Children"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_Hobby"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_Spouse"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_ReferredEntryId"
Type
=
"Object"
/>
<
asp:Parameter
Name
=
"original_CompressedRichText"
Type
=
"Object"
/>
<
asp:Parameter
Name
=
"original_User1"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_User2"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_User3"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_User4"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_PercentComplete"
Type
=
"Double"
/>
<
asp:Parameter
Name
=
"original_YomiFirstName"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_YomiLastName"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_YomiCompanyName"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_Territory"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_TypeOfEntity"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_AccountNumber"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_Revenue"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_TickerSymbol"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_Employees"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_YomiAccountName"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_OpportunityType"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_Probability"
Type
=
"Double"
/>
<
asp:Parameter
Name
=
"original_OpportunityStage"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_OpportunityStatus"
Type
=
"Byte"
/>
<
asp:Parameter
Name
=
"original_OpportunityCloseDate"
Type
=
"DateTime"
/>
<
asp:Parameter
Name
=
"original_Competition"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_PaymentTerms"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_ExpirationDate"
Type
=
"DateTime"
/>
<
asp:Parameter
Name
=
"original_DeliveryDate"
Type
=
"DateTime"
/>
<
asp:Parameter
Name
=
"original_ProjectStartDate"
Type
=
"DateTime"
/>
<
asp:Parameter
Name
=
"original_ProjectDueDate"
Type
=
"DateTime"
/>
<
asp:Parameter
Name
=
"original_Priority"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_ProjectStatus"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_ProjectType"
Type
=
"String"
/>
</
DeleteParameters
>
<
InsertParameters
>
<
asp:Parameter
Name
=
"ContactServiceID"
Type
=
"Int32"
/>
<
asp:Parameter
Name
=
"FirstName"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"MiddleName"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"LastName"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Prefix"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Suffix"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"WorkAddressCity"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"WorkAddressCountry"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"WorkAddressPOB"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"WorkAddressZip"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"WorkAddressState"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"WorkAddressStreet"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"HomeAddressCity"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"HomeAddressCountry"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"HomeAddressPOB"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"HomeAddressZip"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"HomeAddressState"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"HomeAddressStreet"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"OtherAddressCity"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"OtherAddressCountry"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"OtherAddressPOB"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"OtherAddressZip"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"OtherAddressState"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"OtherAddressStreet"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"PhoneNum1"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"BusinessPhone2"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"CallbackNum"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"PhoneNum4"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"ISDNNum"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"PhoneNum5"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"PrimaryPhoneNum"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"RadioPhoneNum"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"TelexNum"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"PhoneNum6"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"DisplaySelectors"
Type
=
"Object"
/>
<
asp:Parameter
Name
=
"EmailDisplayAs1"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"EmailDisplayAs2"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"EmailDisplayAs3"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"ContactNotes"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"ReferredBy"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"LeadSource"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"PrefContactMethod"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"DoNotCall"
Type
=
"Boolean"
/>
<
asp:Parameter
Name
=
"DoNotEmail"
Type
=
"Boolean"
/>
<
asp:Parameter
Name
=
"DoNotFax"
Type
=
"Boolean"
/>
<
asp:Parameter
Name
=
"DoNotSendLetter"
Type
=
"Boolean"
/>
<
asp:Parameter
Name
=
"AreaOfInterest"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Profession"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"ManagerName"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"AssistantName"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Birthday"
Type
=
"DateTime"
/>
<
asp:Parameter
Name
=
"WeddingAnniversary"
Type
=
"DateTime"
/>
<
asp:Parameter
Name
=
"HomeAddress"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"OtherAddress"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"EmailListType"
Type
=
"Int32"
/>
<
asp:Parameter
Name
=
"AddressBookEmailAddress1"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"AddressBookEmailAddress2"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"AddressBookEmailAddress3"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"AddressBookEmailAddress4"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"AddressBookEmailAddress5"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"AddressBookEmailAddress6"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"EmailAddressType1"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"EmailAddressType2"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"EmailAddressType3"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"EmailAddressType4"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"EmailAddressType5"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"EmailAddressType6"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"AddressBookEntryId1"
Type
=
"Object"
/>
<
asp:Parameter
Name
=
"AddressBookEntryId2"
Type
=
"Object"
/>
<
asp:Parameter
Name
=
"AddressBookEntryId3"
Type
=
"Object"
/>
<
asp:Parameter
Name
=
"AddressBookEntryId4"
Type
=
"Object"
/>
<
asp:Parameter
Name
=
"AddressBookEntryId5"
Type
=
"Object"
/>
<
asp:Parameter
Name
=
"AddressBookEntryId6"
Type
=
"Object"
/>
<
asp:Parameter
Name
=
"MessageDeliveryTime"
Type
=
"DateTime"
/>
<
asp:Parameter
Name
=
"CustomerID"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"PostalAddressStreet"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"PostalAddressCity"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"PostalAddressState"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"PostalAddressCountry"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"PostalAddressPOB"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"AssignedTo"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"IMAddress"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"OfficeLocation"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Nickname"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Children"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Hobby"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Spouse"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"ReferredEntryId"
Type
=
"Object"
/>
<
asp:Parameter
Name
=
"CompressedRichText"
Type
=
"Object"
/>
<
asp:Parameter
Name
=
"User1"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"User2"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"User3"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"User4"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"PercentComplete"
Type
=
"Double"
/>
<
asp:Parameter
Name
=
"YomiFirstName"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"YomiLastName"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"YomiCompanyName"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Territory"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"TypeOfEntity"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"AccountNumber"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Revenue"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"TickerSymbol"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Employees"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"YomiAccountName"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"OpportunityType"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Probability"
Type
=
"Double"
/>
<
asp:Parameter
Name
=
"OpportunityStage"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"OpportunityStatus"
Type
=
"Byte"
/>
<
asp:Parameter
Name
=
"OpportunityCloseDate"
Type
=
"DateTime"
/>
<
asp:Parameter
Name
=
"Competition"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"PaymentTerms"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"ExpirationDate"
Type
=
"DateTime"
/>
<
asp:Parameter
Name
=
"DeliveryDate"
Type
=
"DateTime"
/>
<
asp:Parameter
Name
=
"ProjectStartDate"
Type
=
"DateTime"
/>
<
asp:Parameter
Name
=
"ProjectDueDate"
Type
=
"DateTime"
/>
<
asp:Parameter
Name
=
"Priority"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"ProjectStatus"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"ProjectType"
Type
=
"String"
/>
</
InsertParameters
>
<
SelectParameters
>
<
asp:QueryStringParameter
Name
=
"ContactServiceID"
QueryStringField
=
"ContactServiceID"
Type
=
"Int32"
/>
</
SelectParameters
>
<
UpdateParameters
>
<
asp:Parameter
Name
=
"FirstName"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"MiddleName"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"LastName"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Prefix"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Suffix"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"WorkAddressCity"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"WorkAddressCountry"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"WorkAddressPOB"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"WorkAddressZip"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"WorkAddressState"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"WorkAddressStreet"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"HomeAddressCity"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"HomeAddressCountry"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"HomeAddressPOB"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"HomeAddressZip"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"HomeAddressState"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"HomeAddressStreet"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"OtherAddressCity"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"OtherAddressCountry"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"OtherAddressPOB"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"OtherAddressZip"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"OtherAddressState"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"OtherAddressStreet"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"PhoneNum1"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"BusinessPhone2"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"CallbackNum"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"PhoneNum4"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"ISDNNum"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"PhoneNum5"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"PrimaryPhoneNum"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"RadioPhoneNum"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"TelexNum"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"PhoneNum6"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"DisplaySelectors"
Type
=
"Object"
/>
<
asp:Parameter
Name
=
"EmailDisplayAs1"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"EmailDisplayAs2"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"EmailDisplayAs3"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"ContactNotes"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"ReferredBy"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"LeadSource"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"PrefContactMethod"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"DoNotCall"
Type
=
"Boolean"
/>
<
asp:Parameter
Name
=
"DoNotEmail"
Type
=
"Boolean"
/>
<
asp:Parameter
Name
=
"DoNotFax"
Type
=
"Boolean"
/>
<
asp:Parameter
Name
=
"DoNotSendLetter"
Type
=
"Boolean"
/>
<
asp:Parameter
Name
=
"AreaOfInterest"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Profession"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"ManagerName"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"AssistantName"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Birthday"
Type
=
"DateTime"
/>
<
asp:Parameter
Name
=
"WeddingAnniversary"
Type
=
"DateTime"
/>
<
asp:Parameter
Name
=
"HomeAddress"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"OtherAddress"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"EmailListType"
Type
=
"Int32"
/>
<
asp:Parameter
Name
=
"AddressBookEmailAddress1"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"AddressBookEmailAddress2"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"AddressBookEmailAddress3"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"AddressBookEmailAddress4"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"AddressBookEmailAddress5"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"AddressBookEmailAddress6"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"EmailAddressType1"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"EmailAddressType2"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"EmailAddressType3"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"EmailAddressType4"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"EmailAddressType5"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"EmailAddressType6"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"AddressBookEntryId1"
Type
=
"Object"
/>
<
asp:Parameter
Name
=
"AddressBookEntryId2"
Type
=
"Object"
/>
<
asp:Parameter
Name
=
"AddressBookEntryId3"
Type
=
"Object"
/>
<
asp:Parameter
Name
=
"AddressBookEntryId4"
Type
=
"Object"
/>
<
asp:Parameter
Name
=
"AddressBookEntryId5"
Type
=
"Object"
/>
<
asp:Parameter
Name
=
"AddressBookEntryId6"
Type
=
"Object"
/>
<
asp:Parameter
Name
=
"MessageDeliveryTime"
Type
=
"DateTime"
/>
<
asp:Parameter
Name
=
"CustomerID"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"PostalAddressStreet"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"PostalAddressCity"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"PostalAddressState"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"PostalAddressCountry"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"PostalAddressPOB"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"AssignedTo"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"IMAddress"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"OfficeLocation"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Nickname"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Children"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Hobby"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Spouse"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"ReferredEntryId"
Type
=
"Object"
/>
<
asp:Parameter
Name
=
"CompressedRichText"
Type
=
"Object"
/>
<
asp:Parameter
Name
=
"User1"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"User2"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"User3"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"User4"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"PercentComplete"
Type
=
"Double"
/>
<
asp:Parameter
Name
=
"YomiFirstName"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"YomiLastName"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"YomiCompanyName"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Territory"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"TypeOfEntity"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"AccountNumber"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Revenue"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"TickerSymbol"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Employees"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"YomiAccountName"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"OpportunityType"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Probability"
Type
=
"Double"
/>
<
asp:Parameter
Name
=
"OpportunityStage"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"OpportunityStatus"
Type
=
"Byte"
/>
<
asp:Parameter
Name
=
"OpportunityCloseDate"
Type
=
"DateTime"
/>
<
asp:Parameter
Name
=
"Competition"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"PaymentTerms"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"ExpirationDate"
Type
=
"DateTime"
/>
<
asp:Parameter
Name
=
"DeliveryDate"
Type
=
"DateTime"
/>
<
asp:Parameter
Name
=
"ProjectStartDate"
Type
=
"DateTime"
/>
<
asp:Parameter
Name
=
"ProjectDueDate"
Type
=
"DateTime"
/>
<
asp:Parameter
Name
=
"Priority"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"ProjectStatus"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"ProjectType"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_ContactServiceID"
Type
=
"Int32"
/>
<
asp:Parameter
Name
=
"original_FirstName"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_MiddleName"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_LastName"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_Prefix"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_Suffix"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_WorkAddressCity"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_WorkAddressCountry"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_WorkAddressPOB"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_WorkAddressZip"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_WorkAddressState"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_WorkAddressStreet"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_HomeAddressCity"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_HomeAddressCountry"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_HomeAddressPOB"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_HomeAddressZip"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_HomeAddressState"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_HomeAddressStreet"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_OtherAddressCity"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_OtherAddressCountry"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_OtherAddressPOB"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_OtherAddressZip"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_OtherAddressState"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_OtherAddressStreet"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_PhoneNum1"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_BusinessPhone2"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_CallbackNum"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_PhoneNum4"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_ISDNNum"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_PhoneNum5"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_PrimaryPhoneNum"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_RadioPhoneNum"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_TelexNum"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_PhoneNum6"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_DisplaySelectors"
Type
=
"Object"
/>
<
asp:Parameter
Name
=
"original_EmailDisplayAs1"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_EmailDisplayAs2"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_EmailDisplayAs3"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_ContactNotes"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_ReferredBy"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_LeadSource"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_PrefContactMethod"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_DoNotCall"
Type
=
"Boolean"
/>
<
asp:Parameter
Name
=
"original_DoNotEmail"
Type
=
"Boolean"
/>
<
asp:Parameter
Name
=
"original_DoNotFax"
Type
=
"Boolean"
/>
<
asp:Parameter
Name
=
"original_DoNotSendLetter"
Type
=
"Boolean"
/>
<
asp:Parameter
Name
=
"original_AreaOfInterest"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_Profession"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_ManagerName"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_AssistantName"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_Birthday"
Type
=
"DateTime"
/>
<
asp:Parameter
Name
=
"original_WeddingAnniversary"
Type
=
"DateTime"
/>
<
asp:Parameter
Name
=
"original_HomeAddress"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_OtherAddress"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_EmailListType"
Type
=
"Int32"
/>
<
asp:Parameter
Name
=
"original_AddressBookEmailAddress1"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_AddressBookEmailAddress2"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_AddressBookEmailAddress3"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_AddressBookEmailAddress4"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_AddressBookEmailAddress5"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_AddressBookEmailAddress6"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_EmailAddressType1"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_EmailAddressType2"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_EmailAddressType3"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_EmailAddressType4"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_EmailAddressType5"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_EmailAddressType6"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_AddressBookEntryId1"
Type
=
"Object"
/>
<
asp:Parameter
Name
=
"original_AddressBookEntryId2"
Type
=
"Object"
/>
<
asp:Parameter
Name
=
"original_AddressBookEntryId3"
Type
=
"Object"
/>
<
asp:Parameter
Name
=
"original_AddressBookEntryId4"
Type
=
"Object"
/>
<
asp:Parameter
Name
=
"original_AddressBookEntryId5"
Type
=
"Object"
/>
<
asp:Parameter
Name
=
"original_AddressBookEntryId6"
Type
=
"Object"
/>
<
asp:Parameter
Name
=
"original_MessageDeliveryTime"
Type
=
"DateTime"
/>
<
asp:Parameter
Name
=
"original_CustomerID"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_PostalAddressStreet"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_PostalAddressCity"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_PostalAddressState"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_PostalAddressCountry"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_PostalAddressPOB"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_AssignedTo"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_IMAddress"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_OfficeLocation"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_Nickname"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_Children"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_Hobby"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_Spouse"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_ReferredEntryId"
Type
=
"Object"
/>
<
asp:Parameter
Name
=
"original_CompressedRichText"
Type
=
"Object"
/>
<
asp:Parameter
Name
=
"original_User1"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_User2"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_User3"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_User4"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_PercentComplete"
Type
=
"Double"
/>
<
asp:Parameter
Name
=
"original_YomiFirstName"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_YomiLastName"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_YomiCompanyName"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_Territory"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_TypeOfEntity"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_AccountNumber"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_Revenue"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_TickerSymbol"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_Employees"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_YomiAccountName"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_OpportunityType"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_Probability"
Type
=
"Double"
/>
<
asp:Parameter
Name
=
"original_OpportunityStage"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_OpportunityStatus"
Type
=
"Byte"
/>
<
asp:Parameter
Name
=
"original_OpportunityCloseDate"
Type
=
"DateTime"
/>
<
asp:Parameter
Name
=
"original_Competition"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_PaymentTerms"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_ExpirationDate"
Type
=
"DateTime"
/>
<
asp:Parameter
Name
=
"original_DeliveryDate"
Type
=
"DateTime"
/>
<
asp:Parameter
Name
=
"original_ProjectStartDate"
Type
=
"DateTime"
/>
<
asp:Parameter
Name
=
"original_ProjectDueDate"
Type
=
"DateTime"
/>
<
asp:Parameter
Name
=
"original_Priority"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_ProjectStatus"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"original_ProjectType"
Type
=
"String"
/>
</
UpdateParameters
>
</
asp:SqlDataSource
>
<
asp:SqlDataSource
ID
=
"SqlDataSource2"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:MCD_Contacts_2010ConnectionString %>" SelectCommand="SELECT C.CategoryName,
ISNULL(NOC.ContactServiceID, 0) as ContactServiceID
FROM (SELECT DISTINCT CategoryName
FROM ContactCategoriesTable) C
LEFT OUTER JOIN ContactCategoriesTable NOC
ON NOC.CategoryName = C.CategoryName
AND NOC.ContactServiceID = @ContactServiceID">
<
SelectParameters
>
<
asp:QueryStringParameter
Name
=
"ContactServiceID"
QueryStringField
=
"ContactServiceID"
/>
</
SelectParameters
>
</
asp:SqlDataSource
>
<
table
class
=
"auto-style12"
>
<
tr
>
<
td
style
=
"vertical-align: top;"
class
=
"auto-style14"
>
<
asp:FormView
ID
=
"FormView1"
runat
=
"server"
CellPadding
=
"4"
DataKeyNames
=
"ContactServiceID"
DataSourceID
=
"SqlDataSource1"
ForeColor
=
"#333333"
>
<
EditItemTemplate
>
<
br
/>
<
table
class
=
"auto-style1"
>
<
tr
>
<
td
class
=
"auto-style9"
>Contact Service ID</
td
>
<
td
class
=
"auto-style10"
>
<
asp:Label
ID
=
"ContactServiceIDLabel"
runat
=
"server"
Text='<%# Eval("ContactServiceID") %>' />
</
td
>
<
td
class
=
"auto-style11"
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style5"
>First Name</
td
>
<
td
class
=
"auto-style7"
>
<
asp:TextBox
ID
=
"FirstNameTextBox"
runat
=
"server"
Text='<%# Bind("FirstName") %>' />
</
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style5"
>Middle Name</
td
>
<
td
class
=
"auto-style7"
>
<
asp:TextBox
ID
=
"MiddleNameTextBox"
runat
=
"server"
Text='<%# Bind("MiddleName") %>' />
</
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style5"
>Last Name</
td
>
<
td
class
=
"auto-style7"
>
<
asp:TextBox
ID
=
"LastNameTextBox"
runat
=
"server"
Text='<%# Bind("LastName") %>' />
</
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style5"
>Prefix</
td
>
<
td
class
=
"auto-style7"
>
<
asp:TextBox
ID
=
"PrefixTextBox"
runat
=
"server"
Text='<%# Bind("Prefix") %>' />
</
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style6"
>Suffix</
td
>
<
td
class
=
"auto-style8"
>
<
asp:TextBox
ID
=
"SuffixTextBox"
runat
=
"server"
Text='<%# Bind("Suffix") %>' />
</
td
>
<
td
class
=
"auto-style2"
></
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style5"
>WorkAddressCity</
td
>
<
td
class
=
"auto-style7"
>
<
asp:TextBox
ID
=
"WorkAddressCityTextBox"
runat
=
"server"
Text='<%# Bind("WorkAddressCity") %>' />
</
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style6"
>[WorkAddressStreet]</
td
>
<
td
class
=
"auto-style8"
>
<
asp:TextBox
ID
=
"WorkAddressStreetTextBox"
runat
=
"server"
Text='<%# Bind("WorkAddressStreet") %>' />
</
td
>
<
td
class
=
"auto-style2"
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style5"
>[WorkAddressPOB]</
td
>
<
td
class
=
"auto-style7"
>
<
asp:TextBox
ID
=
"WorkAddressPOBTextBox"
runat
=
"server"
Text='<%# Bind("WorkAddressPOB") %>' />
</
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style5"
>[WorkAddressZip]</
td
>
<
td
class
=
"auto-style7"
>
<
asp:TextBox
ID
=
"WorkAddressZipTextBox"
runat
=
"server"
Text='<%# Bind("WorkAddressZip") %>' />
</
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style5"
>[WorkAddressState]</
td
>
<
td
class
=
"auto-style7"
>
<
asp:TextBox
ID
=
"WorkAddressStateTextBox"
runat
=
"server"
Text='<%# Bind("WorkAddressState") %>' />
</
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style5"
> </
td
>
<
td
class
=
"auto-style7"
> </
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
>[PostalAddressStreet]</
td
>
<
td
class
=
"auto-style7"
>
<
asp:TextBox
ID
=
"PostalAddressStreetTextBox"
runat
=
"server"
Text='<%# Bind("PostalAddressStreet") %>' />
</
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style2"
>[PostalAddressCity]</
td
>
<
td
class
=
"auto-style7"
>
<
asp:TextBox
ID
=
"PostalAddressCityTextBox"
runat
=
"server"
Text='<%# Bind("PostalAddressCity") %>' />
</
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
>[PostalAddressState]</
td
>
<
td
class
=
"auto-style7"
>
<
asp:TextBox
ID
=
"PostalAddressStateTextBox"
runat
=
"server"
Text='<%# Bind("PostalAddressState") %>' />
</
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
>[PostalAddressPOB]</
td
>
<
td
class
=
"auto-style7"
>
<
asp:TextBox
ID
=
"PostalAddressPOBTextBox"
runat
=
"server"
Text='<%# Bind("PostalAddressPOB") %>' />
</
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style5"
> </
td
>
<
td
class
=
"auto-style7"
> </
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style5"
>PhoneNum1:</
td
>
<
td
class
=
"auto-style7"
>
<
asp:TextBox
ID
=
"PhoneNum1TextBox"
runat
=
"server"
Text='<%# Bind("PhoneNum1") %>' />
</
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style5"
>BusinessPhone2</
td
>
<
td
class
=
"auto-style7"
>
<
asp:TextBox
ID
=
"BusinessPhone2TextBox"
runat
=
"server"
Text='<%# Bind("BusinessPhone2") %>' />
</
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style5"
> </
td
>
<
td
class
=
"auto-style7"
> </
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style5"
>[EmailDisplayAs1]</
td
>
<
td
class
=
"auto-style7"
>
<
asp:TextBox
ID
=
"EmailDisplayAs1TextBox"
runat
=
"server"
Text='<%# Bind("EmailDisplayAs1") %>' />
</
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style5"
>[EmailDisplayAs2]</
td
>
<
td
class
=
"auto-style7"
>
<
asp:TextBox
ID
=
"EmailDisplayAs2TextBox"
runat
=
"server"
Text='<%# Bind("EmailDisplayAs2") %>' />
</
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style5"
>[ContactNotes]</
td
>
<
td
class
=
"auto-style7"
>
<
asp:TextBox
ID
=
"ContactNotesTextBox"
runat
=
"server"
Text='<%# Bind("ContactNotes") %>' />
</
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style5"
>[AddressBookEmailAddress1]</
td
>
<
td
class
=
"auto-style7"
>
<
asp:TextBox
ID
=
"AddressBookEmailAddress1TextBox"
runat
=
"server"
Text='<%# Bind("AddressBookEmailAddress1") %>' />
</
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style5"
>[AddressBookEmailAddress2]</
td
>
<
td
class
=
"auto-style7"
>
<
asp:TextBox
ID
=
"AddressBookEmailAddress2TextBox"
runat
=
"server"
Text='<%# Bind("AddressBookEmailAddress2") %>' />
</
td
>
<
td
> </
td
>
</
tr
>
</
table
>
<
br
/>
<
br
/>
<
asp:LinkButton
ID
=
"UpdateButton"
runat
=
"server"
CausesValidation
=
"True"
CommandName
=
"Update"
Text
=
"Update"
/>
<
asp:LinkButton
ID
=
"UpdateCancelButton"
runat
=
"server"
CausesValidation
=
"False"
CommandName
=
"Cancel"
Text
=
"Cancel"
/>
</
EditItemTemplate
>
<
EditRowStyle
BackColor
=
"#00FFCC"
/>
<
FooterStyle
BackColor
=
"#507CD1"
Font-Bold
=
"True"
ForeColor
=
"White"
/>
<
HeaderStyle
BackColor
=
"#507CD1"
Font-Bold
=
"True"
ForeColor
=
"White"
/>
<
InsertItemTemplate
>
ContactServiceID:
<
asp:TextBox
ID
=
"ContactServiceIDTextBox"
runat
=
"server"
Text='<%# Bind("ContactServiceID") %>' />
<
br
/>
FirstName:
<
asp:TextBox
ID
=
"FirstNameTextBox"
runat
=
"server"
Text='<%# Bind("FirstName") %>' />
<
br
/>
MiddleName:
<
asp:TextBox
ID
=
"MiddleNameTextBox"
runat
=
"server"
Text='<%# Bind("MiddleName") %>' />
<
br
/>
LastName:
<
asp:TextBox
ID
=
"LastNameTextBox"
runat
=
"server"
Text='<%# Bind("LastName") %>' />
<
br
/>
Prefix:
<
asp:TextBox
ID
=
"PrefixTextBox"
runat
=
"server"
Text='<%# Bind("Prefix") %>' />
<
br
/>
Suffix:
<
asp:TextBox
ID
=
"SuffixTextBox"
runat
=
"server"
Text='<%# Bind("Suffix") %>' />
<
br
/>
WorkAddressCity:
<
asp:TextBox
ID
=
"WorkAddressCityTextBox"
runat
=
"server"
Text='<%# Bind("WorkAddressCity") %>' />
<
br
/>
WorkAddressCountry:
<
asp:TextBox
ID
=
"WorkAddressCountryTextBox"
runat
=
"server"
Text='<%# Bind("WorkAddressCountry") %>' />
<
br
/>
WorkAddressPOB:
<
asp:TextBox
ID
=
"WorkAddressPOBTextBox"
runat
=
"server"
Text='<%# Bind("WorkAddressPOB") %>' />
<
br
/>
WorkAddressZip:
<
asp:TextBox
ID
=
"WorkAddressZipTextBox"
runat
=
"server"
Text='<%# Bind("WorkAddressZip") %>' />
<
br
/>
WorkAddressState:
<
asp:TextBox
ID
=
"WorkAddressStateTextBox"
runat
=
"server"
Text='<%# Bind("WorkAddressState") %>' />
<
br
/>
WorkAddressStreet:
<
asp:TextBox
ID
=
"WorkAddressStreetTextBox"
runat
=
"server"
Text='<%# Bind("WorkAddressStreet") %>' />
<
br
/>
HomeAddressCity:
<
asp:TextBox
ID
=
"HomeAddressCityTextBox"
runat
=
"server"
Text='<%# Bind("HomeAddressCity") %>' />
<
br
/>
HomeAddressCountry:
<
asp:TextBox
ID
=
"HomeAddressCountryTextBox"
runat
=
"server"
Text='<%# Bind("HomeAddressCountry") %>' />
<
br
/>
HomeAddressPOB:
<
asp:TextBox
ID
=
"HomeAddressPOBTextBox"
runat
=
"server"
Text='<%# Bind("HomeAddressPOB") %>' />
<
br
/>
HomeAddressZip:
<
asp:TextBox
ID
=
"HomeAddressZipTextBox"
runat
=
"server"
Text='<%# Bind("HomeAddressZip") %>' />
<
br
/>
HomeAddressState:
<
asp:TextBox
ID
=
"HomeAddressStateTextBox"
runat
=
"server"
Text='<%# Bind("HomeAddressState") %>' />
<
br
/>
HomeAddressStreet:
<
asp:TextBox
ID
=
"HomeAddressStreetTextBox"
runat
=
"server"
Text='<%# Bind("HomeAddressStreet") %>' />
<
br
/>
OtherAddressCity:
<
asp:TextBox
ID
=
"OtherAddressCityTextBox"
runat
=
"server"
Text='<%# Bind("OtherAddressCity") %>' />
<
br
/>
OtherAddressCountry:
<
asp:TextBox
ID
=
"OtherAddressCountryTextBox"
runat
=
"server"
Text='<%# Bind("OtherAddressCountry") %>' />
<
br
/>
OtherAddressPOB:
<
asp:TextBox
ID
=
"OtherAddressPOBTextBox"
runat
=
"server"
Text='<%# Bind("OtherAddressPOB") %>' />
<
br
/>
OtherAddressZip:
<
asp:TextBox
ID
=
"OtherAddressZipTextBox"
runat
=
"server"
Text='<%# Bind("OtherAddressZip") %>' />
<
br
/>
OtherAddressState:
<
asp:TextBox
ID
=
"OtherAddressStateTextBox"
runat
=
"server"
Text='<%# Bind("OtherAddressState") %>' />
<
br
/>
OtherAddressStreet:
<
asp:TextBox
ID
=
"OtherAddressStreetTextBox"
runat
=
"server"
Text='<%# Bind("OtherAddressStreet") %>' />
<
br
/>
PhoneNum1:
<
asp:TextBox
ID
=
"PhoneNum1TextBox"
runat
=
"server"
Text='<%# Bind("PhoneNum1") %>' />
<
br
/>
BusinessPhone2:
<
asp:TextBox
ID
=
"BusinessPhone2TextBox"
runat
=
"server"
Text='<%# Bind("BusinessPhone2") %>' />
<
br
/>
CallbackNum:
<
asp:TextBox
ID
=
"CallbackNumTextBox"
runat
=
"server"
Text='<%# Bind("CallbackNum") %>' />
<
br
/>
PhoneNum4:
<
asp:TextBox
ID
=
"PhoneNum4TextBox"
runat
=
"server"
Text='<%# Bind("PhoneNum4") %>' />
<
br
/>
ISDNNum:
<
asp:TextBox
ID
=
"ISDNNumTextBox"
runat
=
"server"
Text='<%# Bind("ISDNNum") %>' />
<
br
/>
PhoneNum5:
<
asp:TextBox
ID
=
"PhoneNum5TextBox"
runat
=
"server"
Text='<%# Bind("PhoneNum5") %>' />
<
br
/>
PrimaryPhoneNum:
<
asp:TextBox
ID
=
"PrimaryPhoneNumTextBox"
runat
=
"server"
Text='<%# Bind("PrimaryPhoneNum") %>' />
<
br
/>
RadioPhoneNum:
<
asp:TextBox
ID
=
"RadioPhoneNumTextBox"
runat
=
"server"
Text='<%# Bind("RadioPhoneNum") %>' />
<
br
/>
TelexNum:
<
asp:TextBox
ID
=
"TelexNumTextBox"
runat
=
"server"
Text='<%# Bind("TelexNum") %>' />
<
br
/>
PhoneNum6:
<
asp:TextBox
ID
=
"PhoneNum6TextBox"
runat
=
"server"
Text='<%# Bind("PhoneNum6") %>' />
<
br
/>
DisplaySelectors:
<
asp:TextBox
ID
=
"DisplaySelectorsTextBox"
runat
=
"server"
Text='<%# Bind("DisplaySelectors") %>' />
<
br
/>
EmailDisplayAs1:
<
asp:TextBox
ID
=
"EmailDisplayAs1TextBox"
runat
=
"server"
Text='<%# Bind("EmailDisplayAs1") %>' />
<
br
/>
EmailDisplayAs2:
<
asp:TextBox
ID
=
"EmailDisplayAs2TextBox"
runat
=
"server"
Text='<%# Bind("EmailDisplayAs2") %>' />
<
br
/>
EmailDisplayAs3:
<
asp:TextBox
ID
=
"EmailDisplayAs3TextBox"
runat
=
"server"
Text='<%# Bind("EmailDisplayAs3") %>' />
<
br
/>
ContactNotes:
<
asp:TextBox
ID
=
"ContactNotesTextBox"
runat
=
"server"
Text='<%# Bind("ContactNotes") %>' />
<
br
/>
ReferredBy:
<
asp:TextBox
ID
=
"ReferredByTextBox"
runat
=
"server"
Text='<%# Bind("ReferredBy") %>' />
<
br
/>
LeadSource:
<
asp:TextBox
ID
=
"LeadSourceTextBox"
runat
=
"server"
Text='<%# Bind("LeadSource") %>' />
<
br
/>
PrefContactMethod:
<
asp:TextBox
ID
=
"PrefContactMethodTextBox"
runat
=
"server"
Text='<%# Bind("PrefContactMethod") %>' />
<
br
/>
DoNotCall:
<
asp:CheckBox
ID
=
"DoNotCallCheckBox"
runat
=
"server"
Checked='<%# Bind("DoNotCall") %>' />
<
br
/>
DoNotEmail:
<
asp:CheckBox
ID
=
"DoNotEmailCheckBox"
runat
=
"server"
Checked='<%# Bind("DoNotEmail") %>' />
<
br
/>
DoNotFax:
<
asp:CheckBox
ID
=
"DoNotFaxCheckBox"
runat
=
"server"
Checked='<%# Bind("DoNotFax") %>' />
<
br
/>
DoNotSendLetter:
<
asp:CheckBox
ID
=
"DoNotSendLetterCheckBox"
runat
=
"server"
Checked='<%# Bind("DoNotSendLetter") %>' />
<
br
/>
AreaOfInterest:
<
asp:TextBox
ID
=
"AreaOfInterestTextBox"
runat
=
"server"
Text='<%# Bind("AreaOfInterest") %>' />
<
br
/>
Profession:
<
asp:TextBox
ID
=
"ProfessionTextBox"
runat
=
"server"
Text='<%# Bind("Profession") %>' />
<
br
/>
ManagerName:
<
asp:TextBox
ID
=
"ManagerNameTextBox"
runat
=
"server"
Text='<%# Bind("ManagerName") %>' />
<
br
/>
AssistantName:
<
asp:TextBox
ID
=
"AssistantNameTextBox"
runat
=
"server"
Text='<%# Bind("AssistantName") %>' />
<
br
/>
Birthday:
<
asp:TextBox
ID
=
"BirthdayTextBox"
runat
=
"server"
Text='<%# Bind("Birthday") %>' />
<
br
/>
WeddingAnniversary:
<
asp:TextBox
ID
=
"WeddingAnniversaryTextBox"
runat
=
"server"
Text='<%# Bind("WeddingAnniversary") %>' />
<
br
/>
HomeAddress:
<
asp:TextBox
ID
=
"HomeAddressTextBox"
runat
=
"server"
Text='<%# Bind("HomeAddress") %>' />
<
br
/>
OtherAddress:
<
asp:TextBox
ID
=
"OtherAddressTextBox"
runat
=
"server"
Text='<%# Bind("OtherAddress") %>' />
<
br
/>
EmailListType:
<
asp:TextBox
ID
=
"EmailListTypeTextBox"
runat
=
"server"
Text='<%# Bind("EmailListType") %>' />
<
br
/>
AddressBookEmailAddress1:
<
asp:TextBox
ID
=
"AddressBookEmailAddress1TextBox"
runat
=
"server"
Text='<%# Bind("AddressBookEmailAddress1") %>' />
<
br
/>
AddressBookEmailAddress2:
<
asp:TextBox
ID
=
"AddressBookEmailAddress2TextBox"
runat
=
"server"
Text='<%# Bind("AddressBookEmailAddress2") %>' />
<
br
/>
AddressBookEmailAddress3:
<
asp:TextBox
ID
=
"AddressBookEmailAddress3TextBox"
runat
=
"server"
Text='<%# Bind("AddressBookEmailAddress3") %>' />
<
br
/>
AddressBookEmailAddress4:
<
asp:TextBox
ID
=
"AddressBookEmailAddress4TextBox"
runat
=
"server"
Text='<%# Bind("AddressBookEmailAddress4") %>' />
<
br
/>
AddressBookEmailAddress5:
<
asp:TextBox
ID
=
"AddressBookEmailAddress5TextBox"
runat
=
"server"
Text='<%# Bind("AddressBookEmailAddress5") %>' />
<
br
/>
AddressBookEmailAddress6:
<
asp:TextBox
ID
=
"AddressBookEmailAddress6TextBox"
runat
=
"server"
Text='<%# Bind("AddressBookEmailAddress6") %>' />
<
br
/>
EmailAddressType1:
<
asp:TextBox
ID
=
"EmailAddressType1TextBox"
runat
=
"server"
Text='<%# Bind("EmailAddressType1") %>' />
<
br
/>
EmailAddressType2:
<
asp:TextBox
ID
=
"EmailAddressType2TextBox"
runat
=
"server"
Text='<%# Bind("EmailAddressType2") %>' />
<
br
/>
EmailAddressType3:
<
asp:TextBox
ID
=
"EmailAddressType3TextBox"
runat
=
"server"
Text='<%# Bind("EmailAddressType3") %>' />
<
br
/>
EmailAddressType4:
<
asp:TextBox
ID
=
"EmailAddressType4TextBox"
runat
=
"server"
Text='<%# Bind("EmailAddressType4") %>' />
<
br
/>
EmailAddressType5:
<
asp:TextBox
ID
=
"EmailAddressType5TextBox"
runat
=
"server"
Text='<%# Bind("EmailAddressType5") %>' />
<
br
/>
EmailAddressType6:
<
asp:TextBox
ID
=
"EmailAddressType6TextBox"
runat
=
"server"
Text='<%# Bind("EmailAddressType6") %>' />
<
br
/>
AddressBookEntryId1:
<
asp:TextBox
ID
=
"AddressBookEntryId1TextBox"
runat
=
"server"
Text='<%# Bind("AddressBookEntryId1") %>' />
<
br
/>
AddressBookEntryId2:
<
asp:TextBox
ID
=
"AddressBookEntryId2TextBox"
runat
=
"server"
Text='<%# Bind("AddressBookEntryId2") %>' />
<
br
/>
AddressBookEntryId3:
<
asp:TextBox
ID
=
"AddressBookEntryId3TextBox"
runat
=
"server"
Text='<%# Bind("AddressBookEntryId3") %>' />
<
br
/>
AddressBookEntryId4:
<
asp:TextBox
ID
=
"AddressBookEntryId4TextBox"
runat
=
"server"
Text='<%# Bind("AddressBookEntryId4") %>' />
<
br
/>
AddressBookEntryId5:
<
asp:TextBox
ID
=
"AddressBookEntryId5TextBox"
runat
=
"server"
Text='<%# Bind("AddressBookEntryId5") %>' />
<
br
/>
AddressBookEntryId6:
<
asp:TextBox
ID
=
"AddressBookEntryId6TextBox"
runat
=
"server"
Text='<%# Bind("AddressBookEntryId6") %>' />
<
br
/>
MessageDeliveryTime:
<
asp:TextBox
ID
=
"MessageDeliveryTimeTextBox"
runat
=
"server"
Text='<%# Bind("MessageDeliveryTime") %>' />
<
br
/>
CustomerID:
<
asp:TextBox
ID
=
"CustomerIDTextBox"
runat
=
"server"
Text='<%# Bind("CustomerID") %>' />
<
br
/>
PostalAddressStreet:
<
asp:TextBox
ID
=
"PostalAddressStreetTextBox"
runat
=
"server"
Text='<%# Bind("PostalAddressStreet") %>' />
<
br
/>
PostalAddressCity:
<
asp:TextBox
ID
=
"PostalAddressCityTextBox"
runat
=
"server"
Text='<%# Bind("PostalAddressCity") %>' />
<
br
/>
PostalAddressState:
<
asp:TextBox
ID
=
"PostalAddressStateTextBox"
runat
=
"server"
Text='<%# Bind("PostalAddressState") %>' />
<
br
/>
PostalAddressCountry:
<
asp:TextBox
ID
=
"PostalAddressCountryTextBox"
runat
=
"server"
Text='<%# Bind("PostalAddressCountry") %>' />
<
br
/>
PostalAddressPOB:
<
asp:TextBox
ID
=
"PostalAddressPOBTextBox"
runat
=
"server"
Text='<%# Bind("PostalAddressPOB") %>' />
<
br
/>
AssignedTo:
<
asp:TextBox
ID
=
"AssignedToTextBox"
runat
=
"server"
Text='<%# Bind("AssignedTo") %>' />
<
br
/>
IMAddress:
<
asp:TextBox
ID
=
"IMAddressTextBox"
runat
=
"server"
Text='<%# Bind("IMAddress") %>' />
<
br
/>
OfficeLocation:
<
asp:TextBox
ID
=
"OfficeLocationTextBox"
runat
=
"server"
Text='<%# Bind("OfficeLocation") %>' />
<
br
/>
Nickname:
<
asp:TextBox
ID
=
"NicknameTextBox"
runat
=
"server"
Text='<%# Bind("Nickname") %>' />
<
br
/>
Children:
<
asp:TextBox
ID
=
"ChildrenTextBox"
runat
=
"server"
Text='<%# Bind("Children") %>' />
<
br
/>
Hobby:
<
asp:TextBox
ID
=
"HobbyTextBox"
runat
=
"server"
Text='<%# Bind("Hobby") %>' />
<
br
/>
Spouse:
<
asp:TextBox
ID
=
"SpouseTextBox"
runat
=
"server"
Text='<%# Bind("Spouse") %>' />
<
br
/>
ReferredEntryId:
<
asp:TextBox
ID
=
"ReferredEntryIdTextBox"
runat
=
"server"
Text='<%# Bind("ReferredEntryId") %>' />
<
br
/>
CompressedRichText:
<
asp:TextBox
ID
=
"CompressedRichTextTextBox"
runat
=
"server"
Text='<%# Bind("CompressedRichText") %>' />
<
br
/>
User1:
<
asp:TextBox
ID
=
"User1TextBox"
runat
=
"server"
Text='<%# Bind("User1") %>' />
<
br
/>
User2:
<
asp:TextBox
ID
=
"User2TextBox"
runat
=
"server"
Text='<%# Bind("User2") %>' />
<
br
/>
User3:
<
asp:TextBox
ID
=
"User3TextBox"
runat
=
"server"
Text='<%# Bind("User3") %>' />
<
br
/>
User4:
<
asp:TextBox
ID
=
"User4TextBox"
runat
=
"server"
Text='<%# Bind("User4") %>' />
<
br
/>
PercentComplete:
<
asp:TextBox
ID
=
"PercentCompleteTextBox"
runat
=
"server"
Text='<%# Bind("PercentComplete") %>' />
<
br
/>
YomiFirstName:
<
asp:TextBox
ID
=
"YomiFirstNameTextBox"
runat
=
"server"
Text='<%# Bind("YomiFirstName") %>' />
<
br
/>
YomiLastName:
<
asp:TextBox
ID
=
"YomiLastNameTextBox"
runat
=
"server"
Text='<%# Bind("YomiLastName") %>' />
<
br
/>
YomiCompanyName:
<
asp:TextBox
ID
=
"YomiCompanyNameTextBox"
runat
=
"server"
Text='<%# Bind("YomiCompanyName") %>' />
<
br
/>
Territory:
<
asp:TextBox
ID
=
"TerritoryTextBox"
runat
=
"server"
Text='<%# Bind("Territory") %>' />
<
br
/>
TypeOfEntity:
<
asp:TextBox
ID
=
"TypeOfEntityTextBox"
runat
=
"server"
Text='<%# Bind("TypeOfEntity") %>' />
<
br
/>
AccountNumber:
<
asp:TextBox
ID
=
"AccountNumberTextBox"
runat
=
"server"
Text='<%# Bind("AccountNumber") %>' />
<
br
/>
Revenue:
<
asp:TextBox
ID
=
"RevenueTextBox"
runat
=
"server"
Text='<%# Bind("Revenue") %>' />
<
br
/>
TickerSymbol:
<
asp:TextBox
ID
=
"TickerSymbolTextBox"
runat
=
"server"
Text='<%# Bind("TickerSymbol") %>' />
<
br
/>
Employees:
<
asp:TextBox
ID
=
"EmployeesTextBox"
runat
=
"server"
Text='<%# Bind("Employees") %>' />
<
br
/>
YomiAccountName:
<
asp:TextBox
ID
=
"YomiAccountNameTextBox"
runat
=
"server"
Text='<%# Bind("YomiAccountName") %>' />
<
br
/>
OpportunityType:
<
asp:TextBox
ID
=
"OpportunityTypeTextBox"
runat
=
"server"
Text='<%# Bind("OpportunityType") %>' />
<
br
/>
Probability:
<
asp:TextBox
ID
=
"ProbabilityTextBox"
runat
=
"server"
Text='<%# Bind("Probability") %>' />
<
br
/>
OpportunityStage:
<
asp:TextBox
ID
=
"OpportunityStageTextBox"
runat
=
"server"
Text='<%# Bind("OpportunityStage") %>' />
<
br
/>
OpportunityStatus:
<
asp:TextBox
ID
=
"OpportunityStatusTextBox"
runat
=
"server"
Text='<%# Bind("OpportunityStatus") %>' />
<
br
/>
OpportunityCloseDate:
<
asp:TextBox
ID
=
"OpportunityCloseDateTextBox"
runat
=
"server"
Text='<%# Bind("OpportunityCloseDate") %>' />
<
br
/>
Competition:
<
asp:TextBox
ID
=
"CompetitionTextBox"
runat
=
"server"
Text='<%# Bind("Competition") %>' />
<
br
/>
PaymentTerms:
<
asp:TextBox
ID
=
"PaymentTermsTextBox"
runat
=
"server"
Text='<%# Bind("PaymentTerms") %>' />
<
br
/>
ExpirationDate:
<
asp:TextBox
ID
=
"ExpirationDateTextBox"
runat
=
"server"
Text='<%# Bind("ExpirationDate") %>' />
<
br
/>
DeliveryDate:
<
asp:TextBox
ID
=
"DeliveryDateTextBox"
runat
=
"server"
Text='<%# Bind("DeliveryDate") %>' />
<
br
/>
ProjectStartDate:
<
asp:TextBox
ID
=
"ProjectStartDateTextBox"
runat
=
"server"
Text='<%# Bind("ProjectStartDate") %>' />
<
br
/>
ProjectDueDate:
<
asp:TextBox
ID
=
"ProjectDueDateTextBox"
runat
=
"server"
Text='<%# Bind("ProjectDueDate") %>' />
<
br
/>
Priority:
<
asp:TextBox
ID
=
"PriorityTextBox"
runat
=
"server"
Text='<%# Bind("Priority") %>' />
<
br
/>
ProjectStatus:
<
asp:TextBox
ID
=
"ProjectStatusTextBox"
runat
=
"server"
Text='<%# Bind("ProjectStatus") %>' />
<
br
/>
ProjectType:
<
asp:TextBox
ID
=
"ProjectTypeTextBox"
runat
=
"server"
Text='<%# Bind("ProjectType") %>' />
<
br
/>
<
asp:LinkButton
ID
=
"InsertButton"
runat
=
"server"
CausesValidation
=
"True"
CommandName
=
"Insert"
Text
=
"Insert"
/>
<
asp:LinkButton
ID
=
"InsertCancelButton"
runat
=
"server"
CausesValidation
=
"False"
CommandName
=
"Cancel"
Text
=
"Cancel"
/>
</
InsertItemTemplate
>
<
ItemTemplate
>
<
table
class
=
"auto-style1"
>
<
tr
>
<
td
class
=
"auto-style9"
>Contact Service ID</
td
>
<
td
class
=
"auto-style10"
>
<
asp:Label
ID
=
"ContactServiceIDLabel"
runat
=
"server"
Text='<%# Eval("ContactServiceID") %>' />
</
td
>
<
td
class
=
"auto-style11"
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style5"
>First Name</
td
>
<
td
class
=
"auto-style7"
>
<
asp:Label
ID
=
"FirstNameLabel"
runat
=
"server"
Text='<%# Bind("FirstName") %>' />
</
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style5"
>Middle Name</
td
>
<
td
class
=
"auto-style7"
>
<
asp:Label
ID
=
"MiddleNameLabel"
runat
=
"server"
Text='<%# Bind("MiddleName") %>' />
</
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style5"
>Last Name</
td
>
<
td
class
=
"auto-style7"
>
<
asp:Label
ID
=
"LastNameLabel"
runat
=
"server"
Text='<%# Bind("LastName") %>' />
</
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style5"
>Prefix</
td
>
<
td
class
=
"auto-style7"
>
<
asp:Label
ID
=
"PrefixLabel"
runat
=
"server"
Text='<%# Bind("Prefix") %>' />
</
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style6"
>Suffix</
td
>
<
td
class
=
"auto-style8"
>
<
asp:Label
ID
=
"SuffixLabel"
runat
=
"server"
Text='<%# Bind("Suffix") %>' />
</
td
>
<
td
class
=
"auto-style2"
></
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style5"
>WorkAddressCity</
td
>
<
td
class
=
"auto-style7"
>
<
asp:Label
ID
=
"WorkAddressCityLabel"
runat
=
"server"
Text='<%# Bind("WorkAddressCity") %>' />
</
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style6"
>[WorkAddressStreet]</
td
>
<
td
class
=
"auto-style8"
>
<
asp:Label
ID
=
"WorkAddressStreetLabel"
runat
=
"server"
Text='<%# Bind("WorkAddressStreet") %>' />
</
td
>
<
td
class
=
"auto-style2"
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style5"
>[WorkAddressPOB]</
td
>
<
td
class
=
"auto-style7"
>
<
asp:Label
ID
=
"WorkAddressPOBLabel"
runat
=
"server"
Text='<%# Bind("WorkAddressPOB") %>' />
</
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style5"
>[WorkAddressZip]</
td
>
<
td
class
=
"auto-style7"
>
<
asp:Label
ID
=
"WorkAddressZipLabel"
runat
=
"server"
Text='<%# Bind("WorkAddressZip") %>' />
</
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style5"
>[WorkAddressState]</
td
>
<
td
class
=
"auto-style7"
>
<
asp:Label
ID
=
"WorkAddressStateLabel"
runat
=
"server"
Text='<%# Bind("WorkAddressState") %>' />
</
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style5"
> </
td
>
<
td
class
=
"auto-style7"
> </
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
>[PostalAddressStreet]</
td
>
<
td
class
=
"auto-style7"
>
<
asp:Label
ID
=
"PostalAddressStreetLabel"
runat
=
"server"
Text='<%# Bind("PostalAddressStreet") %>' />
</
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style2"
>[PostalAddressCity]</
td
>
<
td
class
=
"auto-style7"
>
<
asp:Label
ID
=
"PostalAddressCityLabel"
runat
=
"server"
Text='<%# Bind("PostalAddressCity") %>' />
</
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
>[PostalAddressState]</
td
>
<
td
class
=
"auto-style7"
>
<
asp:Label
ID
=
"PostalAddressStateLabel"
runat
=
"server"
Text='<%# Bind("PostalAddressState") %>' />
</
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
>[PostalAddressPOB]</
td
>
<
td
class
=
"auto-style7"
>
<
asp:Label
ID
=
"PostalAddressPOBLabel"
runat
=
"server"
Text='<%# Bind("PostalAddressPOB") %>' />
</
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style5"
> </
td
>
<
td
class
=
"auto-style7"
> </
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style5"
>PhoneNum1:</
td
>
<
td
class
=
"auto-style7"
>
<
asp:Label
ID
=
"PhoneNum1Label"
runat
=
"server"
Text='<%# Bind("PhoneNum1") %>' />
</
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style5"
>BusinessPhone2</
td
>
<
td
class
=
"auto-style7"
>
<
asp:Label
ID
=
"BusinessPhone2Label"
runat
=
"server"
Text='<%# Bind("BusinessPhone2") %>' />
</
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style5"
> </
td
>
<
td
class
=
"auto-style7"
> </
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style5"
>[EmailDisplayAs1]</
td
>
<
td
class
=
"auto-style7"
>
<
asp:Label
ID
=
"EmailDisplayAs1Label"
runat
=
"server"
Text='<%# Bind("EmailDisplayAs1") %>' />
</
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style5"
>[EmailDisplayAs2]</
td
>
<
td
class
=
"auto-style7"
>
<
asp:Label
ID
=
"EmailDisplayAs2Label"
runat
=
"server"
Text='<%# Bind("EmailDisplayAs2") %>' />
</
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style5"
>[ContactNotes]</
td
>
<
td
class
=
"auto-style7"
>
<
asp:Label
ID
=
"ContactNotesLabel"
runat
=
"server"
Text='<%# Bind("ContactNotes") %>' />
</
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style5"
>[AddressBookEmailAddress1]</
td
>
<
td
class
=
"auto-style7"
>
<
asp:Label
ID
=
"AddressBookEmailAddress1Label"
runat
=
"server"
Text='<%# Bind("AddressBookEmailAddress1") %>' />
</
td
>
<
td
> </
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style5"
>[AddressBookEmailAddress2]</
td
>
<
td
class
=
"auto-style7"
>
<
asp:Label
ID
=
"AddressBookEmailAddress2Label"
runat
=
"server"
Text='<%# Bind("AddressBookEmailAddress2") %>' />
</
td
>
<
td
> </
td
>
</
tr
>
</
table
>
<
br
/>
<
asp:LinkButton
ID
=
"EditButton"
runat
=
"server"
CausesValidation
=
"False"
CommandName
=
"Edit"
Text
=
"Edit"
/>
</
ItemTemplate
>
<
PagerStyle
BackColor
=
"#2461BF"
ForeColor
=
"White"
HorizontalAlign
=
"Center"
/>
<
RowStyle
BackColor
=
"#EFF3FB"
/>
</
asp:FormView
>
</
td
>
<
td
style
=
"vertical-align: top;"
class
=
"auto-style13"
>
<
telerik:RadGrid
ID
=
"RadGrid1"
runat
=
"server"
DataSourceID
=
"SqlDataSource2"
style
=
"margin-left: 0px"
Width
=
"276px"
AllowMultiRowSelection
=
"True"
>
<
ClientSettings
>
<
Selecting
AllowRowSelect
=
"True"
/>
</
ClientSettings
>
<
MasterTableView
datakeynames
=
"ContactServiceID,CategoryName"
AutoGenerateColumns
=
"False"
DataSourceID
=
"SqlDataSource2"
>
<
Columns
>
<
telerik:GridClientSelectColumn
FilterControlAltText
=
"Filter CATSELECTION column"
UniqueName
=
"CATSELECTION"
>
</
telerik:GridClientSelectColumn
>
<
telerik:GridBoundColumn
DataField
=
"CategoryName"
FilterControlAltText
=
"Filter CategoryName column"
HeaderText
=
"CategoryName"
SortExpression
=
"CategoryName"
UniqueName
=
"CategoryName"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"ContactServiceID"
FilterControlAltText
=
"Filter column column"
HeaderText
=
"ContactServiceID"
SortExpression
=
"ContactServiceID"
UniqueName
=
"column"
Visible
=
"False"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
/>
</
ColumnValidationSettings
>
</
telerik:GridBoundColumn
>
</
Columns
>
</
MasterTableView
>
</
telerik:RadGrid
>
</
td
>
</
tr
>
<
tr
>
<
td
class
=
"auto-style14"
> xx</
td
>
<
td
class
=
"auto-style13"
> xx</
td
>
</
tr
>
</
table
>
</
form
>
</
body
>
</
html
>