SqlConnection Myconnection = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\WordDatabase.mdf;Integrated Security=True;User Instance=True");
Myconnection.Open();
//调用函数choosemaxid
_Lessonnumber = int.Parse(CurriculumDropDownList.Text);
_MaxRecNo = choosemaxid.choosemaxid(_Lessonnumber);
//调用函数chooseminid
_MinRecNo = chooseminid.chooseminid(_Lessonnumber);
//创建一个随机数
Random R = new Random();
_RecNo = R.Next(_MinRecNo,_MaxRecNo);
//显示随机记录信息。
SqlCommand Cmd = new SqlCommand("select MEANS from WORD_INFO Where WORD_ID = " + _RecNo, Myconnection);
_Recordid = _RecNo;
SqlDataReader DR = Cmd.ExecuteReader();
while (DR.Read())
{
int i;
for (i = 0; i <DR.FieldCount;i++ )
WordLabel.Text = "<Td>" + DR.GetValue(i) + "</Td>";
}
DR.Close();
Myconnection.Close();
Myconnection.Dispose();
Myconnection.Open();
//调用函数choosemaxid
_Lessonnumber = int.Parse(CurriculumDropDownList.Text);
_MaxRecNo = choosemaxid.choosemaxid(_Lessonnumber);
//调用函数chooseminid
_MinRecNo = chooseminid.chooseminid(_Lessonnumber);
//创建一个随机数
Random R = new Random();
_RecNo = R.Next(_MinRecNo,_MaxRecNo);
//显示随机记录信息。
SqlCommand Cmd = new SqlCommand("select MEANS from WORD_INFO Where WORD_ID = " + _RecNo, Myconnection);
_Recordid = _RecNo;
SqlDataReader DR = Cmd.ExecuteReader();
while (DR.Read())
{
int i;
for (i = 0; i <DR.FieldCount;i++ )
WordLabel.Text = "<Td>" + DR.GetValue(i) + "</Td>";
}
DR.Close();
Myconnection.Close();
Myconnection.Dispose();
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货