List<Model.Record> listRecord =null;
...
SqlDataReader reader = SqlHelpDao.ExecuteReader(DAL.SqlHelpDao.connString, CommandType.Text, sql,parms);
if (reader.HasRows)
{ listRecord = new List<Model.Record>();
while (reader.Read())
{
Model.Record rec = new Model.Record();
rec.RecordID = int.Parse(reader["RID"].ToString());
Model.Product product = new Model.Product();
product.ProductName = reader["RProductName"].ToString();
product.ProductSpecification = reader["RProductSpecification"].ToString();
rec.RProduct = product;
rec.RecordAmount = float.Parse(reader["RAmount"].ToString());
rec.RecordTime = (DateTime)reader["RTime"];
rec.RecordSign = (bool)reader["RSign"];
rec.RecordOperator = reader["ROperator"].ToString();
rec.RecordGetPerson = reader["RGetPerson"].ToString();
rec.RecordMeasure = reader["RMeasure"].ToString();
rec.RecordFactory = reader["RFactory"].ToString();
rec.Re = reader["RRemart"].ToString(); listRecord.Add(rec);
}
return listRecord;
...
呵呵 这样更方便你灵活运用啊~
要是想全部的话 使用DataGridView绑定到一个数据源上显示All就可以了
SELECT * FROM TABLE1不过用“*”代替后,当你的表再增加列时,你的程序就可能会有异常,因为你不能保证你查出的列固定不变了。
读出所有的列