how can i delete the whole rows of gridview using code behind c sharp like
Col1 Col2 Col3
a 1 5
a 2 6
a 3 7
a 4 8
and I want to delete the whole rows in the gridview so that it becomes
Col1 Col2 Col3
a 4 8
only last duplicate row left and all the rest is deleted (rows are deleted from all the columns of gridview)
I have an asp.net 2.0 web app and one of the pages uses a grid to add/edit items before exporting the contents to excel. The items in the grid are selected based on a dropdown list--after the item in the list is selected, the grid goes and gets the items, populates a dataset and binds the dataset to the gridview. Some of my users are experiencing an issue where after deleting a random number of rows, a row not deleted will disappear or reappear. Though I have witnessed the behavior, I cannot duplicate it on my machine where the developement occurs (Win XP Pro, IIS 5.1, vwd2005 express). The windows 2003 server uses ASP.Net 3.5
Here is the code related to editing and deleting:
[Code]....
If I had to make a guess as to what was occuring, I would say that it appears at times to retain the deleted item's index after the grid is sent back to the user and tries to delete another row. But like I said, I can't duplicate the problem on my dev machine. if this might be caused by .Net 3.5 trying to run a 2.0 site?
I have created a gridview which adds a remove button through item template. I wish to know how do u remove the row from grid view dynamically depending upon the button he clicks ?
protected void RemoveBtn_OnClick(object sender, EventArgs e)
{
Button clickedButton = sender as Button;
GridViewRow row = (GridViewRow)clickedButton.Parent.Parent;
int rowID = Convert.ToInt16(row.RowIndex);
GridView1.DeleteRow(rowID);
}
<asp:GridView ID= "GridView1" runat="server" AutoGenerateColumns="true" OnRowDeleting="RowDeletingEvent">
<Columns>
<asp:TemplateField HeaderText="Remove Items">
<ItemTemplate>
<asp:Button id="RemoveBtn" runat="server" Text="Remove" OnClick="RemoveBtn_OnClick"/>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
Using vb.net/asp.net 2005.I have an inner gridview.The outer gridview is "Authors" and in the inner gridview (GridView1 below) I have to set it up so that the user cannot delete the last book from the inner grid, if they try to delete the last book from that inner grid then I want to show the exception message below.
So I am checking the GridViewRows1.Rows.Count which works great when I have one record (one book) to start with. The problem is when I have 2 books (for example). I am writing out the test statement below and the RowCount is always 2 each time, never decremented, even after I rebind.Editing this now: i realize that my initial logic is faulty because when I rebind my inner gridview I am not specifying which inner gridview so the result is that only the last inner gridview is being re-bound, so I think that I need to get the selected inner gridview and then refresh that...
[Code]....
I am using VS2005 and SQL Server 2005. The problem I am having is when I call my SQLDataSource to delete rows the delete is firing twice. The trace and debugging show the code executing once. In fact right after the delete, the table only shows one delete, but right after the command function is exited the 2nd row is deleted. Also, I have tested the stored procedure to make sure it only deletes 1 one and then resequences the records.Show below are excerpts from my .aspx and code behind files.
[Code]....
I've got a GridView that's databound to a DataTable that I have stored in Session. I want to be able to add a LinkButton into this gridview so I can delete rows from the DataTable, however, I need to reference the rows in the datatable somehow.
I figured the simplest was
[Code]....
but the problem is, I need to somehow cross-reference the particular row I want deleted.
Would like to know how can I delete all the session state data (Empty Cart) and deleting a single row from the gridview while still in session state. (Remove Item).
[Code]....
I have a gridview that shows all data from a table. DataNames includes KeyId, which is a Primary Key.Yet when I try to delete a record, nothing happens, the page appears to performa refresh but the record is still there.Edit does not work either. I used the wizard to build all of the queries, they look okay. But I cannot figure out why they are not working.
[Code]....
m using gridview to display records from sql server2005. In gridview, I have a field containing checkboxes. Now what i want that the fields against which a user checked in checkboxes that will be deleted by clicking on delete button just like the emails yahoo, gmail etc How can i do so?
View 2 RepliesI have a small website with a database. Just two tables for personaldata and for files belongs to the personal data.
This files are stored on HD. My problem is to delete this file by clicking on delete button within gridview. At the moment only the record is deleting but not the file which belongs to this record.
That is my Gridview:
[Code]....
and that is my codebehind file:
[Code]....
and see the screenshot. (how it looks like)
i get allready help here to create the right codebehind file for that.
i have tried that this way:
[Code]....
But i think instead of txtFile.Text the filename of thefile should be readed out of the database on this place or Im wrong?
I have a gridview,sqldatasource and a link button for delete in the sample code below
When Delete is click the confirmation pops up. When I confirm yes, the rowdeleting event doesn't seem to be firing. I addeed a label to see if the event is firing. To avoid runtime errors I added a dummy but actual sql delete command. Once If I get it to work, I want call a stored procedure to delete the row.
My question is
1. Why is the gridview row deleting event not fired.
[Code]....
I modified a GridView control to enable alphabetical paging, and in doing so had to bind the GridView manually in the code behind rather than using the ObjectDataSource I had used originally.
Now my "delete" command in the GridView isn't working. I get that I need to handle this in the code behind now that I'm no longer bound to the ObjectDataSource.
But I'm not sure how to do that in C# and am not finding any examples.
Here's my .aspx:
[Code]....
And the .cs:
[Code]....
I have a gridview and a SQLDataSource control. In my gridview I have 2 commandfields "Edit" and "Delete"
The "Edit" command field works as expected. Using the "Delete" command field I get the error below.
Server Error in '/DataControls' Application.
The DELETE statement conflicted with the REFERENCE constraint "FK__titleauth__au_id__0CBAE877". The conflict occurred in database "pubs", table "dbo.titleauthor", column 'au_id'. The statement has been terminated.
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.Data.SqlClient.SqlException: The DELETE statement conflicted with the REFERENCE constraint "FK__titleauth__au_id__0CBAE877". The conflict occurred in database "pubs", table "dbo.titleauthor", column 'au_id'. The statement has been terminated.
Source Error:
[Code]....
Stack Trace:
[Code]....
I am using a Gridview inside an UpdatePanel. I am using the RowCommand method to call my code to delete the record. The gridview is bound to a <list> collection. I am unable to get the Gridview to postback / refresh after the users deletes a record; however, if I refresh the page in the browser and the page loads, it obviously is gone. I have searched quite a bit on this where others are having problems but nothing they did work for me, so I was hoping someone could review my code and let me know what I am doing wrong.
Here is my ASPX:
[Code]....
Here is my C#
[Code]....
When I step through the code, the postback happens and then my delete code is called, so once the delete code happens, the page is already finished loading, which seems to be my problem.
I have a gridview in which update and delete is enabled.
I have the following fields in database table, which is binded to the grid view through sql datasource.
ID,Firstname,Lastname,Add,City,modifieddate. Here ID is primary key.
1. When edit and delete is enabled in the grid. The ID column is showing in the grid,which i don't want to show. But without that ID column the grid is not able to update and delete. Plz tel me how to update and delete without ID column in grid.
2. When ever any update is happen in the grid, the modifieddate should get updated. Here the date is not datetime.now , i need to use my own system date and time. Coz my server and system time has some difference.
I have use the following javascript to get system date and time, which is working fine. This date should be get and update in the modified column.
function displayTime() {
var m_names = new Array("Jan", "Feb", "Mar",
"Apr", "May", "Jun", "Jul", "Aug", "Sep",
"Oct", "Nov", "Dec");
var localTime = new Date();
var year = localTime.getYear();
var month = localTime.getMonth() + 1;
var date = localTime.getDate();
var hours = localTime.getHours();
var minutes = localTime.getMinutes();
var seconds = localTime.getSeconds();
var div = document.getElementById("TextBox1");
div.innerText = date + "-" + m_names[month] + "-" + year;
}
I have table with 1000 rows. is it possible to delete top 500 rows with truncate statement ??
View 2 RepliesBefore I begin, I would like to acknowledge that I might be using incorrect terms below due to my lack of experience.
I have a GridView bound to an ArrayList of Custom Objects. I have a button as part of each row, which when clicked, I delete the row from the Arraylist, and re DataBind() the GridView. While this deletes the Row, it causes the Page to be refreshed that takes the User back to the top of the Page.
E.g. If the User clicks on the button of a row at the bottom of the Page, after the deletion, the Page gets refreshed and the User is now taken to the top of the Page.
This is irritating especially in long lists i.e. GridView with many rows. (I don't want to use paging here.) Is there any way to avoid this, or mitigate this problem.
I am tring deleting the image in the gridview and in folder where it locate . My page in the update panel
write a funtion to delete in the delete button event , it not working in update panel when i comment the
update panel then it working properly.
I've been googling for 2 days for the solution, but I couldn't find something useful. The problem is that I have GridView that is connected to the SQL database and that is how it is being populated. I added EDIT and DELETE buttons in the columns, but as far as I can see the event which handles them is empty.
[Code]....
COMPLETE NOOB, dont know anything.. I have a Virtual directory ~/ClubInfoFiles that i upload some files too using a uploader i made. I might want to change the uploader i made to be able to change to a subdirectory or something so i can upload all files into one folder but different subdirectorys. the uploader i would like to be able to have a dropdown menu of all the subdirectorys within "ClubInfoFiles" say i has subfolders : Minutes, Flight Plans, Maintence Records, etc... but i would also like a field to where i can create a new subdirectory and have it automaticly update the dropdown. i want to list those files in gridview and have a link to dowload/open and dellete the files. i have found some code that gets close but it uses Auto Generate columns. really i dont need all that jazz, just the Name, File extention, and hyperlink the file for download/view. i would like to be able to delete and possible upload using the gridview... is this to much for a noob?
[Code]....
[Code]....
[Code]....
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.
[Code]....
my users haves different permission: some users can delete, and some users can editing in a gridview how can i allow this at specified users? and hidden the button ho allow the delelte or update record?
View 3 RepliesI am having trouble changing page numbers on my gridview after deleting a record if the deletion of the record causes there to be no more records on that page. Currently I have a form below the gridview that adds a record to the datasource of the gridview.
[Code]....
Code behind stuff:
[Code]....
Now with this code above, if I insert a new record using the form below the gridview, it will reload and go to the new page if the insertion causes the record to appear on a new page, however when I delete that record, thus causing nothing to be on that page, the gridview visually just dissappears. I've got the gridview bound by a linqdatasource control, and on the page_load function I only databind if the page is not a postback.
I'm using vb and after i converted it from C# and tried to implement this:
[Code]....
I got an error that said: Unable to cast object of type 'System.Web.UI.WebControls.GridView' to type 'System.Web.UI.WebControls.LinkButton'.
And here's my code for the gridview table.
[Code]....
I've tried altering the code here and there but it never work
Protected Sub GridView1_RowCommand(ByVal sender As Object, ByVal e As GridViewCommandEventArgs)
I have a GridView in an update panel that is bound (in code-behind) to a business layer object. The first time this page is accessed, Editing, Deleting, Updating, etc. work fine. However, if I click my browser's refresh button, the functionality of the edit, delete, etc link buttons is gone. They do nothing.
here's my code:
[Code]....
Here's the code-behind:
[Code]....