DataSource Controls :: Whole Gridview Was Deleted When Trying To Delete Only 1 Row?
Jan 10, 2011
I am trying to delete a row of records in a gridview. The selectMethod works perfectly fine, but the DeleteMethod doesn't. When I delete a row, only 1 row of records should be deleted, but the whole gridview was deleted! (I have about 3 -5 rows of data). I am using ObjectDataSource.
In a grid view me bind the data .if i click the update it throw the error like this
Server Error in '/bramandam site' Application.
Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
Source Error:
Line 81: TextBox tfn = (TextBox)dv.FindControl("tsn"); Line 82: Label lb = ((Label)dv.FindControl("Label4")); Line 83: string qry = "update section set sectionid='" + tbf.Text; Line 84: qry += "',sectionname='" + tfn.Text; Line 85: qry += "' where pk='" + lb.Text;
[NullReferenceException: Object reference not set to an instance of an object.] Section.GridView1_RowUpdating(Object sender, GridViewUpdateEventArgs e) in d:jquery themesramandam siteSection.aspx.cs:83 System.Web.UI.WebControls.GridView.OnRowUpdating(GridViewUpdateEventArgs e) +133 System.Web.UI.WebControls.GridView.HandleUpdate(GridViewRow row, Int32 rowIndex, Boolean causesValidation) +720
[Code] .....
Version Information: Microsoft .NET Framework Version:2.0.50727.4984; ASP.NET Version:2.0.50727.4971 if i click the update i need to throw the error edit and update the content
when im deleting rows in a grid view only the first row getting deleted i mean if i want to delete the third row the first row is getting deleted instead of third i dnt know y below is my code
I am trying to run a delete command from multiple tables and cant seem to get it to work. When you run the delete it just refreshes the gridview... Below is my delete command and parameters along with the code behind that I run.
DeleteCommand="DELETE FROM RecipeBox, Recipes WHERE (RecipeBox.ID = @RecipeID) or (Recipes.RecipeID = @RecipeID)"> <DeleteParameters> <asp:Parameter Name="RecipeID" />
How can I retrieve information from delete rows. I delete some rows from table in dataset, then I use method GetChanges(DataRowState.Deleted) to get deleted rows. I try delete rows in original table on server side, but it finished with this errors. I try get value of columns from row, which was deleted [Code]....
Iam a newbie in Linq to Sql. I have some problems with my deleting items function. assemble the code together:I must have the following code accumulated.
I have a site that show infomation that are contained in div blocks. The info is taken from a database so the user can change the info or delete it. When the user deletes a div block i want to use jQuery to animate that its disappearing and also that its deleted from the database. How can i do this without doing a postback, i dont want the site to reload, i just want the Div block to disappear visually and be gone from the database at the same time. Would i use Ajax update panel to achieve this ?
I have bounded my GridView to an ObjectDataSource. I have set a delete method for this ObjectDataSource. Now how can I delete my GridView's records with enable Deleting?
I have problem to check "if the file is success deleted".This is the algorithm, if sqldatasource deleted success then ---show message or other action---end if
Notice that I have multiple ItemTemplates. On the first itemTemplate I have an ASP image control showing some image. I would like that when a user clicks on that image the row gets deleted. How can I do that without using the asp:buttoncolumn?Also the same applies for selecting a row, that instead of deleting the row the row gets selected
I'm using the asp.net membership on my website. On the User Administration page i've got a GridView to show the details of the users on the site. As a datasource rather than just using the Membership.GetAllUsers function i've got a SQLDataSource as i need to display user information from 3 different tables. I'm trying to add a delete button to the GridView. I'm setting the Membership's UserName as a DataKey and then using the RowDeleting event to call Membership.DeleteUser for the appropriate UserName. This works fine and the user is deleted however i then get an error showing up that "Deleting is not supported by data source 'SqlDataSource1' unless DeleteCommand is specified."
I don't want to use the SqlDataSource for deleting as i've already done it using the Membership. How can i stop it from trying to do this? Here is the cut-down that i have if you're interested. The selectcommand in the sqldatasource was auto-generated by it.
I have a gridview that pulls data from two tables, CLIENT and PAYMENT. I want to add the edit, delete functions to the gridview for the payment portion of the table, that is to edit or delete the payments but not the client. I've manually enabled the edit, delete functions and input the queries. I've also deleted the textboxes from the templates which draw from the CLIENT table so they cannot be edited. Everything looks good on the surface until I actually go to edit or delete anything, and it has no effect.Here's the structure of the two tables:
UPDATE [PAYMENT] SET [PaymentDate] = @PaymentDate, [PaymentAmount] = @PaymentAmount, [PaymentDetails] = @PaymentDetails WHERE [PaymentNumber] = @original_PaymentNumber AND [CLIENT$ClientID] = @original_CLIENT$ClientID AND [PaymentDate] = @original_PaymentDate AND [PaymentAmount] = @original_PaymentAmount AND (([PaymentDetails] = @original_PaymentDetails) OR ([PaymentDetails] IS NULL AND @original_PaymentDetails IS NULL))
Finally, here's the delete query:
DELETE FROM [PAYMENT] WHERE [PaymentNumber] = @original_PaymentNumber AND [CLIENT$ClientID] = @original_CLIENT$ClientID AND [PaymentDate] = @original_PaymentDate AND [PaymentAmount] = @original_PaymentAmount AND (([PaymentDetails] = @original_PaymentDetails) OR ([PaymentDetails] IS NULL AND @original_PaymentDetails IS NULL))
I have a GridView. One of its columns contains monetary amounts. Underneath the GridView, I have a SqlDataSource which calculates the sum of this column and displays it in a label which is in a DIV called totalsbox (that I have added runat="server" to).
Obviously, if the GridView is empty, I don't want this label to be visible.
In the Page_Load, I have placed the following code:
[Code]....
[Code]....
This works fine. When the Page first loads, if the GridView is empty, the entire DIV is hidden; if not, the DIV is visible and the label displays the column SUM. imagine now the GridView DOES have rows, the DIV is visible and the total is displayed properly in the DIV ("10.00", say).
I have a RowDeleted event handler in the code behind which contains exactly the same code as I put in the Page_Load. As I delete rows, one by one, the sum is recalculated and displayed properly. But, when I delete the final row, I would expect this code to hide the DIV as the GridView is now empty.
This doesn't happen, however, the DIV remains visible and I have, in the label, something like " ".
Why is it that the code works in the Page_Load but not in the RowDeleted event handler?
I have a gridview and which contain checkbox field too.If the checkbox is clicked and then delete button click, relevent record is deleted.This delete function is working properly.
problem Even though record is deleted,it does not affected in gridview.Deleted record is still remaining in the gridview.What will be the way that should I follow solve this problem?
I have wired an event to handle delete command for my GridView. But I cannot determine which the record's unique key, in my case stored in DOCIDNO field. All I get is a row index, such as 0, 1, 2 which obviously cannot be used to accurately delete a record from database.
I am trying to delete a row in the GridView with an ImageButton Link. By clicking the button, the GridView row is set with a backColor = "Red" and with delete confirmation window. On Cancel, the background color is removed, but When I confirm the deletion, the row is not deleted. I use the following code:
The bellow code deletes the row, but the without setting the background color on the row prior
deletion: ImageButton deleteButton = (ImageButton)e.Row.FindControl("deleteImageLink"); deleteButton.OnClientClick = "if (confirm('Are you sure you want to delete this user account?') == false) return false;";
a)i have an gridview, i need to every record show in every rows, but it's show in both column and rows...., how fix this?i use only itemTemplate in this gridview!
b)how i link a field thats show in gridview and pass to a new page(with query string) for show single record....?
(this is like "read more..." link in many news site!!!)
c)in my db is a 'ntext' field,but when that show in Gridview,all enter(Chr13) and whitespace deleted, how fix this?
I have made a call logging application in which i have authorised a normal user to edit update and delete from the gridview.But i want to give the admin person rights to see all the complaints deleted updated edited..i have thought a lot but all in vain havent found.
How do I reference the delete button to add the delete confirmation box when I have both the Edit and Delete buttons as the last two columns in the Gridview control. The following code works fine without any issues when I have the delete button only:
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType != DataControlRowType.DataRow) return; int lastCellIndex = e.Row.Cells.Count - 1; Button db = (Button)e.Row.Cells[lastCellIndex].Controls[0]; db.OnClientClick = "if (!window.confirm('Are you sure you want to delete this record?')) return false;"; }
But, when I have both the Edit and the Delete buttons, I get the following error when I click the edit button while the delete button works fine.
Specified argument was out of the range of valid values. Parameter name: index
How do I reference the delete button so the edit button is not affected in this case?
Using "Enable Delete" from Gridview control, I can delete (besides, update, sort, paging, etc) data from the database (this is done automatically). However, how can I delete the actual image that resides in my image folder (i.e. from "pix" folder )? What is the best way to delete image? If using code behind, how? Please write a full code for me. Here is my source code.
An error occurred during the processing of . System.Web.UI.WebControls.DataControlFieldCollection must have items of type 'System.Web.UI.WebControls.DataControlField'. 'SharePoint:DeleteItemButton' is of type 'Microsoft.SharePoint.WebControls.DeleteItemButton'.
