C#编写简易的学生成绩查询
什么是学生成绩查询系统？
使用C#语言编写的一个可安装的简单CS系统，实现了用户登录，学生信息添加，成绩修改，删除，查询等功能
开发环境
开发环境
visual studio2010（新版本2015，2017也可）
visual studio2010（sql2008数据库）
安装步骤
功能展示
笔者在这里详情下一下制作步骤
1. 首先是登录界面及代码
2.
3. 先是创建一个windows窗体应用程序把名称改成学生成绩管理系统
4. 然后添加一个groupBox控件并且把名称改为登陆，然后添加两个lable控件分别为账户密码 两个txtbox控件 一个button控件
5. using System;
6. using System.Collections.Generic;
7. using System.ComponentModel;
8. using System.Data;
9. using System.Drawing;
10. using System.Linq;
11. using System.Text;
12. using System.Windows.Forms;
13.
14. namespace 测a试o?
15. {
16. public partial class login : Form
17. {
18. public login()
19. {
20. InitializeComponent();
21. }
22.
23. private void textBox1_TextChanged(object sender, EventArgs e)
24. {
25.
26. }
27.
28. private void button1_Click(object sender, EventArgs e)
29. {
30. if (textBox1.Text == string.Empty)//如果文本为空
31. {
32. MessageBox.Show( "账?户?ì不?能¨1为a空?","错?¨a误¨?提?¨￠示o?",MessageBoxButtons.OK,MessageBoxIcon.Error);//弹出消息框
33. }
34. if (textBox1.Text == "一°?班?¨¤三¨y组á¨|" && textBox2.Text == "1403")//如果账户密码正确
35. {
36. studentmange frm=new studentmange();//实例学生成绩化窗体
37. frm.Show();//显示窗体
38. this.Visible=false;//隐藏登陆窗体
39.
40. }
41.
42. }
43.
44. private void login_Load(object sender, EventArgs e)
45. {
46.
47. }
48. }
49. }
添加成绩查询窗体
与第一个窗体一样添加控件 多了一个dataGridView控件
代码如下：
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;
using System.Data.SqlClient;
namespace 测a试o?
{
public partial class studentmange : Form
{
public void shuju()//创建方法
{
String strcon = "server=(bds288146407.my3w.com);database=bds288146407_db;uid= bds288146407;pwd=chen419216";//连接数据库
SqlConnection conn = new SqlConnection(strcon);
conn.Open();//打开数据库
String sql = "select * from 成¨|绩?§表à¨a where 学?ì号?='" + this.textBox3.Text.Trim() + "'and 课?程¨?名?称?='" + this.textBox4.Text.Trim() + "'";//输入sql查询语句
SqlDataAdapter reae = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();//填充数据
reae.Fill(ds);
dataGridView2.DataSource = ds.Tables[0];//显示数据
}
public studentmange()
{
InitializeComponent();
}
private void button2_Click(object sender, EventArgs e)
{
if (textBox1.Text == string.Empty)//如果文本框为空
{
MessageBox.Show("不?能¨1为a空?", "错?¨a误¨?提?¨￠示o?", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (textBox2.Text == string.Empty)
{
MessageBox.Show("不?能¨1为a空?", "错?¨a误¨?提?¨￠示o?", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;//结束查询
}
String strcon = "server=(bds288146407.my3w.com);database=bds288146407_db;uid=bds288146407;pwd=chen419216";
SqlConnection conn = new SqlConnection(strcon);
conn.Open();
String sql = "select * from 成¨|绩?§表à¨a where 姓?名?='"+ this.textBox1.Text.Trim()+ "'and 学?ì号?='"+this.textBox2.Text.Trim()+"'";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader reader = cmd.ExecuteReader();
this.dataGridView1.DataSource = reader;
//this.dataGridView1.DataSource = DataBindings;
//SqlDataAdapter reae = new SqlDataAdapter(sql, conn);
//DataSet ds = new DataSet();
//reae.Fill(ds);
//dataGridView1.DataSource = ds.Tables[0];
}
private void button1_Click(object sender, EventArgs e)
{
textBox1.Text = "";
textBox2.Text = "";
}
private void Form1_Load(object sender, EventArgs e)
{
}
private void textBox4_TextChanged(object sender, EventArgs e)
{
}
private void button4_Click(object sender, EventArgs e)
{
if (textBox3.Text == string.Empty)
{
MessageBox.Show("不?能¨1为a空?", "错?¨a误¨?提?¨￠示o?", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (textBox4.Text == string.Empty)
{
MessageBox.Show("不?能¨1为a空?", "错?¨a误¨?提?¨￠示o?", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (textBox5.Text == string.Empty)
{
MessageBox.Show("不?能¨1为a空?", "错?¨a误¨?提?¨￠示o?", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
String strcon = "server=(bds288146407.my3w.com);database=bds288146407_db;uid= bds288146407;pwd=chen419216";
SqlConnection conn = new SqlConnection(strcon);
conn.Open();
string sql = "update 成¨|绩?§表à¨a set 课?程¨?名?称?='"+this.textBox4.Text.Trim()+"',成¨|绩?§='"+this.textBox5.Text.Trim()+"'where 学?ì号?='"+this.textBox3.Text.Trim()+"'";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
shuju();//方法调用
conn.Close();
}
private void button3_Click(object sender, EventArgs e)
{
String strcon = "server=(bds288146407.my3w.com);database=bds288146407_db;uid= bds288146407;pwd=chen419216";
SqlConnection conn = new SqlConnection(strcon);
conn.Open();
string sql = "delete 成¨|绩?§表à¨a where 学?ì号?='" + this.textBox3.Text.Trim() + "'";
SqlCommand cmd = new SqlCommand(sql, conn);//数据采集
cmd.ExecuteNonQuery();//执行查询
MessageBox.Show("删|?除y成¨|功|");
String sql2 = "select * from 成¨|绩?§表à¨a";
SqlDataAdapter reae = new SqlDataAdapter(sql2, conn);
DataSet ds = new DataSet();
reae.Fill(ds);
dataGridView2.DataSource = ds.Tables[0];
conn.Close();
}
private void button5_Click(object sender, EventArgs e)
{
String strcon = "server=(bds288146407.my3w.com);database=bds288146407_db;uid= bds288146407;pwd=chen419216";
SqlConnection conn = new SqlConnection(strcon);
conn.Open();
string sql = "insert into 成¨|绩?§表à¨a(姓?名?,学?ì号?,课?程¨?名?称?,成¨|绩?§,年¨o龄￠?) values ('" + this.textBox6.Text.Trim() + "','" + this.textBox7.Text.Trim() + "','" + this.textBox8.Text.Trim() + "','" +Convert.ToInt32( this.textBox9.Text.Trim()) + "','" + this.textBox10.Text.Trim() + "') ";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
MessageBox.Show("添?¨a加¨?成¨|功|");
String sql2 = "select * from 成¨|绩?§表à¨a";
SqlDataAdapter reae = new SqlDataAdapter(sql2, conn);
DataSet ds = new DataSet();
reae.Fill(ds);
dataGridView3.DataSource = ds.Tables[0];
conn.Close();
}
private void button6_Click(object sender, EventArgs e)
{
Application.Exit();
}
private void toolStrip1_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
{
}
private void statusStrip1_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
{
}
private void toolStrip1_ItemClicked_1(object sender, ToolStripItemClickedEventArgs e)
{
}
}
}
数据库ER图
相关文章
