I have this gridview, that works perfectly when running in local computer. Platform is VWD 2010 - Sql Server
[code]....
Browser fire the confirmation question, but after hittting YES, nothing happens.
It works fine in my computer, nothing happens in the hosting server.
how would i do my Gridview delete command like a update command?
im using a datasource... and my delete command is like my update command... so i can change the status into "INACTIVE"...
DeleteCommand="UPDATE ACCOUNT_MAINTENANCE SET am_status = 'INACTIVE' WHERE (accmain_no = @accmain_no)"
UpdateCommand="UPDATE [ACCOUNT_MAINTENANCE] SET [account_type] = UPPER(@account_type), [min_deposit] = @min_deposit, [min_capital] = @min_capital WHERE [accmain_no] = @accmain_no"
when i press my delete command at gridview... the status changed into "INACTIVE" but when i refresh or press f5... it automatically update the status into "INACTIVE" also...
I have done this successfully in another project and seemingly copied the code from it to a new one, yet it doesn't work.
I have a custom gridView with the following code:
<asp:GridView ID="gvCustomEditors" runat="server" AutoGenerateColumns="False"
I have a GridView and a SqlDataSource, which I have set to automatically generate Delete/Insert/Update statements. I then just enabled Deleting on the GridView, and usually away I'd go. For some reason though, the row is not being deleted - the page is posting back but the row is still there. When Delete is clicked, RowDeleting does fire though. What possible causes could this be?
Edit: SELECT command:
SELECT id, templatename, CASE WHEN type = 'W' THEN 'Weekly' WHEN type = 'M' THEN 'Monthly' WHEN type = 'Q' THEN 'Quarterly' WHEN type = 'S' THEN 'Six-monthly' WHEN type = 'A' THEN 'Anually' END AS TypeText, CASE WHEN invorcred = 'I' THEN 'Invoice' WHEN invorcred = 'C' THEN 'Credit' END AS 'InvOrCredText', nextinvdate, lastinvdate FROM InvoiceTemplates WHERE (sageaccount = @sageaccount)
I have some simple shopping cart using DataTable and Session, all data are in datalist after user click "Add" the record go to gridview. how can i add delete button to delete row from the gridview?
aspx.cs:
[Code]....
aspx (gridview):
[Code]....
I've created an exact copy of this tutorial (vb) [URL] ....
However the delete click is not firing at all - I've removed the click confirmation too but the DeleteCustomers sub just isn't getting called. It compiles & runs fine with the edit/update actions.
I have 3 gridviews in one of my web page. I have simplified the system structure in the image below(further description will be stated below the image): As shown in the image above, the web site(presentation layer) will work closely with the Business Logic layer(BLL) and Data Access Layer(DLL). ObjectDataSource control will be the middle man to select, update, insert and delete the data in the gridviews. During Select, returned data from the database at DAL will be stored in a datatable and return to BLL and then the website itself.
The data in the returned datatable will be filetered by type using RowFilter method and stored into the 3 dataviews. Each dataview will act as the datasource for the 3 GridViews respectively, and therefore I specified the datasource programatically instead of setting the datasourceid for each gridview.
dataview1 = New DataView(dtSelectedTable)
dataview1.RowFilter = "Type='1'"
GridView1.DataSource = dataview1
GridView1.DataBind()
dataview2 = New DataView(dtSelectedTable)
dataview2.RowFilter = "Type='2'"
GridView2.DataSource = dataview2
GridView2.DataBind()
dataview3 = New DataView(dtSelectedTable)
dataview3.RowFilter = "Type='3'"
GridView2.DataSource = dataview3
GridView2.DataBind()
However, the Update(command button) and Delete(template field) doesn't work, the RowUpdating and RowDeleting event wasn't trigger when I click on the button, but it works if I set the gridviews' datasourceid to the objectdatasource. I couldn't figure out why, hope that someone who have come across the same problem couldn't provide some guidance.
Something "weird" is happening with my ASP.NET application. I have a MasterPage with WebForms, and inside one of them, I have an ASP TextBox which is controlled by the MaskedEditExtender/MaskedEditValidator couple. Underneath, I have a GridView with 2 columns, an Edit ASP Command Field, an ItemTemplate which contains an ASP ImageButton with a Delete CommandName linked to a GridViewDelete Event through the OnRowDeleting attribute. The GridView is binded with SQL Server data while the page is loading.
It appears that once the page is loaded, if I want to delete a row by clicking on the ASP ImageButton, nothing appears. I have first to do something else with the GridView (raise an Edit Event for example), then it's accessible. I try different stuff to catch the source of the problem, and the "weird" part appeared when I deleted the MaskedEditValidator, just keeping the MaskedEditExtender : the Delete ASP ImageButton worked since the page loads!
I'm a novice programmer and I have this situation: I have a nested Gridview, and I want to be able to DELETE the records in the nested Gridview. I have no problem inserting new records with the nested gridview, but it does not execute the DELETE Command on the SQL Datasource. I checked that the DATAKEYNAME on the nested gridview includes the the parameter that is used in the DELETE SQL Command on the SQL Datasource for that Gridview. But it seems to me that the parameter value is not being passed to the SQL Datasource by the nested gridview. Maybe I need to use a difference approach to execute this on a nested gridview compared to a regular gridview.
View 4 RepliesI have a very simple page that consisist of an UpdatePanel that contains a gridview. The gridview includes a delete button for each row, which should fire the Delete event. But the event never fires. If I set a breakpoint inside the event handler, it never gets hit and the row does not get deleted. When I say OK on the confirm dialog it just goes back to the page. I tried taking out the confirm button extender
ASPX:[Code]....
almost done with my gridview model... Everything is working fine, bit today I noticed that my gridview delete only works on the first page of the paginated gridview. As soon as I goto the next page of my (eg) 10 rows, I can click on delete what I wan't but nothing happens. So this is what i use:
I have a gridview with a datasource, including filter- and selectparameters, paging, ipp selector etc. No code behind used.
For the delete of a row I use a imagebutton in an templatefield:
<asp:TemplateField>
<ItemTemplate>
<asp:ImageButton SkinID="ImageDelete" runat="server" ID="ImageDelete" CommandName="Delete" OnClientClick="event.cancelBubble=true; return confirm('are you sure?');" />
</ItemTemplate>
</asp:TemplateField>
In my SQLdatasource I use a Deletecommand and deleteparamter:
DeleteCommand = "DELETE FROM [TblMessages] WHERE IDtblmessages = @IDtblmessages"
<DeleteParameters>
<asp:Parameter Name="IDtblmessages" Type="Int32" />
</DeleteParameters>
it's working fine on the first page, but not on a nother page when I'm paging throught the total set.
I also use a filterexpression and selectparameters (bases on dropdownlists) to filter the gridview. This also works great, but the same ater applying a filter: the delete imagebutton doesn't work then.Just found out it's caused because something I completely forgot: the gridview resides in a updatepanel. My structure is as follows:
masterpage > content > updatepanel > gridview
I have 3 gridviews in one of my web page, each of which will display different data based on the typeid. I have simplified the system structure in the image below(further description will be stated below the image):
As shown in the image above, the web site(presentation layer) will work closely with the Business Logic layer(BLL) and Data Access Layer(DLL). ObjectDataSource control will be the middle man to select, update, insert and delete the data in the gridviews.
During Select, returned data from the database at DAL will be stored in a datatable and return to BLL and then the website itself.
[code]....
However, the Update(command button) and Delete(template field) doesn't work,the RowUpdating and RowDeleting event wasn't trigger when I click on the button, but it works if I set the gridviews' datasourceid to the objectdatasource.
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]....
I am interested in building an intranet document management system to be used from Internet Explorer using ASP.net, VB.net, and MS SQL Server but have no experience in doing a project like this. Supported file types would be txt, pdf (from scanner or imported from file system), or jpg. What concepts I should look at researching/learning about to build the system in a way that files will be stored as small as possible, retrieved and displayed quickly, and secured. The users would be spread out over a regional area covering 4 states.
View 5 RepliesI want to make an conformation dialog on auto generated delete button in detail view that when user press delete dialog or conformation box appear that u sure u want to delete how can i do this?
View 1 RepliesI have visual 2010 with net 3.5 web app. I was implementing EntityFramework in my project and added a gridview to a entity source control. It worked ok, with select, update, and delete buttons enabled on the grid. But then, i needed to add a template field bound to a Foreign table, so my users select value from a list instead of writing the code. After that, my app fires error when i delete. I tried everything, inclue dakeyNames, write code on my RowDeleting, RowDeleted, RowCommand, but error persists.
Now, i can delete the row, but it then i get the error Object reference not set to an instance of an object If i implemente delete code on RowCommand i get the error: Store update, insert, or delete statement affected an unexpected number of rows (0). Entities may have been modified or deleted since entities were loaded. Refresh ObjectStateManager entries.
[Code]....
all of a sudden my GridView has stopped firing the row update event. Friday I was working on it and was working flawlessly. Now I haven't made any changes to the code and all of a suddent has stopped working (yes rediculously bizarre and have been banging my head all day thinking what the something is wrong with it, excuse my french).
Everyone of those events fire except the update. I click the update button and nothing happens.
I am using pop up extender in repater control.I have alink button asscoiated with for the pop up extender in repeater .I want to do processing in item command event which is not firing. I need to use command argument value in item command event Pop up window is coming but the itme command is not firing.After some research on google i find out pop up extender block the events aasscoaited with target control id of pop up extender..
View 1 RepliesWorking in Asp.net 4.5 + Kentico CMS
I have Repeater in usercontrol and Inside the repeater i have 1 itemtemplate in which i have ImageButton on it. Also i am handling the Click event on the Imagebutton using ItemCommand of the Repeater. when i click the image button it fires the item_command on the codebehind which is fine. But if i use !Ispostback on page load to stop loadinghte databind event again which is in pageload, it's not firing the Item_Command Event.
If i remove the !Ispostback from my page it's doing the pageload event againt which has calling my databind method and then it calls the Item_commands event. Wondering is this kentico issue or usercontrol problem?
i am using asp.net, c#. I want the selected index for the current row which is selected by the user.
View 1 RepliesI have a page that uses the Ajax Reorder List.
It is based on the example code from Joe Stagner's excellent video.
The adding and reordering work perfectly.
I added a delete button in the Item template. However the delete function doesn't seem to do anything.
[Code]....
see this code.
[Code]....
"Tbl_Name" is a varaible contain tables name for delete records on an table(at a time Tbl_Name change table name by drop down list)
problem: in SCommand.ExecuteNonQuery() error appear:incorrect syntax near Tbl_Name (i use ado.net connection)
I have mysql database which has been connected to web page in grid view (using add object), i would like to make delete option enabled in my web page to erase the records using check boxes may be multiple checks in single time, but i have finished the code for enabling single check and multiple checks of check boxes, my query is how to connect my mysql database to the web page using code so i can easily connect the database for using the delete command.
View 1 RepliesWithin my ItemTemplate on a listview i have a link button carrying out a delete command. As it's a custom command i use the ItemCommand to do the deleting and have a stub itemdeleting.
It works fine set out like this however i only want the delete button to be available to logged in users. If i wrap the linkbutton in a loginview and then click on it the ItemCommand and ItemDeleting never get called the page just refreshes.
you can see the page under development at http://job1data.com:8098/admin.aspx
it looks like its setup right, the page source has the correct message for each button for the javascript:return invoked with onclick, all that was setup in the onItemDataBound routine and the delete code behind is getting invoked, i just have a message there for now for testing, so it all seems to be there, but no confirm dialog box?
