I need to be able to delete a record/row from a database table. I am using a
DataGrid which is not sending the row index key properly to the event in the
codebehind. When I set a break point and check the values in the Autos
window e.Items.ItemInd ex always returns a 0 so the stored procedure does not
know which record to delete.
Here is the Datagrid markup:
<asp:datagrid id="clubdg" DataKeyField="U serID" runat="server"
GridLines="Vert ical" CellPadding="2"
BorderWidth="1p x" BorderColor="#C CCCFF" CssClass="txt"
AutoGenerateCol umns="False" OnCancelCommand ="Cancel_Cli ck"
OnUpdateCommand ="Update_Cli ck" OnDeleteCommand ="Delete_Cli ck"
OnEditCommand=" Edit_Click">
<SelectedItemSt yle VerticalAlign=" Top"></SelectedItemSty le>
<EditItemStyl e VerticalAlign=" Top"
BackColor="#000 033"></EditItemStyle>
<AlternatingIte mStyle VerticalAlign=" Top"></AlternatingItem Style>
<ItemStyle VerticalAlign=" Top"></ItemStyle>
<HeaderStyle Font-Size="10px" Font-Names="Verdana"
Font-Bold="True" HorizontalAlign ="Center"
VerticalAlign=" Middle" BackColor="#000 044"></HeaderStyle>
<Columns>
<asp:TemplateCo lumn HeaderText="Sta ff Name">
<ItemTemplate >
<%# DataBinder.Eval (Container.Data Item,"UserPrefi x")%>
<%# DataBinder.Eval (Container.Data Item,"UserFName ")%>
<%# DataBinder.Eval (Container.Data Item,"UserLName ")%>
<BR>
Organization
ID: <%#DataBinder.E val(Container.D ataItem,"ClubID ")%>
</ItemTemplate>
<EditItemTempla te>
User Prefix:<BR>
<asp:TextBox id="UserPrefix " Runat="server"> </asp:TextBox><BR >
User First Name:<BR>
<asp:TextBox id="UserFName" Runat="server"> </asp:TextBox><BR >
User Last Name:<BR>
<asp:TextBox id="UserLName" Runat="server"> </asp:TextBox>
</EditItemTemplat e>
</asp:TemplateCol umn>
<asp:TemplateCo lumn HeaderText="Use r Access">
<ItemTemplate >
Email Address:<br>
<%# DataBinder.Eval (Container.Data Item, "UserEmail" )%>
<br>
Password: <%#
DataBinder.Eval (Container.Data Item,"UserPassw ord")%><br>
User Role: <%# DataBinder.Eval (Container.Data Item,
"AccessID")%><b r>
<br>
<br>
Show: <%# DataBinder.Eval (Container.Data Item,"show")%>< br>
Booking: <%#
DataBinder.Eval (Container.Data Item,"Bookings" )%><br>
General: <%#
DataBinder.Eval (Container.Data Item,"General") %><br>
Guest List: <%#
DataBinder.Eval (Container.Data Item,"GuestList ")%>
</ItemTemplate>
<EditItemTempla te>
User Email:<br>
<asp:TextBox ID="UserEmail" Runat="server"> </asp:TextBox><br >
User Password:<br>
<asp:TextBox ID="UserPasswor d"
Runat="server"> </asp:TextBox><br >
User Role:<br>
<asp:DropDownLi st ID="AccessID" Runat="server">
<asp:ListItem Selected="True" >Select Role</asp:ListItem>
<asp:ListItem Value="Admin">A dministrator</asp:ListItem>
<asp:ListItem Value="Promotor ">Promotor</asp:ListItem>
<asp:ListItem Value="General Staff">General
Staff</asp:ListItem>
</asp:DropDownLis t><br>
Show On Contacts:
<asp:CheckBox ID="show" Runat="server"> </asp:CheckBox><b r>
<br>
<table class="txt" cellpadding="0" cellspacing="0"
border="0" width="100%">
<tr>
<td>in:</td>
</tr>
<tr>
<td>Bookings contact List:</td>
<td>
<asp:CheckBox ID="Bookings"
Runat="server"> </asp:CheckBox></td>
</tr>
<tr>
<td>General Information:</td>
<td>
<asp:CheckBox ID="General"
Runat="server"> </asp:CheckBox></td>
</tr>
<tr>
<td>Guest List:</td>
<td>
<asp:CheckBox ID="GuestList"
Runat="server"> </asp:CheckBox></td>
</tr>
</table>
</EditItemTemplat e>
</asp:TemplateCol umn>
<asp:TemplateCo lumn HeaderText="Sta ff Address">
<ItemTemplate >
<%# DataBinder.Eval (Container.Data Item,"UserStree tNumber")%>
<%# DataBinder.Eval (Container.Data Item, "UserAddress")% ><br>
<%# DataBinder.Eval (Container.Data Item,"UserCity" )%>
, <%#
DataBinder.Eval (Container.Data Item,"UserProvi nce")%><br />
<%# DataBinder.Eval (Container.Data Item,"UserPosta l")%>
</ItemTemplate>
<EditItemTempla te>
Street Number:
<asp:TextBox ID="UserStreetN umber" Width="30"
Runat="server"> </asp:TextBox><br >
Street Address:<br>
<asp:TextBox ID="UserAddress "
Runat="server"> </asp:TextBox><br >
City:<br>
<asp:TextBox ID="UserCity" Runat="server"> </asp:TextBox><br >
Province:<br>
<asp:TextBox ID="UserProvinc e"
Runat="server"> </asp:TextBox><br >
Postal Code:<br>
<asp:TextBox ID="UserPostal " Runat="server"> </asp:TextBox>
</EditItemTemplat e>
</asp:TemplateCol umn>
<asp:TemplateCo lumn HeaderText="Con tact Information">
<ItemTemplate >
Phone: <%#
DataBinder.Eval (Container.Data Item,"UserPhone ","{0:###-###-####}")%><br>
Fax: <%#
DataBinder.Eval (Container.Data Item,"UserFax", "{0:###-###-####}")%><br>
Mobile: <%#
DataBinder.Eval (Container.Data Item,"UserMobil e","{0:###-###-####}")%><br>
</ItemTemplate>
<EditItemTempla te>
Phone:<br>
<asp:TextBox ID="UserPhone" Runat="server"> </asp:TextBox><br >
Fax:<br>
<asp:TextBox ID="UserFax" Runat="server"> </asp:TextBox><br >
Mobile:<br>
<asp:TextBox ID="UserMobile " Runat="server"> </asp:TextBox>
</EditItemTemplat e>
</asp:TemplateCol umn>
<asp:EditComman dColumn ButtonType="Lin kButton"
UpdateText="Upd ate" HeaderText="Use r Management" CancelText="Can cel"
EditText="Edit Row"></asp:EditCommand Column>
<asp:ButtonColu mn Text="Delete" HeaderText="Del ete User"
CommandName="De lete"></asp:ButtonColum n>
</Columns>
</asp:datagrid>
Here is the codebehind for the event Delete_Click:
{
clubconn=new SqlConnection(s trclubconn);
clubconn.Open() ;
clubcmd=new SqlCommand(Glob als.UserDelete_ SP,clubconn);
clubcmd.Command Type=CommandTyp e.StoredProcedu re;
clubcmd.Paramet ers.Add(Globals .User_tbl_UserI D_PARM,e.Item.I temIndex);
clubcmd.Execute NonQuery();
BindData();
clubconn.Close( );
}
The Stored procedure in the Class Globals.UserDel ete_SP:
CREATE PROCEDURE dbo.dt_UserDele te
(
@UserID int
)
AS
SET NOCOUNT ON
DELETE
FROM
User_tbl
WHERE
UserID=@UserID
return 0
GO
Globals.User_tb l_UserID_PARM is a referance to a class that returns the
following:
public const string User_tbl_UserID _PARM = "@UserID"
Everything looks fine but the grid is not passing an index value. Anyone
know why this is happening?
