ADO.NET数据绑定，vs自带数据库（SqlServerLocaldb）

#1.创建空项目，添加webfrom1窗体

不会创建的参考这一个实验：

https://blog.csdn.net/F_fengzilin/article/details/117935041?spm=1001.2014.3001.5501

#2.添加数据库，

#2.1视图->Sql Server对象资源管理器，

表中的数据类型自己创建，创建完成表后，右键表名，查看数据，自己添加数据即可

#3.在webfrom1.aspx.cs中添加数据

string connString = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=Students;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False";
            SqlConnection con = new SqlConnection(connString);
            con.Open();
            string sqly = @"select * from [student_info]";
            SqlCommand sqlCommand = new SqlCommand(sqly, con);
            SqlDataAdapter mdt = new SqlDataAdapter(sqlCommand);
            DataSet dt = new DataSet();
            mdt.Fill(dt);
            con.Close();
            List<Student> students = new List<Student>();
            foreach(DataRow row in dt.Tables[0].Rows)
            {
                students.Add(Student.modol(row));
            }
            var list = from s in students select s;
            var listone = from s in students where s.age<20 select s;
            var listSecond = from s in students where s.name.Contains("王") select s;
            Response.Write("所有学生信息:"+ "<br/>");
            foreach (Student s in list)
            {
                Response.Write("姓名:"+s.name+" "+"年龄"+s.age+" "+"学号："+s.sno+ "<br/>");
                
            }
            Response.Write("所有学生年龄小于20岁的信息：<br/>");
            foreach (Student s in listone)
            {
                Response.Write("姓名:" + s.name + " " + "年龄" + s.age + " " + "学号：" + s.sno+ "<br/>");
            }

            Response.Write("查询姓王同学的信息：<br/>");
            foreach (Student s in listSecond)
            {
                Response.Write("姓名:" + s.name + " " + "年龄" + s.age + " " + "学号：" + s.sno + "<br/>");
            }
        }
         public class Student {
            public  string name { get; set; }
            public  string sno { get; set; }
            public  int age { get; set; }

           public static Student modol(DataRow dataRow)
            {
                Student sd = new Student
                {
                    name = dataRow["name"].ToString(),
                    sno = dataRow["sno"].ToString(),
                    age = (int)dataRow["age"],
                };
                return sd;
            }

#源码位置如图，

然后运行项目即可.好兄弟们来波关注吧