Forms Data Controls :: Configure Delete In Gridview?
Feb 20, 2010i want delete one row of my gridview,but before delete it, ask if i sure to delete that record or not.
how can i write a configure delete code for my grid view
i want delete one row of my gridview,but before delete it, ask if i sure to delete that record or not.
how can i write a configure delete code for my grid view
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.
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="photoID"
I am using Sharepoint Designer and trying to insert a Delete button into a gridview. I added this to the top of my ASPX:
<%@ Register Tagprefix="SharePoint" Namespace="Microsoft.SharePoint.WebControls"
Assembly="Microsoft.SharePoint, Version=11.0.0.0, Culture=neutral,
PublicKeyToken=71e9bce111e9429c" %>
and I added this as a Gridview column:
<SharePoint:DeleteItemButton
runat="server"
ID="CustomFormDeleteItemButton"
ControlMode="Edit"
/>
and this is the error I get:
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'.
A very simple question.
I am trying to delete a row from a Gridview but getting error in my Gridview1_Rowdeleting method on the line Gridview1.DataKeys(e.RowIndex).Value;
Error: Method, delegate or event is expected. Here is my Gridview
<asp:GridView ID="GridView1" runat="server" OnRowDeleting="Gridview1_Rowdeleting" DataKeyNames="RecAdvId">
<asp:buttonfield headertext="Delete" commandname="delete" datatextfield="MessageId" />
<asp:BoundField DataField="RecAdvId" HeaderText="RecAdvId" Visible="false" SortExpression="PanelId"
HeaderStyle-HorizontalAlign="Left">
</asp:BoundField>
<asp:BoundField DataField="Advert" HeaderText="Advert" HeaderStyle-HorizontalAlign="Left">
<HeaderStyle HorizontalAlign="Left" />
</asp:BoundField>
</asp:GridView>
Here is my code behind method which gives error:
protected void Gridview1_Rowdeleting(object sender, GridViewDeleteEventArgs e)
{
int x = _Gridview1.DataKeys(e.RowIndex).Value; //Error: Method, delegate or event is expected.
}
Try to delete a row in a gridview and get this error:
Parameter '@ID' must be defined.
Have tested the sql command in the query builder. I use Mysql and c#.
Here are the code:
<asp:GridView ID="GridView1" AutoGenerateEditButton="true"
AutoGenerateDeleteButton="true" runat="server" DataSourceID="MySqlDataSource1"
Width="350px">
</asp:GridView>
<asp:SqlDataSource ID="MySqlDataSource1"
ConnectionString="<%$ ConnectionStrings:processdbConnectionString %>"
ProviderName="<%$ ConnectionStrings:processdbConnectionString.ProviderName %>"
SelectCommand="SELECT * FROM computers"
UpdateCommand="UPDATE computers SET Priority=@Priority WHERE ID=@id"
DeleteCommand="DELETE computers WHERE ID=@ID"
runat="server">
I have an empty gridview with imagebutton,fileupload control,upload and delete buttons. I have uploaded one image to imagebutton through upload button. How to delete that row from the gridview.
I am using this code to delete a row
protected void grdImages_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
int deleteRowIndex = int.Parse(e.CommandArgument.ToString()); // Here i am getting the rowindex
if (grdrow.RowIndex == deleteRowIndex)
{
grdImages.DeleteRow(deleteRowIndex);
grdImages.DataBind();
}
}
}
Its not deleting the row. What could be the problem??
I have a gridview control on my page that lists records and sorts them according to the most recent to the oldest record. The most recent record is first record at index 0, and I want the users to be able to only delete the first record in Gridview. Is this at all possible? I'd like there to be the word 'Delete' next to the first record only.
View 4 RepliesI have a gridview on my page which is bound to an objectdatasource that gets Data from an Images Table in my database.The delete button is enabled and I have this code in my DAL.ELETE FROM [Images] WHERE (([ImageId] = @ImageId))Instead of deleting just 1 image, I want to give a user the option to delete multiple images at once.
View 10 Replieshow to delete a row only from gridview not the database?
View 4 Repliesiam insert data through gridview using datable, and i have 2button , insert and delete button , i wants to delete a row from the gridview using delete button below the code i constructed for insert, how to delete the row.
protected void Button2_Click(object sender, EventArgs e)
{
//delete button
} [code].....
When you push Gridview delete button, I want to alarm "do you want to delete register" . I searched in the internet and I wrote the code like that.
<asp:TemplateField>
<ItemTemplate>
<asp:LinkButton ID="lnkbtndelete"
CommandName="Delete" runat="server">
[code]...
I added a Gridview to my page and added a new item a delete button, now when i push that button there is an error... Do I need to add some code for it? And yes, can you give an example?
View 3 RepliesI have a gridview control in a webform which is shown below:
[Code]....
The desire is to remove a row both from the gridview and from the backend SQL Database table. So far I have written the following code:
[Code]....
The comments shown in the else clause of the if-else indicate the code that
I have several "standard" GridViews in the "admin" side of a web site I am developing. In the past, none of these have ever shown any problems with a standard Delete.
To review: Each of the subject tables has a "RowID" field specified as Identity and as the Primary Key.The BoundField for the Rowid is set to ReadOnly. There is "Edit, Delete, Select" specified for the CommondField. Edit and Select operate as they should.
HOWEVER, Delete results in a "Must declare the scalar variable "@RowID" (with the associated "unhandled exception" verbiage).
The DeleteCommand text in the SqlDataSource for the GridView reads
DELETE FROM [Events] WHERE [RowID] = @RowID
along with
[Code]....
I have inspected and compared with similar forms that function correctly and can see no differences (except for the table names).
I have wrote some codes and also i have added delete column with gridview and would like to make it work ,i mean when someone press delete button i want to delete that row.
here is my codes
[Code]....
I have a gridview which at run-time contains X number of records. Upon clicking a DELETE linkbutton on a particular row the gridview completely disappears from the page, when it should reflect simply the loss of that one record. Everything is okay on the database end, the record is deleted, so I know that part is working. I run a query and rebind the gridview within the Rowdeleted event. I even try hardcoded a value in the query which I know exists in the database and it still doesn't refresh with this record showing. Whatever code I need to post, let me know.
[Code]....
I use a gridview in my aspx page with a asp:CommandField for delete data.. I need a confirm for action, than I add:
Protected Sub lavorazioni_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles lavorazioni.RowDataBound
code for deleting with the chechbox i'm searching for it
View 3 RepliesI get the following error when trying to delete a row in a gridview. The error is strange, since I dont pass 2 parameters as far as I can see.This is the error and the code is below:
Server Error in '/' Application.
ObjectDataSource 'odsRooms' could not find a non-generic method 'DeleteRoom' that has parameters: id, locationid.
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.InvalidOperationException: ObjectDataSource 'odsRooms' could not find a non-generic method 'DeleteRoom' that has parameters: id, locationid.
Source Error: [Code]....
Stack Trace: [Code]....
[InvalidOperationException: ObjectDataSource 'odsRooms' could not find a non-generic method 'DeleteRoom' that has parameters: id, locationid.]
System.Web.UI.WebControls.ObjectDataSourceView.GetResolvedMethodData(Type type, String methodName, IDictionary allParameters,[code]....
my web site i have two databases, ASPNETDB.MDF and a self created one (database.mdf). (The don't contain a lot of data yet)But i need a relationship (foreign key) between a table in ASPNETDB.MDF and a table in database.mdf.So i guess i need to merge both databases first, would you just extend the "ASPNETDB.MDF" with the tables from "database.mdf" ?or better configure "database.mdf" for the asp.net Applicatoin Services and then delete "ASPNETDB.MDF"
View 2 RepliesThis is my code and i am only able to edit the one data under the category school.But what i nd is to edit the other categories like the name,email...etc..how do i modify my code in the update command.Another thing is to delete the data how do i do that?
[Code]....
Using my own button I would add a little bit of script to the onclick asking if the user wants to delete or not.How can I do this with the grid view?given that this is the button...
<asp:CommandField
ButtonType="Button"
ShowEditButton="True"
/>
How do I call the script?
The dafault database for membership does not allow Delete statement. So what should I do to delete the member from database as a Administrator.
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataKeyNames="UserId" DataSourceID="SqlDataSource1" Width="800px">
<Columns>
<asp:BoundField DataField="UserId" HeaderText="UserId" ReadOnly="True"
SortExpression="UserId" />
<asp:BoundField DataField="UserName" HeaderText="UserName"
SortExpression="UserName" />
<asp:BoundField DataField="CreateDate" HeaderText="CreateDate"
SortExpression="CreateDate" />
<asp:BoundField DataField="LastLoginDate" HeaderText="LastLoginDate"
SortExpression="LastLoginDate" />
<asp:BoundField DataField="LastActivityDate" HeaderText="LastActivityDate"
SortExpression="LastActivityDate" />
</Columns>
</asp:GridView>
I'd like to delete the row without using the DeleteCommand in GridView. I created the button "Obrisi" which should delete the row from the table, but when I click on it I get the following error: "The multi-part identifier "System.Web.UI.WebControls.DataControlFieldCell" could not be bound." and I don't understand what the problem is.
Here is the code (part of the code after else if is important):
[Code]....