Judge the number of data in the database to update the number without inserting data? ?

ggggex

I am writing a popular search`
The idea is to use a SQL table to store search words that the user can find with a result greater than 1.
But one problem is that if the keyword already exists in the database, then it will not be repeated?
My code is written like this:

        int newcount = 1;
        try
        {
            SqlCommand upcount = new SqlCommand ("update aspnet_HotSearch set Count = Count + 1 Where KeyWord = '" + key + "'", mysqlSqlConnection);
            upcount.ExecuteNonQuery ();
        }
        catch
        {
            SqlCommand intoKey = new SqlCommand ("insert into aspnet_Hot (Key, Count) value ('" + key + "', '" + newcount + "')", mysqlSqlConnection);
            intoKey.ExecuteNonQuery ();
        }

But it's useless, so please tell me how to write
By the way, are there any better ideas for popular searches?

weh007

Write as a stored procedure, judge in the stored procedure

020800

How can you use try ... catch to judge, don't you be efficient?
Write insert and update as methods separately. Use IF to determine which to call

ggggex

Oops` I'm stupid ...

Can you write an example `

ray1111a

lz write a trigger to check whether the data to be inserted already exists at each insertion, and update the record if it exists

g406471857

Write a stored procedure, use the return value of the stored procedure to determine whether to update or insert

020800

Write 3 methods: find, update, insert
First use the search to determine whether it exists or not, generally it will return -1 if it does not exist, and it will return the number of found;
Then use
if (num ==-1) {insert;} else {update;}