OleDbConnection myConn = new OleDbConnection("连接字符");
string cmdStr = "SELECT TOP 10 Rnd(ID) AS bb, * FROM student ORDER BY Rnd(ID)";
OleDbCommand cmd = new OleDbCommand(cmdStr, myConn);
cmd.CommandType = CommandType.Text;
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataTable ta = new DataTable();
da.Fill(ta);
this.dataGrid1.DataSource = ta;//上面运行,每次返回结果都一样,但在ACCESS中用查询结果次次不同,请问解决方式
string cmdStr = "SELECT TOP 10 Rnd(ID) AS bb, * FROM student ORDER BY Rnd(ID)";
OleDbCommand cmd = new OleDbCommand(cmdStr, myConn);
cmd.CommandType = CommandType.Text;
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataTable ta = new DataTable();
da.Fill(ta);
this.dataGrid1.DataSource = ta;//上面运行,每次返回结果都一样,但在ACCESS中用查询结果次次不同,请问解决方式
就象今天碰到用like '*商品*',能在ACCESS中用查询到,但在程序中却怎么也查不到,要用like '%%商品%%',怪问题,可能是ADO.NET的问题
关注
要确保每次执行都是不同的RAND([ seed ])