protected void OnRowDeleting(object sender, GridViewDeleteEventArgs e) { int ResourcesId = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0]); string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString; //using (SqlConnection con = new SqlConnection(constr)) //{ // using (SqlCommand cmd = new SqlCommand("Resources_CRUD")) // { // cmd.CommandType = CommandType.StoredProcedure; // cmd.Parameters.AddWithValue("@Action", "DELETE"); // cmd.Parameters.AddWithValue("@ResourcesId", ResourcesId); // cmd.Connection = con; // con.Open(); // cmd.ExecuteNonQuery(); // con.Close(); // } //} client = new CRUD_SPClient(); if (client.Delete(ResourcesId)) { this.BindGrid(client.DoWork().ToList()); } client.Close(); // this.BindGrid(); }