Q. string strSql = "INSERT INTO TBL_GYOMUTANGO "; strSql += "(WORD) "; strSql += "VALUES('" +strKey + "')"; -->strKey 是汉字时,程序显示为乱码。 A. 使用Parameters解决乱码 string strSql = "INSERT INTO TBL_GYOMUTANGO "; strSql += "(WORD, COMMENT) "; strSql += "VALUES(@strKey,@strComment)"; SqlCommand cmd = new SqlCommand(strSql,conn,trans); cmd.Parameters.Add(new SqlParameter("@strKey",SqlDbType.VarChar,50)); cmd.Parameters.Add(new SqlParameter("@strComment",SqlDbType.NVarChar ,200)); cmd.Parameters["@strKey"].Value = strKey; cmd.Parameters["@strComment"].Value = strComment; //SqlCommand cmd = new SqlCommand(strSql,conn); cmd.CommandType = CommandType.Text; iRet = cmd.ExecuteNonQuery(); |
041006 A DB 乱码
最新推荐文章于 2023-10-11 17:53:07 发布