How to Reset the Counter to Zero from Gridview in asp.net

How to reset the counter to zero in ASP.NET?

Dear Friends,

I have a ASP.NET button with the name RESET and a grid view below this button.
When I click on this reset button it should clear one column in the grid and it should set all the numbers to 0 (Zero).

In my database I have table called Linkcounter with fields as Counter and Links.
For example: this is my database table

Counter  Links
12       Home
15       About Us
12       Our Services
3        Contact Us

When I click on the reset button the counter values should reset to 0 (Zero).

Please help.

This is my code:

protected void Page_Load(object sender, EventArgs e)
    {

        if (!IsPostBack)
        {
            LoadGridCounterData();
        }

    }


    private void LoadGridCounterData()
    {
        SqlConnection con = new SqlConnection(_connString);
       
        
        SqlCommand cmd = new SqlCommand("Select Counter,link from linkcounter", con);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds);
        GVCounter.DataSource = ds;
        GVCounter.DataBind();
    }

This is code am facing problem (reset button code):

protected void ResetImgBtn_Click(object sender, ImageClickEventArgs e)
    {
        SqlConnection con = new SqlConnection(_connString);

        SqlCommand cmd = new SqlCommand();
        DataSet ds = new DataSet();
       cmd.CommandText = "Update LinkCounter Set Counter=0";
       
        cmd.Connection = con;
        con.Open();
        cmd.ExecuteNonQuery();
        con.Close();
        GVCounter.DataSource = ds;
     // GVCounter.DataBind();

        ScriptManager.RegisterStartupScript(this, this.GetType(), "RunCode", "javascript:alert('Successfully Counters Reset to Zero');", true);
    }

Tags: C#, ASP.NET, SQL Server