Automatically Generate Delete Command For GridView Not Working
Nov 9, 2010
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)
View 4 Replies
Similar Messages:
Apr 8, 2010
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 Replies
Aug 7, 2010
I 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]....
View 2 Replies
Apr 26, 2010
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...
View 3 Replies
Feb 1, 2011
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.
View 1 Replies
Jul 23, 2010
My GridView uses auto generate Edit & Delete command button. And then program the insert button. I want to do something when users click the Edit button so I wrote something like this:
[Code]....
When click the Insert button in the Footer, the program works fine. But when trying to click the auto generate Edit button, the following statement failed with the exception stated in the code above:
first_name = gvAgent.SelectedRow.FindControl("txtEditFName")
View 14 Replies
Jan 10, 2010
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]....
View 4 Replies
Apr 3, 2010
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.
View 5 Replies
Jul 8, 2010
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!
View 2 Replies
Apr 3, 2010
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.
View 6 Replies
Jan 21, 2010
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]....
View 5 Replies
Nov 7, 2011
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 Replies
Jan 7, 2014
I 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 Replies
Apr 23, 2010
I have a gridview control in which there is a column with checkbox. I will have to delete the rows of the grid selected by the checkbox. After the delete operation i am re-binding my grid we new datasource to populate latest data. The data is comig up correctly and the no of rows in the grid are also correct.
But the problem is that, if i select row 1 to delete and click on delete button, row 1 is deleted, grid is refreshed with new list, but row 2 checkbox is getting automatically checked. I don't know how this is happening. I have tried of writing code to uncheck all checkboxes after i rebind the grid. None of them are working. When i debug and see the items are actually showing as checked=false, but on the screen the check box is checked.
View 3 Replies
Mar 6, 2011
I 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.
View 1 Replies
Jun 3, 2013
I am working with odbcCommand class, in one case I got error that QueryTimeout Expired. Even though this SP is taking only 3-4 secs in DB to execute these specific values, When I set the CommandTimeout=0, then it worked fine.
1)Is it necessary to always use this property while working with Command Class.
2)If it is not suggested to use, but still if I use it then how it will impact the performance.
Below is my code sample.
OdbcConnection conObj;
OdbcCommand cmdObj;
OdbcDataAdapter daObj = new OdbcDataAdapter();
public DataTable GetIFAContractNoteData(string RecipientIDIFACN, DateTime BatchDateIFACN, int TransmittalReportIDIFACN) {
conObj = new OdbcConnection(GlobalVariables.strDsnName + ";" + GlobalVariables.strDsnDataBase + ";" + GlobalVariables.strDsnUserID + ";" + GlobalVariables.strDsnPassword);
[code]....
View 1 Replies
Feb 7, 2011
[Code]....
I can open the modalpopup, can close the popup, but if i click the "edit" button to edit any of rows, the popup closes automatically. If I click again, the "Update" and "Cancel" buttons shows, and after clicking one of those, popup closes again. The above code works, if i use gridview the insert, edit or delete the data, does not close automatically. What may be the cause of this problem.
View 1 Replies
Mar 10, 2011
I have made Gridview and it has 5 columns.
Col1 Col 2 Col3 Col4 Col5
I try to make like below:
Col1 Col2
col2 col3 col4 col5
First column is as it is. But next 4 columns I try to make merge from Gridview Row Databound Event. It's working.
I have a link button in column1 and when I click on it, Row Command is fire and at that time the merge is gone. And Last row comes in footer row.
View 4 Replies
Jan 25, 2011
I have a small web application based on asp.net 2010 that manages invoices.
After the invoice is saved, it should automatically generate a pdf file.
which of the following solutions would be fast and easy to incorporate?
Use Sql Server 2008 Reports
Use Crystal Reports 2008 and Crystal Reports 2008 for VS 2010
Use itextsharp to create the pdf file
Use XSLFO to create the pdf file
The point here is I dont know any of the above. Which one is easy and quick to learn and implement. Are there any other solution to achieve this functionality?
View 5 Replies
Mar 23, 2010
i want to automatically generate a unique string as orderID. I dont want to use Guid, it is not user frindly, and i dont want to use indexer either. any build-in datatype i can use?
View 11 Replies
Sep 4, 2010
I have problem with the buttons Edit and Delete in Gridview for very long time and i really need 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.
See how looks my page:
Now here's my code in aspx:
[Code]....
Now here's my code in cs:
[Code]....
I'm not sure if the statements not working. P.S. the cancel button works fine.
View 25 Replies
Jan 7, 2011
I create a database with more than 10 tables, how can I automatically generate business object class inside asp.net C# project?
I hope that one expert can give me steps for how to do that?
View 3 Replies
Jun 10, 2010
I would like to generate my links automatically via a static class in each of my aspx pages (or in a common BasePage).Currently I use this:
private const string TEMPLATE =
"~/One.aspx";
public static string Link ()
(
string link = String.Format(TEMPLATE);
return link;
)
But the name of my page, One.aspx is hardcoded. Is it possible to generate the path instead of this hardcoded constant TEMPLATE. You should know that I do not instantiate the class before creating the link.
View 1 Replies
Dec 28, 2010
s there any code to generate property automatically from datatable?I mean there is a table A with column id,name,address.Run the code and this will generate a class automatically to set and get property.Property of that class will be the column name of the datable A.
View 1 Replies
Dec 31, 2010
Is there any code to generate three or N tier architectue automatically?
View 8 Replies
