public void AddRecord() { try { string Sql = "Select KeyId from KeywordInformation where KeywordName='" + txtKeyword.Text + "' "; string KeyId = Convert.ToString(cc.ExecuteScalar(Sql)); if (KeyId == "" || KeyId == null) { 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.AddInfo(KBLL); if (status == 1) { LoadData(); Clear(); Response.Write("<script>alert('Record Inserted.............!')</script>"); } else { } } } catch (Exception ex) { } }