Random ra = new Random();
int rndNum = ra.Next(100);//得到一个100以内的随机数字 OleDbConnection MyConn;
string MyConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\web\\cs.mdb";
MyConn = new OleDbConnection(MyConnString);
MyConn.Open();
string conn = "select * from cs where id=rndNum ";//从数据库中查询ID=“100以内的随机数字”的数据
OleDbDataAdapter dbcomm = new OleDbDataAdapter(conn, MyConn);
DataSet ds = new DataSet();
dbcomm.Fill(ds);
DataList1.DataSource = ds;
DataList1.DataBind();
int rndNum = ra.Next(100);//得到一个100以内的随机数字 OleDbConnection MyConn;
string MyConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\web\\cs.mdb";
MyConn = new OleDbConnection(MyConnString);
MyConn.Open();
string conn = "select * from cs where id=rndNum ";//从数据库中查询ID=“100以内的随机数字”的数据
OleDbDataAdapter dbcomm = new OleDbDataAdapter(conn, MyConn);
DataSet ds = new DataSet();
dbcomm.Fill(ds);
DataList1.DataSource = ds;
DataList1.DataBind();
rndNum是变量,你写到string里面做什么?
->string conn = "select * from cs where id="+rndNum.ToString();
string conn = "select * from cs where id='"+rndNum.ToString()+"'
用这个还不行?是id哪里类型不匹配嘛?如果是,那就把rndNum.ToString();改成rndNum;试试。
id 是int:string conn = string.Format("select * from cs where id={0}",rndNum);二楼的
id 是vchar:string conn = "select * from cs where id='"+rndNum.ToString()+"'";