DataTable dt = DBHelper.GetDataSet(sql);
List<AccessoryFile> lists = new List<AccessoryFile>(); AccessoryFile accessoryFile = null;
foreach (DataRow row in dt.Rows)
{
accessoryFile = new AccessoryFile();
accessoryFile.AccessoryId = (int)row["AccessoryId"];
accessoryFile.AccessoryName = row["AccessoryName"].ToString();
accessoryFile.AccessoryPath = row["AccessoryPath"].ToString();
accessoryFile.AccessorySize = (int)row["AccessorySize"];
accessoryFile.CreateDate = Convert.ToDateTime(row["CreateDate"].ToString());
int fileId=(int)row["FileId"];
int fileTypeId = (int)row["AccessoryType"];
accessoryFile.FileInfo = FileInfoService.GetFileInfoByFileId(fileId);
accessoryFile.FileTypeInfo = FileTypeInfoService.GetFileTypeInfoByFileTypeId(fileTypeId);
lists.Add(accessoryFile);
}
return lists; UserInfo user = null;
List<UserInfo> users = new List<UserInfo>();
SqlDataReader reader = SQLConn.GetReader(sql); while (reader.Read())
{
user = new UserInfo();
user.Uid = Convert.ToInt32(reader["Uid"].ToString());
user.Uname = reader["Uname"].ToString();
user.Upwd = reader["Upwd"].ToString();
user.Telphone = reader["Telphone"].ToString();
user.Email = reader["emial"].ToString();
user.Address = reader["Address"].ToString();
users.Add(user);
}
reader.Close();
return users;都是得到一个集合 有啥区别呢????
List<AccessoryFile> lists = new List<AccessoryFile>(); AccessoryFile accessoryFile = null;
foreach (DataRow row in dt.Rows)
{
accessoryFile = new AccessoryFile();
accessoryFile.AccessoryId = (int)row["AccessoryId"];
accessoryFile.AccessoryName = row["AccessoryName"].ToString();
accessoryFile.AccessoryPath = row["AccessoryPath"].ToString();
accessoryFile.AccessorySize = (int)row["AccessorySize"];
accessoryFile.CreateDate = Convert.ToDateTime(row["CreateDate"].ToString());
int fileId=(int)row["FileId"];
int fileTypeId = (int)row["AccessoryType"];
accessoryFile.FileInfo = FileInfoService.GetFileInfoByFileId(fileId);
accessoryFile.FileTypeInfo = FileTypeInfoService.GetFileTypeInfoByFileTypeId(fileTypeId);
lists.Add(accessoryFile);
}
return lists; UserInfo user = null;
List<UserInfo> users = new List<UserInfo>();
SqlDataReader reader = SQLConn.GetReader(sql); while (reader.Read())
{
user = new UserInfo();
user.Uid = Convert.ToInt32(reader["Uid"].ToString());
user.Uname = reader["Uname"].ToString();
user.Upwd = reader["Upwd"].ToString();
user.Telphone = reader["Telphone"].ToString();
user.Email = reader["emial"].ToString();
user.Address = reader["Address"].ToString();
users.Add(user);
}
reader.Close();
return users;都是得到一个集合 有啥区别呢????
DataTable与DataReader的区别
DatSet 连接数据库时是非面向连接的。
datareader 连接数据库时是面向连接的。
嗯。但是用datareader也要注意。调用了它的read()方法后,必须要关闭。才能再调用read()方法。