110,539
社区成员
发帖
与我相关
我的任务
分享
public static DataTable GetAllData()
{
DataTable dt = new DataTable();
try
{
DataRow dr;
string strConn
= @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=
E:\Code\DriverExam\DriverExam\App_Data\db.mdb;";
OleDbConnection odcConnection = new OleDbConnection(strConn);
odcConnection.Open();
OleDbCommand odCommand = odcConnection.CreateCommand();
odCommand.CommandText
= "select * from ( select top 100 * from shiti2012 order by rnd(id) ) order by zhangjie,id";
//= "select top 100 * from shiti2012 where bmp is not null order by rnd(id)";
OleDbDataReader odrReader = odCommand.ExecuteReader();
for (int i = 0; i < odrReader.FieldCount; i++)
{
DataColumn dc;
dc = new DataColumn(odrReader.GetName(i));
dt.Columns.Add(dc);
}
while (odrReader.Read())
{
dr = dt.NewRow();
for (int i = 0; i < odrReader.FieldCount; i++)
{
dr[odrReader.GetName(i)] = odrReader[odrReader.GetName(i)].ToString();
}
dt.Rows.Add(dr);
}
odrReader.Close();
odcConnection.Close();
return dt;
}
catch { return dt; }
}
select * from ( select top 100 * from shiti2012 order by rnd(id) ) order by zhangjie,id
Random rnd = new Random();
int r = rnd.Next();
OleDbCommand odCommand = odcConnection.CreateCommand();
odCommand.CommandText
= "select * from ( select top 100 * from shiti2012 order by rnd(" + r.ToString() + ")) order by zhangjie,id";