Form3.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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

namespace WindowsFormsApplication1
{
    public partial class Form3 : Form
    {
        public Form3()
        {
            InitializeComponent();
            this.Load += new EventHandler(Form3_Load);
            
        }

        private void Form3_Load(object sender, EventArgs e)
        {
            var sql = "select * from information";
            var dt = DBHelper.GetData(sql);
            dataGridView1.DataSource = dt;
            dataGridView1.ReadOnly = true;
            dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
            dataGridView1.AllowUserToAddRows = false;


            var sql2 = "select distinct Classname from information";
            var dt2 = DBHelper.GetData(sql2);
            ClassName_.DataSource = dt2;
            ClassName_.DisplayMember = "Classname";
        }

        //添加
        private void button1_Click(object sender, EventArgs e)
        {
            var Sno = Sno_.Text.Trim();
            var Realname = Realname_.Text.Trim();
            var Username = Realname_.Text.Trim();
            var Classname = ClassName_.Text.Trim();
            var Sex = Sex_.Text.Trim();
            var Age = Age_.Text.Trim();
            var Phonenumber = Phonenumber_.Text.Trim();
            var Address = Address_.Text.Trim();

            var sql = string.Format("insert into information(Sno,Realname,Classname,Sex,Age,Phonenumber,Address,Username) values('{0}','{1}','{2}','{3}',{4},'{5}','{6}','{7}')", Sno, Realname, Classname, Sex, Age, Phonenumber, Address, Username);

            if (Sno == "" || Realname == "" || Sex == "" || Age == "" || Phonenumber == "" || Address == "") {
                MessageBox.Show("信息不能留空");
            }
            else
            {
                var dt = DBHelper.AddOrUpdateOrDelete(sql);
                if(dt > 0){
                    MessageBox.Show("添加成功");
                    Form3_Load(sender, e);
                }