protected void Approve_Command(object sender, CommandEventArgs e) { anm_Utility ut = new anm_Utility(); string[] commandArgs = e.CommandArgument.ToString().Split(new char[] { ',' }); string idc = commandArgs[0]; string idn = commandArgs[1]; string value = commandArgs[2]; //string approve = commandArgs[3]; string approve = ""; int nc = ut.GetCommentsNews(idn); string strConn = ConfigurationManager.ConnectionStrings["anmcs"].ToString(); SqlConnection myConnection = new SqlConnection(strConn); SqlCommand myCommand = new SqlCommand(); myCommand.Connection = myConnection; myConnection.Open(); myCommand.CommandText = "SELECT approved FROM anm_Comments WHERE idcomment=" + idc; SqlDataReader reader = myCommand.ExecuteReader(); while (reader.Read()) { approve = reader["approved"].ToString(); } myConnection.Close(); ut.ApproveComment(idc, value); if (value == "true" && approve == "False") { ut.IcreaseComments(idn, nc + 1); } else if (value == "false" && approve == "True") { ut.IcreaseComments(idn, nc - 1); } Response.Redirect(Page.Request.Url.AbsolutePath.ToString() + "?p=AdminComments"); }