GridView, ObjectDataSource Delete virker ikke
Tror jeg har set mig blind på det her. Håber nogen kan se hvorfor min UpdateUser funktion virker, men ikke min DeleteUser. Den kommer rigtigt ind i metoden, men den får ikke korrekt User objektet med. Det undrer mig for det virker fint i UpdateUser metoden.Tryk på Delete udskriver:
"er i delete nu...ID=0"
Tryk på Update udskriver:
"er i update nu...ID=5"
public static int DeleteUser(User u)
{
HttpContext.Current.Response.Write("er i delete nu...ID="+u.UserId);
MySqlCommand cmd = new MySqlCommand("DeleteUser",
new MySqlConnection(GetConnectionString()));
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("uid", u.UserId));
cmd.Connection.Open();
int i = cmd.ExecuteNonQuery();
cmd.Connection.Close();
return i;
}
public static int UpdateUser(User u)
{
HttpContext.Current.Response.Write("er i update nu...ID=" + u.UserId);
MySqlCommand cmd = new MySqlCommand("UpdateUser",
new MySqlConnection(GetConnectionString()));
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("uid", u.UserId));
cmd.Parameters.Add(new MySqlParameter("uname", u.Username));
cmd.Parameters.Add(new MySqlParameter("eml", u.Email));
cmd.Connection.Open();
int i = cmd.ExecuteNonQuery();
cmd.Connection.Close();
return i;
}
<asp:ObjectDataSource ID="DataDataSource" runat="server"
TypeName="Data.UserLogic"
DataObjectTypeName="Data.User"
SelectMethod="GetAllUsers"
UpdateMethod="UpdateUser"
InsertMethod="InsertUser"
DeleteMethod="DeleteUser">
</asp:ObjectDataSource>
<asp:GridView id="DataList" runat="server"
DataSourceID="DataDataSource"
AutoGenerateColumns="False" DataKeyNames="UserId">
<Columns>
<asp:CommandField ShowEditButton="True" ShowSelectButton="True" ShowDeleteButton="True" />
<asp:BoundField DataField="UserId" HeaderText="UserId" SortExpression="UserId" />
<asp:BoundField DataField="Email" HeaderText="Email" SortExpression="Email" />
<asp:BoundField DataField="Username" HeaderText="Username" SortExpression="Username" />
</Columns>
</asp:GridView>
