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]....
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'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 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 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.
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'm trying to add a second command field to an asp.net gridview. Essentially, I want the user to have the options to delete and update records on one page. I've gone through gui's to do this that I have found on the web but none of them work. I think that this is because of the fact that I am working with Visual Studio 2008, so the gui's don't match. Plus, my datasource isn't allowing me to add delete parameters, and update parameters. So, my present goal is to have multiple command fields in my gridview. This would also enable me to add a "duplicate record" functionality, as is needed with this program. I would also like add functionality. If possible. I've been doing all this on multiple screens but I believe I should be able to do this on one screen. Here is my gridview and datasource.
[Code]....
[Code]....
Within 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.
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.
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'.
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.
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)
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 having an issue with trying to add a button to my grid. My GridView is first loaded with data in the PageLoad event.
I'm then taking the data in the first cell of each row, and creating a button that will link to a URL. To get the URL, I have to run a query with the data in the first cell as a parameter. I was doing this in the RowDataBound event at first, but hitting that query for every row was making it really slow.
So I decided to add a button that would retrieve the URL only when you clicked the button.
Here's my GridView:
[Code]....
The grid generates fine, the button gets added to the grid for each row. But when I click on it, the RowCommand event doesn't fire, and the page just refreshes.
i'm trying to issue a select command in my app soi could execute the command and retrive the data into a string variable.the problem is that this command is overloaded with DataSourceSelectArgument and i can't figure out what it is.i'm using sql server express and when issue a n insert command for example sq.Insert(); i have no problems.this the command that's holding me:
SqlDataSource sq = new SqlDataSource();
sq.ConnectionString = ConfigurationManager.ConnectionStrings["CustomerDatabaseConnectionString1"].ToString();
sq.SelectCommandType = SqlDataSourceCommandType.Text;
sq.SelectCommand = "SELECT * FROM CustomerTable where customerID = 1";
string result = sq.Select(some overload that's stopping me);
how i can perform Update Row in Gridview using Template Feild's
[Code]....
[Code]....
what will be next step as i know how to write update statement in databasejust want to know how i can catch the template feilds value and update on click of edit
[Code]....
I am using this command to get the value of a particular cell in the GridView: Question: Do you know why I do not get a value in strValue ?
There is definitely value in the grid.
protected void grid_RowCommand(object sender, GridViewCommandEventArgs e)
{
//proceed only if the Details button is clicked...
if (e.CommandName.ToLower() == "details")
{
//Get the row index selected...
int index = Convert.ToInt32(e.CommandArgument);
GridViewRow row = grid.Rows[index];
string strValue = grid.Rows[index].Cells[1].Text;
}
inside row command event of gridview i want to call a function which will open db conectn and run a stored proc to fetch value.but this gives error.
View 3 RepliesI am trying to use an Update Command within my GridView. I need to find the "FindControl" for the Edit Command textboxes.
Ie. When the user clicks the Edit button, the row is populated with dropdown boxes, textboxes, etc for editting. Then when the user clicks on Update (button) and the GridView1_RowCommand function is activated with 'if (e.CommandName == "Update")' statement with my FindControl. etc. and my sql UPDATE command statements are used. How do I convert my FooterRow info to my Edit FINDCONTROL info?
This is what I have:
[Code]....
i am using edit,update,cancel command in gridview, i need to update value in bound field how to retreive that value.
View 7 RepliesI have a simple table, ID,Fruit,StockSo, the rows are its primary key (ID), Fruit type (Orange, Apple etc) and Stock (1 is it is in stock, 0 if it is out of stock).I have a grid view on a page which lists the rows.What I would like is a button that executes a SQL command based on the row.(The command is just an update to change the Stock field from 1 to 0).The query i tried was UPDATE [Table] SET [Stock] = 0 WHERE id = @id
View 6 Replies