这是.net课程的C#大作业,现在想把它重新的记录一下
软件:vs2010
语言:C#
第一部分:界面介绍
(1)登录界面
(2)修改界面
(3)应用界面
备注(应用界面参考其他文章,由于时间过久找不到原文章和作者了
)
(4)特色功能
可以在地图上显示录入的学生的地理位置的分布
第二部分,代码介绍
1,Form1设计(应用界面用于录入学生的信息并加以显示)
Form1代码
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 学生管理系统
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
//连接数据库
private void Form1_Load(object sender, EventArgs e)
{
// TODO: 这行代码将数据加载到表“dataSet2.stud”中。您可以根据需要移动或删除它。
this.studTableAdapter.Fill(this.dataSet2.stud);
}
private void dateTimePicker1_ValueChanged(object sender, EventArgs e)
{
}
//添加学生信息
private void button1_Click(object sender, EventArgs e)
{//连接数据库
string Sno, ClassName, Sname, Sex, Birth, Tel, Address;
SqlConnection conn = new SqlConnection();
//ConnectionString是数据库属性中的连接字符串
conn.ConnectionString = @"Data Source=.\sqlexpress;Integrated Security=True";
conn.Open();
Sno = textBox1.Text;
ClassName = comboBox1.Text;
Sname = textBox3.Text;
Sex = "";
if(radioButton1.Checked)
{
Sex = radioButton1.Text;
}
else if(radioButton2.Checked)
{
Sex = radioButton2.Text;
}
Birth = dateTimePicker1.Text;
Tel = textBox6.Text;
Address = textBox7.Text;
SqlCommand cmd = new SqlCommand("INSERT INTO stud values('" + Sno + "','" + ClassName + "','" + Sname + "','" + Sex + "','" + Birth + "','" + Tel + "','" + Address + "')", conn);
cmd.ExecuteNonQuery();
MessageBox.Show("增加学生信息成功!");
this.studTableAdapter.Fill(this.dataSet2.stud);
conn.Close();
}
private void button2_Click(object sender, EventArgs e)
{
int a = dataGridView1.CurrentRow.Index;
string Sno = dataGridView1.Rows[a].Cells[0].Value.ToString();
SqlConnection conn = new SqlConnection();
conn.ConnectionString = @"Data Source=.\sqlexpress;Integrated Security=True";
conn.Open();
string sql = string.Format("delete stud where Sno='{0}'", Sno);
SqlCommand cmd = new SqlCommand(sql, conn);
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
MessageBox.Show("删除学生信息成功!");
}
else
{
MessageBox.Show("删除学生信息失败!");
}
this.studTableAdapter.Fill(this.dataSet2.stud);
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
}
private void fillByToolStripButton_Click(object sender, EventArgs e)
{
try
{
this.studTableAdapter.FillBy(this.dataSet2.stud);
}
catch (System.Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
}
private void studBindingSource_CurrentChanged(object sender, EventArgs e)
{
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
}
private void button3_Click(object sender, EventArgs e)
{
Form4 form4 = new Form4();
form4.ShowDialog();
}
}
}
2,Form2设计(一个简单的登陆界面,用户名和密码是固定的)
Form2代码
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 学生管理系统
{
public partial class Form2 : Form
{
public Form2()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
string name = textBox1.Text;
string pass = textBox2.Text;
if (name.Equals("abc") && pass.Equals("123"))
{
this.DialogResult = DialogResult.OK;
this.Dispose();
this.Close();
}
else
{
MessageBox.Show("密码错误,请重新输入!");
}
}
private void pictureBox1_Click(object sender, EventArgs e)
{
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
}
private void button2_Click(object sender, EventArgs e)
{
Form3 form3 = new Form3();
form3.ShowDialog();
}
}
}
3,Form3设计(只是加了修改的界面没有添加实质上的作用)
Form3代码
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 学生管理系统
{
public partial class Form3 : Form
{
public Form3()
{
InitializeComponent();
}
}
}
4,Form4设计(特色功能,显示学生的地理位置,点击相应的位置也可以显示这个地区的学生(只有几个地区可以其他地区没有添加还))
Form4代码
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 学生管理系统
{
public partial class Form4 : Form
{
public Form4()
{
InitializeComponent();
}
private void label2_Click(object sender, EventArgs e)
{
Form5 form5 = new Form5();
form5.ShowDialog();
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection();
//ConnectionString是数据库属性中的连接字符串
conn.ConnectionString = @"Data Source=.\sqlexpress;Integrated Security=True";
conn.Open();
int[] nums = new int[35];
int i = 0;
while(i <35)
{
nums[i]=0;
i++;
}
SqlCommand cmd = new SqlCommand("select * from stud", conn);
SqlDataReader dr = cmd.ExecuteReader();
string a,b;
// dr.NextResult();
while (dr.Read())
{
a = (String)dr[6].ToString().Trim();
// a = (String)dr[6].ToString().Trim();
b = a.Substring(0, 3);
if (b == "河北省")
{
nums[0]++;
label2.Text = nums[0].ToString();
}
if (b == "山西省")
{
nums[1]++;
label3.Text = nums[1].ToString();
}
if (b == "辽宁省")
{
nums[2]++;
label4.Text = nums[2].ToString();
}
if (b == "吉林省")
{
nums[3]++;
label5.Text = nums[3].ToString();
}
if (b == "黑龙江")
{
nums[4]++;
label6.Text = nums[4].ToString();
}
if (b == "江苏省")
{
nums[5]++;
label7.Text = nums[5].ToString();
}
if (b == "浙江省")
{
nums[6]++;
label8.Text = nums[6].ToString();
}
if (b == "安徽省")
{
nums[7]++;
label9.Text = nums[7].ToString();
}
if (b == "福建省")
{
nums[8]++;
label10.Text = nums[8].ToString();
}
if (b == "江西省")
{
nums[9]++;
label11.Text = nums[11].ToString();
}
if (b == "山东省")
{
nums[10]++;
label12.Text = nums[10].ToString();
}
if (b == "河南省")
{
nums[11]++;
label13.Text = nums[11].ToString();
}
if (b == "湖北省")
{
nums[12]++;
label14.Text = nums[12].ToString();
}
if (b == "湖南省")
{
nums[13]++;
label15.Text = nums[13].ToString();
} if (b == "广东省")
{
nums[14]++;
label16.Text = nums[14].ToString();
} if (b == "海南省")
{
nums[15]++;
label17.Text = nums[15].ToString();
} if (b == "四川省")
{
nums[16]++;
label18.Text = nums[16].ToString();
} if (b == "贵州省")
{
nums[17]++;
label19.Text = nums[17].ToString();
} if (b == "云南省")
{
nums[18]++;
label20.Text = nums[18].ToString();
} if (b == "陕西省")
{
nums[19]++;
label21.Text = nums[19].ToString();
} if (b == "甘肃省")
{
nums[20]++;
label22.Text = nums[20].ToString();
} if (b == "青海省")
{
nums[21]++;
label23.Text = nums[21].ToString();
} if (b == "台湾省")
{
nums[22]++;
label24.Text = nums[22].ToString();
} if (b == "北京市")
{
nums[23]++;
label25.Text = nums[23].ToString();
} if (b == "天津市")
{
nums[24]++;
label26.Text = nums[24].ToString();
} if (b == "上海市")
{
nums[25]++;
label27.Text = nums[25].ToString();
} if (b == "重庆市")
{
nums[26]++;
label28.Text = nums[26].ToString();
} if (b == "香港特")
{
nums[27]++;
label29.Text = nums[27].ToString();
} if (b == "澳门特")
{
nums[28]++;
label30.Text = nums[28].ToString();
} if (b == "内蒙古")
{
nums[29]++;
label31.Text = nums[29].ToString();
} if (b == "广西壮")
{
nums[30]++;
label32.Text = nums[30].ToString();
} if (b == "西藏自")
{
nums[31]++;
label33.Text = nums[31].ToString();
} if (b == "宁夏回")
{
nums[32]++;
label34.Text = nums[32].ToString();
} if (b == "新疆维")
{
nums[33]++;
label35.Text = nums[33].ToString();
}
int sum=0;
int j = 0;
while (j <= 34)
{
sum = sum + nums[j];
j++;
}
label37.Text = sum.ToString();
}
}
private void label18_Click(object sender, EventArgs e)
{
}
private void label6_Click(object sender, EventArgs e)
{
}
}
}
5,Form5设计(点击地图后显示的当地的学生名单)
Form5代码
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 学生管理系统
{
public partial class Form5 : Form
{
public Form5()
{
InitializeComponent();
}
private void Form5_Load(object sender, EventArgs e)
{
// TODO: 这行代码将数据加载到表“dataSet3.stud”中。您可以根据需要移动或删除它。
this.studTableAdapter.Fill(this.dataSet3.stud);
SqlConnection conn = new SqlConnection();
//ConnectionString是数据库属性中的连接字符串
conn.ConnectionString = @"Data Source=.\sqlexpress;Integrated Security=True";
conn.Open();
SqlCommand cmd = new SqlCommand("select * from stud WHERE (address = '河北省')", conn);
//SqlDataAdapter da = new SqlDataAdapter (cmd);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();//定¨义?数簓据Y集ˉ
da.Fill(dt);
this.dataGridView1.DataSource = dt;
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
}
}
}
整体上这个软件是这样的,因为时间的原因,有好多的功能并没有完善,但是整体上还是不错的,所以进行一下记录希望可以帮助到大家!