父窗口:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void 添加信息ToolStripMenuItem_Click(object sender, EventArgs e)
{
Form2 tu = new Form2();
tu.MdiParent = this;
tu.Show();
}
private void 退出XToolStripMenuItem_Click(object sender, EventArgs e)
{
Application.Exit();
}
private void toolStripComboBox1_Click(object sender, EventArgs e)
{
}
}
}
子窗口:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace WindowsFormsApplication1
{
public partial class Form2 : Form
{
string ent = "Data Source=.;Initial Catalog=MySchool;Integrated Security=True";
public string run = string.Empty;
public Form2()
{
InitializeComponent();
}
private void Form2_Load(object sender, EventArgs e)
{
//for (int i = 1; i <= 10; i++)
//{
// this.comboBox1年级.Items.Add(i);
//}
comboBox1年级.Items.Add("请选择");
comboBox1年级.SelectedIndex = 0;
BindGread();
}
public bool BindGread()
{
SqlConnection conn = new SqlConnection(ent);
Form2 per = new Form2();
try
{
string sql = "select * from dbo.Grade";
conn.Open();
SqlCommand comm = new SqlCommand(sql, conn);
SqlDataReader MyReder = comm.ExecuteReader();
while (MyReder.Read())
{ //获取年级名称
string gradename = MyReder["GradeName"].ToString();
//将年级名称添加到组合框中
comboBox1年级.Items.Add(gradename);
}
MyReder.Close();
return true;
}
catch (Exception)
{
MessageBox.Show("系统发生错误", "提示", MessageBoxButtons.OK, MessageBoxIcon.Question);
return false;
}
finally
{
per.Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
Application.Exit();
}
private void 保存_Click(object sender, EventArgs e)
{
if(shout()){
// MessageBox.Show("是否保存","操作提示",MessageBoxButtons.YesNo,MessageBoxIcon.Question);
setdata();
}
}
public bool shout()
{
if (this.id.Text.Trim().Equals(string.Empty))
{
MessageBox.Show("请输入学号", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Question);
this.id.Focus();
return false;
}else if(this.pwd.Text.Trim().Equals(string.Empty))
{
MessageBox.Show("请输入密码", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Question);
this.pwd.Focus();
return false;
}else if(this.pwds.Text.Trim().Equals(string.Empty))
{
MessageBox.Show("请输入确认密码", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Question);
this.pwds.Focus();
return false;
}else if(this.name.Text.Trim().Equals(string.Empty))
{
MessageBox.Show("请输入姓名", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Question);
this.name.Focus();
return false;
}else if(this.comboBox1年级.Text.Trim().Equals(string.Empty))
{
MessageBox.Show("请输入年级", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Question);
this.comboBox1年级.Focus();
return false;
}else if(this.phone.Text.Trim().Equals(string.Empty))
{
MessageBox.Show("请输入电话", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Question);
this.id.Focus();
return false;
}else if(this.ee.Text.Trim().Equals(string.Empty))
{
string ru = "请输入Email,必须包含@";
MessageBox.Show(ru ,"操作提示", MessageBoxButtons.OK, MessageBoxIcon.Question);
this.id.Focus();
return false;
}
else
{
return true;
}
}
public void setdata()
{
bool success = true;
SqlConnection conn = new SqlConnection(ent);
string id = this.id.Text;
string pwd = this.pwd.Text;
string pwds = this.pwds.Text;
string name = this.name.Text;
string comboBox1年级 = this.comboBox1年级.Text;
string phone = this.phone.Text;
string address = this.address.Text;
string time = this.time.Text;
string ee = this.ee.Text;
string sex = "";
if (sex1.Checked == true)
{
sex = "男";
}
else if (sex2.Checked == true)
{
sex = "女";
}
DateTime date = this.time.Value; //出生日期
string birthday = string.Format("{0}-{1}-{2}", date.Year, date.Month, date.Day);
try
{
conn.Open();
//构建按年级名称查询年级编号的Sql语句
string sqlname = string.Format(" select * from Student where GradeName='{0}'");
//创建Command对象
SqlCommand command = new SqlCommand(sqlname, conn);
//查询获得年级编号
int gradeld = (int)command.ExecuteScalar();
//查询插入学生记录的SQL语句
StringBuilder sql = new StringBuilder();
sql.AppendLine("insert into Student (LoginPwd,StudentName,Gender,GradeId,Phone,Address,Birthday,Email) ");
sql.AppendFormat("VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')", pwd, name, sex, comboBox1年级, phone, address, birthday, ee);
//创建command对象
command = new SqlCommand(sql.ToString(), conn);
//打开数据库连接
conn.Open();
//执行命令
int result = command.ExecuteNonQuery();
//根据操作结果给出提示信息
if (result == 1)
{
string SqlNo = "select @@IDENTITY from dbo.Student";
command.CommandText = SqlNo;
int StudentNo = Convert.ToInt32(command.ExecuteScalar()); //学号
this.id.Text = StudentNo.ToString();
}
}
catch (Exception)
{
success = false;
}
finally
{
conn.Close();
}
}
}
}