＋设为首页 ＋添加到收藏夹
如题
用dtl就可以逐个读出呀
或者
OleDbCommand cmd=new OleDbCommand(strSql,cnn);
OleDbDataReader rdr=cmd.ExecuteReader();
用rdr也行
DataSet.DataTables[0].Rows[Index];
DbDataAdapter da=new DbDataAdapter("select * form tableName where yourcondition",cnn);
da.Fill(dtl);
foreach (DataRow dr in dtl.Rows)
{
// 此处用 dr 来表示表中的每一条记录
}
这样就可以一条一条地遍历表中的记录了
OleDbCommand cmd=new OleDbCommand(strSql,cnn);
OleDbDataReader rdr=cmd.ExecuteReader();
while(rdr.Read()) //循环读取rdr里的每一条记录
{
MessageBox.Show(rdr[0].ToString()); //用索引读取
MessageBox.Show(rdr[1].ToString());
MessageBox.Show(rdr["LoginName"].ToString()); //用字段名读取
}
1.用DataReader
dim cc as new oledbcommand("select * from ......",connection)
dim myread as oledbdatareader = cc.executereader
while myread.read 逐条遍历数据集
for i as integer =0 to myread.fieldcount - 1 遍历列
console.write(myread(i).tostring())
next
conlsole.writeline("")
end while
2.将数据读到记录集中，如一个Datatable中:
for each dr as datarow in Datatable1.rows 逐条遍历数据集
for each dc as datacolumn in Datatable1.columns 遍历列
conlsole.write(dr(dc).tostring())
next
conlsole.writeline("")
next
