<asp:DetailsView ID="dvInfo" runat="server" DefaultMode=ReadOnly AutoGenerateRows="False"
DataSourceID="dsKeyContact" HeaderText="Review the info and make the necessary change" DataKeyNames="HID"
Width="692px" OnItemUpdated="dvInfo_ItemUpdated" OnDataBound="dvInfo_DataBound" Font-Bold="True" Font-Size="Large">
<asp:DropDownList id="dpBusUnit" runat="server"
DataSourceID="dsBusUnit"
DataTextField="BusUnit" DataValueField="BusUnit"
SelectedValue='
<asp:DropDownList id="dpDept" runat="server"
DataSourceID="dsDept"
DataTextField="Dept" DataValueField="Dept"
SelectedValue='
<asp:CustomValidator ID="ValidPhoneLength" runat="server" ControlToValidate =txtOfficePhone ClientValidationFunction="ValidPhoneLenght"
ErrorMessage="The length of the phone should not more than 10">*
<asp:RegularExpressionValidator ID="vrREmail" runat="server" ErrorMessage="Check the email again. It must contain @" ControlToValidate =txtEmail
ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*">*
"
SelectCommand="SELECT [HName], [Title], [BusUnit], [Department], [OfficePhone], [Mobile], [Pager], [Home], [AlternatePhone], [Email], [LastUpdate], [HID] FROM [KeyContactPhone] WHERE ([HID] = @HID)"
UpdateCommand="UPDATE KeyContactPhone SET Title =@Title, HName =@HName, BusUnit =@BusUnit, Department =@Department, OfficePhone =@OfficePhone, Mobile =@Mobile , Pager =@Pager, Home =@Home, AlternatePhone =@AlternatePhone, Email =@Email WHERE ([HID] = @HID)" ProviderName="
"
SelectCommand="SELECT Dept from Dept order by Dept " ProviderName="
"
SelectCommand="SELECT BusUnit from BusUnit order by BusUnit " ProviderName="
When you open SQL Server's "Server Network Utility" what protocols are enabled? It sounds like you need Named Pipes enabled as that is what your error message is complaining about. I have TCPIP and Named Piples enabled.
The 'remote access is set up as 1 already.
You said that
http://computername/HRHSKeyContact/HRHSKeyContact.aspx
works, but
http://computername/HRHSKeyContact/HRHSKeyContact.aspx?hid=2
doesn't.
What I tried to say is the web server did not have problem to display the web site.
Here is my aspx code. The query string should not be issue. Since
http://localhost/HRHSKeyContact/HRHSKeyContact.aspx?hid=2
will show the result as I expected.