制作题库时随机抽题

demo:

数据库操作：

 public static readonly string connstr = System.Configuration.ConfigurationManager.ConnectionStrings["connstr"].ConnectionString;

  public static DataTable ExecuteDataTabless(SqlConnection conn, string cmdText)
        {
            using (SqlCommand cmd = conn.CreateCommand())
            {
                cmd.CommandText = cmdText;
                using (SqlDataAdapter adapter = new SqlDataAdapter(cmd))
                {
                    DataTable dt = new DataTable();
                    adapter.Fill(dt);
                    return dt;
                }
            }
        }

        public static DataTable ExecuteDataTabless(string cmdText)
        {
            using (SqlConnection conn = new SqlConnection(connstr))