Check For similarity.

tanweeruddin beeharry

before inserting a paragraph in database, i need to check if the actual paragraph is similar to those in the database. If there is any similar paragraph i need display it. Am using asp.net c# webform and for database mssql.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rijwan Ansari5y ago
HI

You can do in this way.
using (SqlCommand cmd = new SqlCommand())
{
    cmd.Parameters.Clear();
    cmd.CommandText = "SELECT * FROM TableName WHERE paragraphcolumn=@paragraphcolumn;
    cmd.Parameters.AddWithValue("@email", txtParagraph.Text);//paragraph text
    cmd.Connection = con;
    con.Open();
    dr = cmd.ExecuteReader();
    con.Close();
}
if (dr.HasRows)
{
    lblMessage.Text = "Paragraph Already Exists";
    lblMessage.ForeColor = System.Drawing.Color.Red;
    mailtxtbx.Text = "";
    txtname.Text = "";
    lblsuccess.Visible = false;
    lblMessage.Visible = true;
}
0
Sachin Singh5y ago
1. public string CheckSimilarity(string paragrapgh)
2. {
3. using(Sqlconnection con= new Sqlconnection(cs))
4. {
5. SqlCommand cmd= new SqlCommand("select paraColumn from table",con);
6. con.Open();
7. SqlDataReader rdr=cmd.ExecuteReader();
8. while(rdr.Read())
9. {
10. if(String.Equals(rdr["paraColumn"].ToString(), paragraph))
11. {
12. return rdr["paraColumn"].ToString();
13. }
14. }
16. }
18. }
20. // display
21. paragraphTextBox.Text=CheckSimilarity(para)==null?"no match":CheckSimilarity(para)