Example #1
0
 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)
     { }
 }