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;
ScriptManager.RegisterStartupScript(this, this.GetType(), "RunCode", "javascript:alert('Successfully Counters Reset to Zero');", true);
}