C#

using (SqlConnection connection = new SqlConnection(cs))
                {
                    SqlCommand cmd = new SqlCommand("SELECT * FROM table1 WHERE Reci='" + textBox1.Text + "'", connection);
                    try
                    {
                        connection.Open();
                        SqlDataAdapter da = new SqlDataAdapter(cmd);
                        DataSet ds = new DataSet();
                        da.Fill(ds);
                        int j = ds.Tables[0].Rows.Count;
                        if (j == 0)
                        {
                            MessageBox.Show("word" + textBox1.Text + "already exists!");
                            ds.Clear();
                        }
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message);
                    }
                }

private void uxRunCount_PreviewKeyDown( object sender, System.Windows.Input.KeyEventArgs e ) {

   bool ok = IsNumeric( e.Key );

   if ( !ok ) {
      e.Handled = true;    // Reject change.
   }
}

private bool IsNumeric( Key key ) {

   if ( key == Key.Back || key == Key.Delete ) { return true; }
   if ( key == Key.Tab || key == Key.Return ) { return true; }

   if ( key >= Key.D0 && key <= Key.D9 ) { return true; }
   if ( key >= Key.NumPad0 && key <= Key.NumPad9 ) { return true; }

   return false;
}

private void myTextBox_KeyPress(object sender, KeyPressEventArgs e)

char keyPressedByUser = e.KeyChar;

var allowedKeys = promesana_rec.Select(ch => (Keys)Convert.ToInt32(char.ToUpper(ch)));

e.SuppressKeyPress = !allowedKeys.Contains(e.KeyCode) && new[] { Keys.None, Keys.Shift }.Contains(e.Modifiers);

private string theWord = "extemporized".ToUpper();
...
private void myTextBox_KeyPress(object sender, KeyPressEventArgs e)
    {
    char keyPressedByUser = char.ToUpper(e.KeyChar);
    if (!theWord.Contains(keyPressedByUser))
        {
        e.Handled = true;
        return;
        }
    ...
    }

private Dictionary<char, int> letters;

letters = theWord.GroupBy(c => c).ToDictionary(g => g.Key, g => g.Count());

private void myTextBox_KeyPress(object sender, KeyPressEventArgs e)
    {
    if (char.IsLetter(e.KeyChar))
        {
        char keyPressedByUser = char.ToUpper(e.KeyChar);
        if (!theWord.Contains(keyPressedByUser))
            {
            e.Handled = true;
            return;
            }
        int inputCount = myTextBox.Text.ToUpper().Where(c => c == keyPressedByUser).Count() + 1;
        if (inputCount > letters[keyPressedByUser])
            {
            e.Handled = true;
            return;
            }
        e.Handled = false;
        }
    }

private Dictionary<char, int> letters;
        private void textBox1_KeyPress(object sender, KeyPressEventArgs e)
        {
            letters = promesana_rec.GroupBy(c => c).ToDictionary(g => g.Key, g => g.Count());
            if (char.IsLetter(e.KeyChar))
            {
                char keyPressedByUser = char.ToUpper(e.KeyChar);
                if (!promesana_rec.Contains(keyPressedByUser))
                {
                    e.Handled = true;
                    return;
                }
                int inputCount = textBox1.Text.ToUpper().Where(c => c == keyPressedByUser).Count() + 1;
                if (inputCount > letters[keyPressedByUser])
                {
                    e.Handled = true;
                    return;
                }
                e.Handled = false;
            }
         }