public List<Catetgory> GetAllCatetgory()
{
string sql = "select CategoryId,CategoryName from Categories";
List<Catetgory>list = new List<Catetgory>();
SqlDataReader objReader = SQLHelper.GetReader(sql);
//循环读取并封装对象
while(objReader.Read())
{
list.Add(new Category()
{
CategoryId = Convert.ToInt32(objReader["CategoryId"]) ,
CategoryName = objReader["CategoryId"].ToString()
});
}
objReader.Close();
return list;
}
添加空白行
在业务逻辑中:


后台根据CategoryId=-1做判断,说明未选中任何内容