有趣--用参数对象插入数据库NText列的怪事儿

[johnlenfu]

insert_sql = "insert into equipment_accessory(name,description,isactive) values("
insert_sql += "@AccessoryName,"
insert_sql += "@Description,"
insert_sql += "@Enable);"
================================================================


SqlDBCmd.CommandText = insert_sql
'B=========================《參數定義及負值》=====================

SqlDBCmd.Parameters.Add(New SqlParameter("@Description", SqlDbType.NText, 16))

SqlDBCmd.Parameters("@Description").Value = txtDes.Text.ToString

断电调试的时候txtDes.Text.ToString的值是对的，可到了数据库里就只剩下开头的
一段，后面的都被截掉了，搞不懂，这个跟NTEXT类型有关吗？直接在查询分析器里查入是没有问题的

[xinyu_1980]

将:
SqlDBCmd.Parameters.Add(New SqlParameter("@Description", SqlDbType.NText, 16))
改为:
SqlDBCmd.Parameters.Add(New SqlParameter("@Description", SqlDbType.NText))

[johnlenfu]

搞定了，给分