//执行含参数的存储过程
System.Data.Common.DbParameter[] parasphoto = {
new System.Data.SqlClient.SqlParameter("@EmployeeId",System.Data.DbType.Guid)
};
parasphoto[0].Value = "D35F313D-7322-4989-BB23-1C96130D61DF"; Response.Write(_db.ExecuteScalar("GetEmployeePhoto", parasphoto));ALTER PROCEDURE [dbo].[GetEmployeePhoto]
(
@EmployeeId uniqueidentifier
)AS
SELECT Photo FROM Employees WHERE EmployeeId=@EmployeeId
RETURN [InvalidCastException: 对象必须实现 IConvertible。]
System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider) +7598841
System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType) +4872946[InvalidCastException: 将参数值从 SqlParameter 转换到 Guid 失败。]如上所示,请教大家
无法转换吧? 用1L试试