public void Update(string Id) { try { string Sql = "Select KeyId from KeywordInformation where KeywordName='" + txtKeyword.Text + "' and keyId<>" + Id + ""; string KeyId = Convert.ToString(cc.ExecuteScalar(Sql)); if (KeyId == "" || KeyId == null) { KBLL.KeyId1 = Convert.ToInt64(Id); KBLL.KeywordName1 = Convert.ToString(txtKeyword.Text); KBLL.KeywordSyntax1 = Convert.ToString(txtSyntax.Text); KBLL.KeywordPurpose1 = Convert.ToString(txtPurpose.Text); KBLL.KeyDiscip1 = Convert.ToString(txtDiscrip.Text); KBLL.WebsiteGroup1 = Convert.ToString(ddlWebSite.SelectedValue); KBLL.EntryDate1 = Convert.ToString(DateFormat); int status = KBLL.UpdateInfo(KBLL); if (status == 1) { LoadData(); Clear(); Response.Write("<script>alert('Record Updated.............!')</script>"); } else { } } } catch (Exception ex) { } }