無法將‘System.DBNull’類型的對象轉(zhuǎn)換為‘System.String’我在我的應用程序中得到了上面的錯誤。這是原始代碼public string GetCustomerNumber(Guid id){
string accountNumber =
(string)DBSqlHelperFactory.ExecuteScalar(connectionStringSplendidmyApp,
CommandType.StoredProcedure,
"GetCustomerNumber",
new SqlParameter("@id", id));
return accountNumber.ToString();
}我用public string GetCustomerNumber(Guid id){
object accountNumber =
(object)DBSqlHelperFactory.ExecuteScalar(connectionStringSplendidCRM,
CommandType.StoredProcedure,
"spx_GetCustomerNumber",
new SqlParameter("@id", id));
if (accountNumber is System.DBNull)
{
return string.Empty;
}
else
{
return accountNumber.ToString();
}}有什么更好的辦法嗎？
3 回答
- 3 回答
- 0 關(guān)注
- 853 瀏覽
添加回答
舉報
0/150
提交
取消