创建数据库和Student表
一、数据访问层(DAL)
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
public class StudentDAL
{
private string connectionString = @"Server=.;Database=Student;User Id=sa;Password=1234;";
public List<Student> GetAllData()
{
List<Student> studentes = new List<Student>();
using (SqlConnection conn = new SqlConnection(connectionString))
{
string query = "SELECT ID, name, age,sex FROM Student;";
SqlCommand cmd = new SqlCommand(query, conn);
try
{
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
studentes.Add(new Student
{
Id = (int)reader["ID"],
Name = reader["name"].ToString(),
Age = (int)reader["age"],
Sex = reader["sex"].ToString()
});
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
return studentes;
}
}
public class Student
{
public int Id { get; set; }
public string Name { get; set; }
public int Age { get; set; }
public string Sex { get; set; }
}
二、业务逻辑层(BLL)
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace linkSQLSever
{
public class StudentBLL
{
public List<Student> GetAllData()
{
StudentDAL dal = new StudentDAL();
return dal.GetAllData();
}
}
}
三、视图层
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace linkSQLSever
{
public partial class Form1 : Form
{
StudentBLL bll = new StudentBLL();
public Form1()
{
InitializeComponent();
LoadData();
}
private void LoadData()
{
List<Student> stu = bll.GetAllData();
// 假设你有一个DataGridView控件名为dataGridView1
dataGridView1.DataSource = stu;
}
}
}