Hi everyone. I have problem with the buttons Edit and Delete in Gridview for very long time and i really need help about it.
So the when i click edit i get in edit mode and when click update the values in the row i was changing disappear but only in the gridview. When check in the Database nothing happens. The delete button not works at all, i mean when click on it only refresh the table. If see something wrong in my code please help. I'm not sure where the problem is.See how looks my page:
Now here's my code in aspx: <asp:SqlDataSource ID="SqlDataSource7" runat="server"
ConnectionString="<%$ ConnectionStrings:ThisIsMyConnection2 %>"
SelectCommand = "SELECT * FROM [Resident] WHERE (([FNAME] + ' ' + [LNAME] LIKE '%' + @FANDLNAME + '%'))"
DeleteCommand="DELETE FROM [Resident] WHERE [MobileNum] = @original_MobileNum"
UpdateCommand="UPDATE [Resident] SET [FNAME] = @FNAME, [LNAME] = @LNAME, [HomeNum] = @HomeNum, [OfficeNum] = @OfficeNum, [FaxNum] = @FaxNum WHERE [MobileNum] = @original_MobileNum"
View Complete Post