初步学生信息管理系统练习

 

修改模块  

 

private void btnEdit_Click(object sender, EventArgs e)
{
string strGUID = dataGridView1[0, dataGridView1.CurrentRow.Index].Value.ToString();
FrmEdit frm = new FrmEdit();
frm.GUID = strGUID;
frm.Owner = this;
frm.ShowDialog();
sData();
}

 

public string GUID { get; set; }

 

private void FrmEdit_Load(object sender, EventArgs e)
{
string strConnection = "Server=.;DataBase=db_StudentMangerSystem;UID=sa;Pwd=123456";
SqlDataAdapter dad = new SqlDataAdapter(string.Format("SELECT *FROM T_Student WHERE GUID = '{0}'",this.GUID)
,strConnection);

 

DataSet dst = new DataSet();
dad.Fill(dst);

 

DataTable dt = dst.Tables[0];

 

txtName.Text = dt.Rows[0][1].ToString();
txtNo.Text = dt.Rows[0][2].ToString();
txtAge.Text = dt.Rows[0][4].ToString();
txtGrade.Text = dt.Rows[0][5].ToString();

 

string sex = dt.Rows[0][3].ToString();
if (sex=="女")
{
radioButton2.Checked = true;
}
}

 

 

private void btnOk_Click(object sender, EventArgs e)
{
string strConnection = "Server=.;DataBase=db_StudentMangerSystem;UID=sa;Pwd=123456";

SqlConnection conn = new SqlConnection(strConnection);
conn.Open();

string strNo = txtNo.Text.Trim();
string strName = txtName.Text.Trim();
int Age = Convert.ToInt32(txtAge.Text.Trim());
float Grade = float.Parse( txtGrade.Text.Trim());
string strSex = "男";

if (radioButton2.Checked)
{
strSex = "女";
}
else
{
strSex="男";
}

string strCmd = string.Format("UPDATE T_Student SET sNo='{0}',sName='{1}',sAge='{2}',sGrade='{3}',ssex='{4}'WHERE GUID ='{5}'",
strNo,strName,Age,Grade,strSex,this.GUID);

SqlCommand cmd = new SqlCommand(strCmd,conn);
int i = cmd.ExecuteNonQuery();

if (i==1)
{
MessageBox.Show("修改成功");
}
else
{
MessageBox.Show("修改失败");
}

conn.Close();
this.Close();
FrmMain frm = (FrmMain)this.Owner;

 

 

 

}

private void btnCancel_Click(object sender, EventArgs e)
{
this.Close();
}

 

 

添加模块

 

private void btnAdd_Click(object sender, EventArgs e)
{
FrmAdd frm = new FrmAdd();
frm.Owner = this;
frm.ShowDialog();
sData();
}

 

 

private void btnOk_Click(object sender, EventArgs e)
{
string strConnection = "Server=.;DataBase=db_StudentMangerSystem;UID=sa;Pwd=123456";

SqlConnection conn = new SqlConnection(strConnection);
conn.Open();

string strNo = txtNo.Text.Trim();
string strName = txtName.Text.Trim();
int Age = int.Parse(txtAge.Text.Trim());
float Grade = float.Parse(txtGrade.Text.Trim());

string strSex = "男";

if (radioButton1.Checked)
{
strSex = "男";
}
else
{
strSex = "女";
}
string strGUID = Guid.NewGuid().ToString();
string strcmd = string.Format("INSERT T_Student VALUES '{0}','{1}','{2}','{3}','{4}','{5}'",
strGUID,strName,strNo,
strSex,Age,Grade);

SqlCommand cmd = new SqlCommand(strcmd,conn);

int i = cmd.ExecuteNonQuery();

if (i==1)
{
MessageBox.Show("添加成功");
}
else
{
MessageBox.Show("添加失败");
}

conn.Close();

this.Close();

FrmMain frm = (FrmMain)this.Owner;

 

}

private void btnCancel_Click(object sender, EventArgs e)
{
this.Close();
}
}

 

 

删除模块

 

private void btnDelete_Click(object sender, EventArgs e)
{
DialogResult Result = System.Windows.Forms.MessageBox.Show("是否确定要删除?","删除提示",MessageBoxButtons.YesNo,MessageBoxIcon.Question);

 

if (Result==System.Windows.Forms.DialogResult.Yes)
{
string strGUID = dataGridView1[0, dataGridView1.CurrentRow.Index].Value.ToString();

 

string strCmd = string.Format("DELETE T_Student WHERE GUID='{0}'",strGUID);

 

SqlConnection conn = new SqlConnection();
conn.Open();

 

SqlCommand cmd = new SqlCommand(strCmd,conn);

 

int i = cmd.ExecuteNonQuery();

 

if (i!=1)
{
MessageBox.Show("删除失败");
}

 

conn.Close();
sData();

 

}
}

 

 

查询模块

按学号查询(模糊查询):

按姓名查询(模糊查询):?

 

private void btnSelect_Click(object sender, EventArgs e)
{
string strConnection = "Server=.;DataBase=db_StudentMangerSystem;UID=sa;Pwd=`123456'";

 

SqlDataAdapter dad = new SqlDataAdapter();

 

DataSet dst = new DataSet(strConnection);
dad.Fill(dst);

 

string strNo = txtNo.Text.Trim();

 

DataTable dt = dst.Tables[0];
dataGridView1.DataSource = dt;

 

dataGridView1.Columns[0].Visible = false;
dataGridView1.Columns[1].HeaderText = "姓名";
dataGridView1.Columns[2].HeaderText ="学号";
dataGridView1.Columns[2].HeaderText = "性别";
dataGridView1.Columns[2].HeaderText = "年龄";
dataGridView1.Columns[2].HeaderText = "成绩";
}

 

报表打印