namespace WebApplication1.App_Code
{
    public class helper
    {
        public string strconn;
        public helper()
        {
            strconn = "Data Source = LZX-THINK;Initial Catalog=StudentMS;Integrated Security=True";//连接字符串
        }
        [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, true)]
        public DataTable GetData()
        {
            string sql = "select * from 课程表";//需要用到的查询语句
            SqlConnection conn = new SqlConnection(strconn);//实例化一个新的连接SqlConnection类
            conn.Open();//打开连接
            SqlDataAdapter adp = new SqlDataAdapter(sql, strconn);//实例化SqlDataAdapter类并为其指定查询语句和所用链接
            DataSet dst = new DataSet();
            adp.Fill(dst, "课程表");
            return dst.Tables["课程表"];
        }
    }
}