主题:vb.net 做的cs模式软件
做了个实体类,想将数据添加到数据库,可是在添加Sqlparameter参数时出错,
Dim param() As SqlParameter
param = New SqlParameter("@Name", SqlDbType.VarChar, 20).Value = Ent.Name
param = New SqlParameter("@Sex", SqlDbType.VarChar, 2).Value = Ent.Sex
param = New SqlParameter("@Birthday", SqlDbType.SmallDateTime).Value = Ent.Birthday
param = New SqlParameter("@MTel", SqlDbType.VarChar, 11).Value = Ent.MTel
param = New SqlParameter("@HTel", SqlDbType.VarChar, 13).Value = Ent.HTel
param = New SqlParameter("@QQ", SqlDbType.VarChar, 14).Value = Ent.QQ
param = New SqlParameter("@E_mail", SqlDbType.VarChar, 50).Value = Ent.E_mail
param = New SqlParameter("@Releation", SqlDbType.VarChar, 20).Value = Ent.Releation
param = New SqlParameter("@Images", SqlDbType.VarChar, 20).Value = Ent.Images
param = New SqlParameter("@Address", SqlDbType.VarChar, 100).Value = Ent.Address
param = New SqlParameter("@Postcode", SqlDbType.VarChar, 5).Value = Ent.Postcode
param = New SqlParameter("@Memo", SqlDbType.VarChar, 300).Value = Ent.Memo
Return (dbproce.executeSql(storeName, param))
错误提示为:
无法将类型为“System.Boolean”的对象强制转换为类型“System.Data.SqlClient.SqlParameter[]”。
请问该如何写?
Dim param() As SqlParameter
param = New SqlParameter("@Name", SqlDbType.VarChar, 20).Value = Ent.Name
param = New SqlParameter("@Sex", SqlDbType.VarChar, 2).Value = Ent.Sex
param = New SqlParameter("@Birthday", SqlDbType.SmallDateTime).Value = Ent.Birthday
param = New SqlParameter("@MTel", SqlDbType.VarChar, 11).Value = Ent.MTel
param = New SqlParameter("@HTel", SqlDbType.VarChar, 13).Value = Ent.HTel
param = New SqlParameter("@QQ", SqlDbType.VarChar, 14).Value = Ent.QQ
param = New SqlParameter("@E_mail", SqlDbType.VarChar, 50).Value = Ent.E_mail
param = New SqlParameter("@Releation", SqlDbType.VarChar, 20).Value = Ent.Releation
param = New SqlParameter("@Images", SqlDbType.VarChar, 20).Value = Ent.Images
param = New SqlParameter("@Address", SqlDbType.VarChar, 100).Value = Ent.Address
param = New SqlParameter("@Postcode", SqlDbType.VarChar, 5).Value = Ent.Postcode
param = New SqlParameter("@Memo", SqlDbType.VarChar, 300).Value = Ent.Memo
Return (dbproce.executeSql(storeName, param))
错误提示为:
无法将类型为“System.Boolean”的对象强制转换为类型“System.Data.SqlClient.SqlParameter[]”。
请问该如何写?