代码 如下
public SpotAreaModel GetSpotAreaById(string Scenic_Area_No)
{
SpotAreaModel model = new SpotAreaModel();
string query = "select AREA_NO,SCENIC_AREA_NO,SCENIC_AREA_NAME,VALIDITY_FLG,CREATE_USER,CREATE_DATE,MODIFIED_USER,MODIFIED_DATE,SCENIC_AREA_CONTENT,SCENIC_LATITUDE,SCENIC_LONGITUDE,WORD_BOOK_NO,SCENIC_IMG from M_SCENIC_AREA where SCENIC_AREA_NO=@No";
SqlParameter pNo = new SqlParameter("@No", SqlDbType.VarChar, 50);
pNo.Value = Scenic_Area_No;
using (SqlDataReader reader = SqlHelper.ExecuteReader(
connectionString,
CommandType.Text,
query,
pNo
))
{
while (reader.Read())
{
model.Area_no = reader.GetString(0);
model.Scenic_area_no = reader.GetString(1);
model.Scenic_area_name = reader.GetString(2);
model.Validity_flg = reader.IsDBNull(3) ? "" : reader.GetString(3);
model.Create_user = reader.GetString(4);
model.Create_date = reader.GetDateTime(5);
model.Modified_user = reader.GetString(6);
model.Modified_date = reader.GetDateTime(7);
model.Scenic_Area_Content = reader.IsDBNull(8) ? "" : reader.GetString(8);
model.SpotAreaLatutude = reader.IsDBNull(9) ? 0 : reader.GetDecimal(9);
model.SpotAreaLongitude = reader.IsDBNull(10) ? 0 : reader.GetDecimal(10);
model.SpotAreaTypeNO = reader.IsDBNull(11) ? "" : reader.GetString(11);
//不确定 实验中 数据库中 是image 类型。。
model.SpotAreaImg = reader.IsDBNull(12)? null: reader.
}
}
return model;
}
---------------------------------------------------------------------------------------------------
//不确定 实验中
model.SpotAreaImg = reader.IsDBNull(12)? null: reader.
这行代码 reader后面 接什么 image 类型 对应的 是什么
public SpotAreaModel GetSpotAreaById(string Scenic_Area_No)
{
SpotAreaModel model = new SpotAreaModel();
string query = "select AREA_NO,SCENIC_AREA_NO,SCENIC_AREA_NAME,VALIDITY_FLG,CREATE_USER,CREATE_DATE,MODIFIED_USER,MODIFIED_DATE,SCENIC_AREA_CONTENT,SCENIC_LATITUDE,SCENIC_LONGITUDE,WORD_BOOK_NO,SCENIC_IMG from M_SCENIC_AREA where SCENIC_AREA_NO=@No";
SqlParameter pNo = new SqlParameter("@No", SqlDbType.VarChar, 50);
pNo.Value = Scenic_Area_No;
using (SqlDataReader reader = SqlHelper.ExecuteReader(
connectionString,
CommandType.Text,
query,
pNo
))
{
while (reader.Read())
{
model.Area_no = reader.GetString(0);
model.Scenic_area_no = reader.GetString(1);
model.Scenic_area_name = reader.GetString(2);
model.Validity_flg = reader.IsDBNull(3) ? "" : reader.GetString(3);
model.Create_user = reader.GetString(4);
model.Create_date = reader.GetDateTime(5);
model.Modified_user = reader.GetString(6);
model.Modified_date = reader.GetDateTime(7);
model.Scenic_Area_Content = reader.IsDBNull(8) ? "" : reader.GetString(8);
model.SpotAreaLatutude = reader.IsDBNull(9) ? 0 : reader.GetDecimal(9);
model.SpotAreaLongitude = reader.IsDBNull(10) ? 0 : reader.GetDecimal(10);
model.SpotAreaTypeNO = reader.IsDBNull(11) ? "" : reader.GetString(11);
//不确定 实验中 数据库中 是image 类型。。
model.SpotAreaImg = reader.IsDBNull(12)? null: reader.
}
}
return model;
}
---------------------------------------------------------------------------------------------------
//不确定 实验中
model.SpotAreaImg = reader.IsDBNull(12)? null: reader.
这行代码 reader后面 接什么 image 类型 对应的 是什么
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货