相关代码:
string connStr = ConfigurationManager.ConnectionStrings["wzConnectionString"].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
string sqlStr = "select * from [wzclass] WHERE name=@name";
SqlCommand cmd = new SqlCommand(sqlStr, conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@name", SqlDbType.String);
cmd.Parameters[0].Value = ClassName.Text;
写的应该算是清楚吧?只是接下来不知道该怎么写了.....
就是想看看提交上来的ClassName.Text是否和数据库里wzClass表name字段相重复.