C#

protected void btnSubmit_Click(object sender, EventArgs e)
    {
        try
        {

            ErrorMessage.Text = "";
            cnx.Open();
            SqlCommand insertCmd = new SqlCommand("INSERT INTO TransactionType([Transaction],Description,Category,Active) VALUES(@Transaction,@Description,@Category,@Active)", cnx);
            insertCmd.Parameters.Add("@Transaction", SqlDbType.NVarChar, 50);
            insertCmd.Parameters["@Transaction"].Value = txtProgram.Text;

            insertCmd.Parameters.Add("@Description", SqlDbType.Text );
            insertCmd.Parameters["@Description"].Value = txtdescrip.Text;

            insertCmd.Parameters.Add("@Category", SqlDbType.NVarChar ,50);
            insertCmd.Parameters["@Category"].Value = DdlCategory.Text;

            insertCmd.Parameters.Add("@Active", SqlDbType.NChar ,10);
            insertCmd.Parameters["@Active"].Value = DdlActive.Text;

            insertCmd.ExecuteNonQuery();
            ErrorMessage.Text = "Successful";
            cnx.Close();
        }
        catch (Exception ex)
        { 
            ErrorMessage.Text = ex.Message;
        }
    }