为了账号安全,请及时绑定邮箱和手机立即绑定

sqlparamter与Unicode

sqlparamter与Unicode

守候你守候我 2018-12-06 19:25:19
 insert into tbNewWordInfo values('university',N'ˌjuːnɪˈvɜː(r)səti'')请教下这个sql插入语句怎样用sqlparameter来写参数?  直接用sql语句插入不会乱码,但是用sqlParameter怎样来写?
查看完整描述

1 回答

?
慕标5832272

TA贡献1966条经验 获得超4个赞

 #region private
        private int iD;
        private int projectID;
        private string category;
        private decimal unitPrice;
        #endregion
        #region public
        public int ID
        {
            get { return iD; }
            set { iD = value; }
        }

        public int ProjectID
        {
            get { return projectID; }
            set { projectID = value; }
        }

        public string Category
        {
            get { return category; }
            set { category = value; }
        }

        public decimal UnitPrice
        {
            get { return unitPrice; }
            set { unitPrice = value; }
        }

        #endregion

        /// <summary>
        /// 添加ys
        /// </summary>
        /// <param name="steelUintPrice">ys</param>
        /// <returns>最新编号</returns>
        public int Add()
        {
            string sql = @"INSERT INTO SteelUintPrice(ProjectID,Category,UnitPrice)
     values(@ProjectID,@Category,@UnitPrice);
     SELECT SCOPE_IDENTITY();";

            SqlParameter[] para = new SqlParameter[]
    {
     new SqlParameter("@ProjectID",SqlDbType.Int,4),
     new SqlParameter("@Category",SqlDbType.NVarChar,50),
     new SqlParameter("@UnitPrice",SqlDbType.Decimal,9)
    };
            int i = 0;
            para[i++].Value = ProjectID;
            para[i++].Value = Category;
            para[i++].Value = UnitPrice;

            return Convert.ToInt32(DbHelperSQL.GetSingle(sql, para));
        }

查看完整回答
反对 回复 2019-01-07
  • 1 回答
  • 0 关注
  • 555 浏览
慕课专栏
更多

添加回答

举报

0/150
提交
取消
意见反馈 帮助中心 APP下载
官方微信