Dupilcate record RSS

• • Reply
  

  Fabienne

  Member

  11 Points

  6 Posts

  Dupilcate record

  May 05, 2011 07:07 AM|LINK

  Hey there !

  I need to create staff. But how do I check for duplicate data and it will display error message when inserting record?

  • Moved by ignatandrei on May 05, 2011 07:09 AM
• • Reply
  

  vinz

  All-Star

  128470 Points

  18149 Posts

  MVP

  Re: Dupilcate record

  May 05, 2011 08:40 AM|LINK

  Here's one way:

  private void CheckIfExist(string field)
  {
  
      SqlConnection conn = new SqlConnection("Your Connection String");
      DataTable dt = new DataTable();
      try
      {
          conn.Open();
         
          String sql = "SELECT * FROM TableName WHERE FieldName= @Field";
          SqlCommand cmd = new SqlCommand(sql, conn);
          cmd.Parameters.AddWithValue("@Field",field);
          SqlDataAdapter ad = new SqlDataAdapter(cmd);
          ad.Fill(dt);
  
          if (dt.Rows.Count > 0)
          {
              Label1.Text = "Already Exist";
          }
          else
          {
              Label1.Text = "Available";
              //CALL the INSERT method here and pass its parameter values
              InsertInfo("value1","Value2","Value3");
          }
      }
      finally
      {
         conn.Close();
      }
         
  }
  
  private void InsertInfo(string strValue1, string strValue2, string strValue3)
  {
  
         SqlConnection conn = new SqlConnection("YOUR CONNECTION STRING");
         string sql = "INSERT INTO TableName (ColumnName1,ColumnName2,ColumnName3) VALUES (@Val1,@Val2,@Val3)";
         try
         {
             conn.Open();
             SqlCommand cmd = new SqlCommand(sql, conn);
             cmd.Parameters.AddWithValue("@Val1", strValue1);
             cmd.Parameters.AddWithValue("@Val2", strValue2);
             cmd.Parameters.AddWithValue("@Val3", strValue3);
             cmd.CommandType = CommandType.Text;
             cmd.ExecuteNonQuery();
         }
         finally
         {
         conn.Close();
         }
  
  }
  
  
  protected void Button1_Click(object sender, EventArgs e)
  {
      string field = "SomethingToCompare";
      CheckIfExist(field);
  }

  Vincent Maverick Durano, MVP
  MessageBox Controls for WebForms | Blog | Twitter | Linkedin
  
  • Marked as answer by Fabienne on May 06, 2011 07:59 AM
• • Reply
  

  Fabienne

  Member

  11 Points

  6 Posts

  Re: Dupilcate record

  May 09, 2011 09:52 AM|LINK

  thank u very much yeah :D