form3.cs

不错的班级管理系统

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace _7计应的班级管理系统
{
    public partial class Form3 : Form
    {
        public Form3()
        {
            InitializeComponent();
        }
  public static string strconn = "user id=sa;data source=localhost;integrated security=false;initial catalog=学生数据库1";

        private void Form3_Load(object sender, EventArgs e)
        {
			string sql="select 用户名,用户权限 from login where 用户权限='系统管理员'";
			SqlConnection conn=new SqlConnection(strconn);
			SqlDataAdapter da=new SqlDataAdapter(sql,conn);
			DataSet ds=new DataSet();
			da.Fill(ds,"login");
        
            dataGridView1.DataSource = ds;//绑定数据源
            dataGridView1.DataMember = "login";//指定数据表
        }
           
        }
    }