public Model.Home GetOneHome(int HomeID)
{//根本ID得到单条记录
Model.Home HomeInfo = new Model.Home();
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,classid,title,content,addtime,Uid ");
strSql.Append(" from Home ");
strSql.Append(" where id= " + HomeID);
SqlConnection cn;
SqlDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, strSql.ToString(), out cn); while (reader.Read())
{
HomeInfo.id = reader.GetInt32(reader.GetOrdinal("id"));
HomeInfo.classid = reader.GetInt32(reader.GetOrdinal("classid"));
HomeInfo.title = reader.GetString(reader.GetOrdinal("title"));
HomeInfo.content = reader.GetString(reader.GetOrdinal("content"));
HomeInfo.addtime = reader.GetDateTime(reader.GetOrdinal("addtime"));
HomeInfo.Uid = reader.GetString(reader.GetOrdinal("Uid"));
}
if (cn != null)
{
cn.Close();
cn.Dispose();
}
return HomeInfo;
} public Model.Home GetOneBill(int HomeID)
{//得到单条ID,用DataSet
Model.Home HomeInfo = new Model.Home();
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,classid,title,content,addtime,Uid ");
strSql.Append(" from Home ");
strSql.Append(" where id= " + HomeID);
DataSet reader = SqlHelper.ExecuteDataSet(CommandType.Text, strSql.ToString(), null); DataTable dt = reader.Tables[0];
if (dt.Rows.Count > 0)
{
HomeInfo.id = Convert.ToInt32(dt.Rows[0]["id"]); HomeInfo.classid = Convert.ToInt32(dt.Rows[0]["classid"]);
HomeInfo.title = dt.Rows[0]["title"].ToString();
HomeInfo.content = !string.IsNullOrEmpty(dt.Rows[0]["content"].ToString()) ? dt.Rows[0]["content"].ToString() : "nopic.jpg";
HomeInfo.addtime = Convert.ToDateTime(dt.Rows[0]["addtime"]);
HomeInfo.Uid = dt.Rows[0]["Uid"].ToString(); }
return HomeInfo;
}
{//根本ID得到单条记录
Model.Home HomeInfo = new Model.Home();
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,classid,title,content,addtime,Uid ");
strSql.Append(" from Home ");
strSql.Append(" where id= " + HomeID);
SqlConnection cn;
SqlDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, strSql.ToString(), out cn); while (reader.Read())
{
HomeInfo.id = reader.GetInt32(reader.GetOrdinal("id"));
HomeInfo.classid = reader.GetInt32(reader.GetOrdinal("classid"));
HomeInfo.title = reader.GetString(reader.GetOrdinal("title"));
HomeInfo.content = reader.GetString(reader.GetOrdinal("content"));
HomeInfo.addtime = reader.GetDateTime(reader.GetOrdinal("addtime"));
HomeInfo.Uid = reader.GetString(reader.GetOrdinal("Uid"));
}
if (cn != null)
{
cn.Close();
cn.Dispose();
}
return HomeInfo;
} public Model.Home GetOneBill(int HomeID)
{//得到单条ID,用DataSet
Model.Home HomeInfo = new Model.Home();
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,classid,title,content,addtime,Uid ");
strSql.Append(" from Home ");
strSql.Append(" where id= " + HomeID);
DataSet reader = SqlHelper.ExecuteDataSet(CommandType.Text, strSql.ToString(), null); DataTable dt = reader.Tables[0];
if (dt.Rows.Count > 0)
{
HomeInfo.id = Convert.ToInt32(dt.Rows[0]["id"]); HomeInfo.classid = Convert.ToInt32(dt.Rows[0]["classid"]);
HomeInfo.title = dt.Rows[0]["title"].ToString();
HomeInfo.content = !string.IsNullOrEmpty(dt.Rows[0]["content"].ToString()) ? dt.Rows[0]["content"].ToString() : "nopic.jpg";
HomeInfo.addtime = Convert.ToDateTime(dt.Rows[0]["addtime"]);
HomeInfo.Uid = dt.Rows[0]["Uid"].ToString(); }
return HomeInfo;
}
使用DataAdapter取代DataSet提升的性能表现为节省了DataSet占用内存和填充DataSet需要的循环。一般来说,此性能提升只是象征性的
用于fill DataSet 和更新 SQL 数据库的“一组”数据命令和“一个”数据库连接。
SqlDataAdapter不但可以操作多个SQL命令,而且还可以操作一个SQL命令。
SqlDataReader与SqlCommand一起使用的:
用于SQL 数据库执行的“一个”SQL 语句或存储过程。SqlCommand只能操作一个SQL命令,不能更新。
对于楼主,一条是可以替代的,多条就不行。查询功能2个都有这个功能啦!
SqlDataReaderDataReader提供快速、仅向前、只读数据,不能更新,编辑。