ASP.NET C# Code button in gridview

Question

Hi all I have a GridView (GridView1) I have added a column and insert a button:

<asp:GridView ID="GridView1" runat="server" AllowPaging="True" 
            AutoGenerateColumns="False" DataSourceID="ObjectDataSource2" 
            onselectedindexchanged="GridView1_SelectedIndexChanged" Width="798px">
            <Columns>
                .....
                <asp:ButtonField ButtonType="Button" CommandName="cmdFlag" Text="Flag" />
            </Columns>
        </asp:GridView>

Basically on click of the button I want to run a SQL Update but cant seem to click the button to enter C# and add the query. I can get in the C# for the page but unsure what to write for the method.

Heres the C# Code:

 void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "cmdFlag")
        {
        con.Open();

        cmd = new SqlCommand("UPDATE Comments SET Flagged = '" + "Yes" + "'", con); 

        cmd.ExecuteNonQuery();


        }

    }

Its doing nothing though. Basically I need it to look at the row and if the flagged button is clicked, update the comment to "Yes" under flagged.

Anuraj · Accepted Answer · 2011-04-06 09:57:53Z

2

You won't get a direct event. You need to write code on the RowCommand event.

void GridView1_RowCommand(Object sender, GridViewCommandEventArgs e)
{
    if(e.CommandName=="cmdFlag")
        {
        //Write code update database
    }
}

Also you need to modify the GridView control. Add event like this.

onrowcommand="GridView1_RowCommand"

You can get more info here

edited Apr 6, 2011 at 9:57

answered Apr 6, 2011 at 9:30

Anuraj

19.6k7 gold badges61 silver badges84 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Mark Over a year ago

Hiya Thanks for that I have added it but its not doing what I want. Can you look at my post again I have updated it with more info.

Mark Over a year ago

Thanks mate it now does something but updates all the rows I think I need a WHERE statement just not to sure how to write it in terms of where that row only any ideas? I have a field for Comment_ID if that helps.

Anuraj Over a year ago

You need to get the value by Row.Cells[] or you can do a find control.

Ahmed Magdy · Accepted Answer · 2011-04-06 10:24:08Z

0

If you want to add the ID to use it in your WHERE statement you can put it into CommandArgument like

<asp:ButtonField ButtonType="Button" CommandName="cmdFlag" Text="Flag" CommandArgument='<%# Eval("Comment_ID") %>' />

then in the code you can get it from

var id = e.CommandArgument.ToString();

Update: just updated the code

answered Apr 6, 2011 at 10:24

Ahmed Magdy

6,0888 gold badges46 silver badges77 bronze badges

2 Comments

Mark Over a year ago

Hiya I added the code you put but I get the error: Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control.

Ahmed Magdy Over a year ago

try to replace CommandArgument='<%# Eval("Comment_ID") %>' with CommandArgument="Comment_ID"

painotpi · Accepted Answer · 2011-04-09 07:49:44Z

0

Register the event-handler in your code-behind file by doing this

GridView1.RowCommand += new GridViewCommandEventHandler(GridView1_RowCommand);

and add this in you aspx page

OnRowCommand="GridView1_RowCommand"

edited Apr 9, 2011 at 7:49

answered Apr 6, 2011 at 10:08

painotpi

7,0122 gold badges40 silver badges72 bronze badges

Comments

Off The Gold · Accepted Answer · 2016-02-23 15:23:31Z

0

You have forgot to add OnRowCommand="GridView1_RowCommand" on your Gridview, that's why it is not firing the RowCommand Event.

<asp:GridView ID="GridView1" runat="server" OnRowCommand="GridView1_RowCommand" AllowPaging="True" 
        AutoGenerateColumns="False" DataSourceID="ObjectDataSource2" 
        onselectedindexchanged="GridView1_SelectedIndexChanged" Width="798px">

edited Feb 23, 2016 at 15:23

Off The Gold

1,23615 silver badges28 bronze badges

answered Apr 6, 2011 at 10:00

Muhammad Akhtar

52.2k37 gold badges142 silver badges191 bronze badges

Collectives™ on Stack Overflow

ASP.NET C# Code button in gridview

4 Answers 4

3 Comments

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related