C#实现学员信息管理系统实现学员信息管理系统
主要为大家详细介绍了C#实现学员信息管理系统，具有一定的参考价值，感兴趣的小伙伴们可以参考一下
新手写一段学员信息管理系统，有代码冗余的情况请谅解，代码如下，请大神指点
//登陆入口页面
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace 学员管理系统
{
public partial class Lo : Form
{
public Lo()
{
InitializeComponent();
}
string sql= "Data Source=LAPTOP-PCMBBB0N;Initial Catalog=DB_Student;Trusted_Connection=true;";
private void Log_Load(object sender, EventArgs e)
{
this.FormBorderStyle = FormBorderStyle.FixedToolWindow;
this.Location = new Point(Screen.PrimaryScreen.Bounds.Width / 2 - this.Width / 2, Screen.PrimaryScreen.Bounds.Height / 2 - this.Height / 2);
}
Main main;
private void button1_Click(object sender, EventArgs e)
{
try
{
string pwd =txtpwd.Text;
if (pwd.ToString() == "")
{
label2.Visible = true;
label2.Text = "密码不能为空！";
}
else
{
if (pwd.Equals((table.Rows[0]["Pwd"]).ToString()))
{
label2.Visible = false;
main = new Main();
main.Show();
this.Visible = false;
}
else
{
label2.Text = "密码不正确！";
label2.Visible = true;
}
}
}
catch (Exception)
{
throw;
}
}
DataTable table = new DataTable();
private void txtid_Leave(object sender, EventArgs e)
{
try
{
int id = int.Parse(txtid.Text);
//1.链接数据库对象
SqlConnection sqlcon = new SqlConnection(sql);
//3.创建数据库命令对象
SqlCommand cmd = new SqlCommand();
cmd.Connection = sqlcon;
cmd.CommandText = "SELECT * FROM Student WHERE ID=" + id;
//5.数据适配器对象
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
//6.这个table可以用来接受适配的最终结果
sda.Fill(table);
if (table.Rows.Count > 0)
{
label1.Visible = false;
}
else
{
label1.Visible = true;
label1.Text = "输入ID不存在！";
}
}
catch (Exception)
{
label1.Visible = true;
label1.Text = "请输入纯数字ID！";
txtid.Focus();
txtid.Text = "";
}
}
private void button2_Click_1(object sender, EventArgs e)
{
Register register = new Register();
register.ShowDialog();
this.Visible = true;
label1.Visible = false;
}
}
}
资源评论
