I have gridview+sqldatasource. In gridview i have button DELETE. But i want on click this button for some rows execute DELETE command other rows UPDATE. I did:
[Code]....
@index - DeleteParametrs in sqldatasource.
But DELETE works and DELETEVIRTUAL doesn't. Then i insert sourceMain.Delete() in rowcommand after sourceMain.DeleteCommand ... But it's doesn't help me.
how do i edit and delete in gridview without sqldatasource commands?
View 2 RepliesHow do I modify this code to delete from SQLDataSource where the SQL command and parameters are specified in ASP?
[Code]....
With asp 2.0 and vwd 2005, I have a page with a radiobuttonlist, textbox and gridview with edit/delete. Using the radiobuttonlist, the user selects a search type and then enters the criteria in the text box. the click event of a submit button checks the rbl.selectedindex and chooses a sqldatasource.selectcommand with the where clause getting its criteria from the textbox. The gridview loads the data, but the edit/delete are not working. Code and relevant markup is below
[Code]....
[Code]....
[Code]....
I'm having a gridview in my aspx page with checkbox, User can select one or more than one record(s) at a time and clicks on delete button, Then i'm constructing an object of my DTO and adding all the checked row's Primary Key (DataKeyNames - GUID's in my case) to a serializable class and generating an XML and sending it as parameter to the Stored Procedure.
My Doubt is, can i bulk delete all the rows from database table those are present in my XML document??
If it works, I can do bulk update with XML only, i already did bulk insertion by generating an XML..
My Another Question is, Will it affect the performance? Each time when i construct an DTO object and adding it to the Generic List?
Which one is better, I mean ObjectDataSource or SQLDataSource or my XML method?
[code]....
i want delete record from gridview(delete template feild) but i have a error!
View 1 RepliesHow to write a delete query which can delete a specific row from grid view? I wrote this :
DeleteCommand="DELETE FROM member"
It delete all my entry in table called member. =(
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:FYPConnectionString %>"
SelectCommand="SELECT * FROM [member]" DeleteCommand="DELETE FROM member"></asp:SqlDataSource>
I have two image buttons in a gridview, one to approve the opening of the record and one to approve the closing of the record. I have added a CommandName to each button (OpenApproved and CloseApproved) and in the grids rowcommand I would like to update the database with the Username of the person clicking the button, Username goes into either the OpenLeadApprover or CloseLeadApprover field depending on which button is pressed. The grid has a sqldatasource with an Update stored procedure which has three parameters, @WorkOrderIDWhat I have tried to do in the RoeCommand event is declare a variable for the sqldatasource and add the parameter value to it, then run the update command. Here is the code:
[Code]....
I am getting error as Procedure 'storedproc2' expects parameter '@NewMessage', which was not supplied.Basically in this I am taking the text in one cell and add sometext to it and update in the next cell of the row.
My .aspx contains
<asp:SqlDataSource ID="mySource1" runat="server" ConnectionString="<%$ myConn %>"
SelectCommand="storedproc1" SelectCommandType="StoredProcedure"
UpdateCommand="storedproc2" UpdateCommandType="StoredProcedure">
<SelectParameters>
<asp:SessionParameter Name="AcctId" SessionField="AcctId" />
</SelectParameters>
<UpdateParameters>
<asp:SessionParameter Name="AcctId" SessionField="AcctId" />
<asp:SessionParameter Name="Id" SessionField="Id" />
[code]...
End Sub
asp:GridView ID="Departments" runat="server" AutoGenerateColumns="False" DataKeyNames="EntityID" DataSourceID="AccessDataSource1"
BorderColor="White" BorderWidth="0px" Height="79px" Width="232px">
<Columns>
<asp:BoundField DataField="EntityName" HeaderText="Department"
SortExpression="EntityName" />
<asp:TemplateField>
<ItemTemplate>
--->>> <asp:Button ID="btnJoin" runat="server" CommandArgument="<%# CType(Container,GridViewRow).RowIndex %>"
CommandName="Join" Text="Join" BackColor="#F2F0FF" Font-Bold="True" />
</ItemTemplate>
</asp:TemplateField>
I have several Gridviews that display data from the same table. They are separate for visual effect (Different characteristics). If I select on an item from any grid they can all execute the same code (Show Details).I'm using a row command GridViewCommandEventArgs.Is it possible/How can you get the gridview name from the row command so that I can use just one subroutine.
Sub GV_RowCommand(ByVal sender
As
Object, ByVal e
As GridViewCommandEventArgs)
If e.CommandName = "select" Then
Dim index As Integer = Convert.ToInt32(e.CommandArgument)
Dim row As GridViewRow = ????.Rows(index)
[Code]....
When "btnEdit" is clicked, "RowCommand" event is raised where I want to the catch row index of the row which was set to Edit mode.The Reason for doing this is ......I am using paging with page size = 4. When I click the fourth row (suppose), page is postedback and then the user has to scrolldown to get to the edit row
i have this code to add columns to GV from TXT
if (GridView2.Rows.Count == 0)
{
dt = MakeTable();
}
else
{
[CODE]...
and this code to delete from grideview
Event : rowdeleting
dt.Rows.RemoveAt((e.RowIndex));
GridView2.DataSource = dt;
GridView2.DataBind();
but when prss delete
error : There is no row at position 0. (if delete first row )
error : There is no row at position 1. (if delete second row )
I have one button and gridview.
The button is located at the outside of gridview.
By clicking the button, I want to trigger the RowCommand event in that grid.
Obviously, I know that I can create same function to run it in that button to achieve samething in the RowCommand event.
However, I would like to know that techinically, I can simply trigger the RowCommand event from outside of GridView.
In my database table I have ID,FirstName,LastName,Address fields.I have bound the FirstName,LastName in Gridview with Eval Method.But have not bound the address coz I m not dispalying address.Now there are textboxes below the gridview which gets filled when I click the edit button in gridview with values in the gridvoew row.I am getting the FirstName and LastName (using find control in rowcommand) but not the address.How can I get the address
View 3 Repliesi am using gridview for data manipulation. in gridview i have added a Edit and a delete button as a template field like
<asp:TemplateField HeaderText="Edit">
I'm trying to fire the RowCommand event on a DataGrid control. I've previously done that, but not in this precise case.
Actually I'm working on someone else code so I can't really change the structure of his page excepted if it's really necessary.
The code of the page is heavy, so I've summarized the problem in a small project and the page behaves the same way too.
Basically I have a GridView which I bind to a DataSet. According to those data, I sometimes need to add, at the end of a row, a "Details" button (a LinkButton).
By pushing this button, I want to show a second GridView containing those details.
Let's add to this that the columns number of the first GridView is variable, those LinkButton need to be added dynamically.
The first GridView is generated without any problem and when my mouse is over one of the LinkButton, I can see that the link is something like "javascript:__doPostBack('dataGridView$ctl02$lnkDetail','')". When I click on this link and debug step by step : Page_Init, Page_Load, OnPrerender, RowDataBound but no RowCommand, and I don't know why!
In the exemple, I've explicitly set the EnableViewState to true from what I've read here and there, but nothing's changed.
[code]...
And the code of my .aspx :
[Code]....
It has to do with the RowCommand 'Cancel'. When clicking on my Edit button for a row, the GridView puts the row into edit mode without a problem (I have no code for the Edit command, I let the control do everything).
Once in Edit mode, if I click the Cancel button (again, I have no code handline this RowCommand, I let the control handle it (like i do with many other GridViews)) I get the following exception:
"System.InvalidOperationException: Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control."
I'm having a hard time figuring this one out, i got a gridview with a sqldatasource that is loading its content, to custom columns a ButtonField and a Boundfield, both are loading in page load event,When i click the ButtonField its trigerring the rowcommand event but i can't figure out how to read the value of the cells wich i need to get for the next step of the program.Here what i got so far :- The aspx
[Code]....
- the aspx.vb
[Code]....
I'm getting the correct index and command name but i cant get the button value or bound field value either.
i am using a grid view . i have added a linkbutton in cell[0]. when clicking on this butoon the below event is working.. actually i tried to get the cell[1].text... but not getting any cell values except cell[0].text... get the cell[1].text value.
protected void grvSchedule_RowCommand(object sender,
GridViewCommandEventArgs e)
{ if (Convert.ToInt32(e.CommandArgument) == 1)
{LinkButton lbt = (LinkButton)e.CommandSource;
GridViewRow grvRow = (GridViewRow)((DataControlFieldCell)lbt.Parent).Parent;
txtTime.Text = grvRow.Cells[0].Text;
//txtTime.Text = grvRow.Cells[1].Text;
mvwApp.ActiveViewIndex = 1;
FillToSavePage();
hfdConsId.Value = ddlConsultant.SelectedValue.Trim();
}
}
i tried something like this but did not work:
GridViewRow row = (GridViewRow)(((Repeater)e.CommandSource).NamingContainer);
Repeater _rpt1 = row.Cells[8].FindControl("rptReg") as Repeater;
error:
Unable to cast object of type 'System.Web.UI.WebControls.Button' to type 'System.Web.UI.WebControls.Repeater'.
is there a way i can have the below code in `OnRowCommand` event using GridView?
actually i am trying to delete the row from the gridview control and when the user click on it and i am grabbing the mulitple ids and passing to SP and update the table and `databind the gridview`
GridViewRow row = gv.SelectedRow;
Repeater _rpt = gv.Rows[e.RowIndex].Cells[8].FindControl("rptReg") as Repeater;
Repeater _rpt1 = gv.Rows[e.RowIndex].Cells[9].FindControl("rptVisitor") as Repeater;
foreach (RepeaterItem item in _rpt.Items)
{
TextBox _txt = item.FindControl("txtId") as TextBox;
TextBox _txt1 = item.FindControl("txtName") as TextBox;
//update db
}
get the current selected row in the RowCommand event of a GridView in asp.net. The GridView has a button in an Item Template as shown below,
[Code]....
that I can pass values from GridView to a page. I tried following code but I could
not get the row number.
I have two gridviews tied to a SQL backend both being displayed within an update panel. Both the gridviews have a linkbutton connected to a rowcommand. When clicking on one of the rowcommand link buttons, the database is updated and the update panel is refreshed (moving the record to be displayed in the other gridview in the panel). However, when the rowcommand from the other gridview is clicked, the code is run and the database is updated, but the update panel is NOT refreshed.I have debugged it and have found that the code is running as expected. It fires off the function and updates the database. If I click away from the page and then go back, it does show the data in the proper gridviews, so I know that the code is working.
View 3 RepliesI have a gridview with Action button. When this button is clicked Javascript Confirm Popup will Display, after click on OK the Event have to fire GridviewRowCommand but the strange thing is: when the button is clicked, the rowcommand method is NOT fired! When I place the code on a separate page the event is fired, but when placed inside the tabcontainer for some reason it isnt...
View 7 RepliesI have a gridview with a button. When the button is clicked another gridview should show up showing some details of the clicked row.The strange thing is: when the button is clicked, the rowcommand method is NOT fired! When I place the code on a separate page the event is fired, but when placed inside the tabcontainer for some reason it isnt...
<%@ Page Title="Eventmanagement" ValidateRequest="false" Language="VB" MasterPageFile="~/main.master" AutoEventWireup="false" CodeFile="eventmanager.aspx.vb" Inherits="eventmanager" %>
<asp:UpdatePanel ID="UpdatePanel2" runat="server">
<ContentTemplate>
<cc1:TabContainer OnActiveTabChanged="TabChanged" ID="tabContainer" runat="server" ActiveTabIndex="0" OnClientActiveTabChanged="ActiveTabChanged" Width="100%">.............