C#和数据库查询是否有重复值时分大小写方法

区分传入值如果一致则提示重复

string ruleName = txtGlueName.Text.Trim().ToUpper();
传入文本框的值使用ToUpper()将其改为大写
数据库RULE_NAME字段的值也改为大写
然后两者比对

 调用参数
DataTable dt = conn.GetRuleName(ruleName);
public DataTable GetRuleName(string ruleName)
        {
            return dal.GetRuleName(ruleName);
        }
public DataTable GetRuleName(string glueName)
        {
            //区分大小写检查 规则名称UPPER by20210406shinecao
            string sql = string.Format(@"SELECT * FROM IMES.M_GLUE_BARCODE_RULE WHERE UPPER(RULE_NAME) = '{0}' AND ENABLED='Y' ", glueName);
            return utility.Query(sql);
        }

C#验证文本框KeyPress是否回车

   if (e.KeyChar != 13)
            {
                return;
            }

C#winform中textbox文本框大写

属性CharacterCasing属性改为ToUpper即可