I am really struggling with this, trying to understand why it doesn't work.
I've simplified the code down to the essentials. The GridView displays in
ReadOnly mode just fine, Clicking the "edit" button in the gridview works
just fine, but clicking the "Delete" button gives the error "Must Declare
Scalar Variable @ServerName" yet the code in the UpdateCommand and
DeleteCommand are essentially the same!
I must be missing something basic but I just can't see it, can someone
please point it out?
Mark
<%@ page language="VB" %>
<%@ Import Namespace="Syst em.Data" %>
<%@ Import Namespace="Syst em.Data.SqlClie nt" %>
<html>
<body>
<asp:SqlDataSou rce ID="RWServerInf oDB" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs:RWSqlConnect ionString %>"
SelectCommand=" SELECT * FROM SERVERINFO"
UpdateCommand=" Update SERVERINFO SET
ServerName=@Ser verName,
FacCode=@FacCod e
WHERE ServerName=@Ser verName"
DeleteCommand=" DELETE From SERVERINFO
WHERE ServerName=@Ser verName">
</asp:SqlDataSour ce>
<form runat="server">
<asp:GridView ID="DV" DataSourceID="R WServerInfoDB" runat="server"
AutoGenerateCol umns="False"
AutoGenerateEdi tButton="True"
AutoGenerateDel eteButton="True ">
<columns>
<asp:BoundFie ld DataField="Serv erName" HeaderText="Ser ver Name"/>
<asp:BoundFie ld DataField="FacC ode" HeaderText="Fac ility Code" />
</columns>
</asp:GridView>
</form>
</body>
</html>
