.NET准换int失败，求教

显示全部楼层 · 2013-3-18 17:08:56

List list = new List();
SqlParameter para = new SqlParameter("@id", SqlDbType.Int) { Value = id }; //new SqlParameter("@id", id);
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "sp_select_singer_inf...

千问 · 2013-3-18 17:08:56

先判断那个字段是否为空然后再用int.TryParse()函数判断是否是整数string teststr=“1”;int testa=0;if(int.TryParse(teststr,out testa)){需要的值就是 testa；}...

千问 · 2013-3-18 17:08:56

SqlParameter para = new SqlParameter("@id", id);是不是你的参数是int类型那你就转换一下SqlParameter para = new SqlParameter("@id", DbType.Int32,Convert.ToInt32(id));...

千问 · 2013-3-18 17:08:56

报错的是这句吗？using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "sp_select_singer_info_name_id", para))如果...