teacher.cs

学生管理系统的一个文件 我刚刚学不太会

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace CMS
{
    public partial class teacher : Form
    {
        public teacher()
        {
            InitializeComponent();
        }
        public string str;
        private void 课程担当ToolStripMenuItem_Click(object sender, EventArgs e)
        {
           
           
        }

        private void 个人住处查询ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            SqlConnection conn = null;
            DataSet ds = new DataSet();
            try
            {
                using (conn = new SqlConnection(@"server=GEM\MIRROR;database=sky;integrated security=true;;"))
                {
                    conn.Open();
                    string str2 = "select * from dbo.sky_teacher where 教师编号='"+str +"'";
                    SqlDataAdapter da = new SqlDataAdapter(str2, conn);
                    da.Fill(ds);

                    dataGridView1.DataSource = ds.Tables[0].DefaultView;
                }
                //conn = new SqlConnection("server=GEM\MIRROR;database=sky;integrated security=true;");
                //conn.Open();
            }
            catch (SqlException ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                conn.Close();
            }
        }

        private void 密码修改ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            
        }

        private void 个人信息ToolStripMenuItem_Click(object sender, EventArgs e)
        {

        }

        private void 退出ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            Application.Exit();
        }

        private void 课程信息ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            SqlConnection conn = null;
            DataSet ds = new DataSet();
            try
            {
                using (conn = new SqlConnection(@"server=GEM\MIRROR;database=sky;integrated security=true;;"))
                {
                    conn.Open();
                    string str2 = "select * from dbo.sky_kecheng where 课程号='" + str + "'";
                    SqlDataAdapter da = new SqlDataAdapter(str2, conn);
                    da.Fill(ds);

                    dataGridView1.DataSource = ds.Tables[0].DefaultView;
                }
                //conn = new SqlConnection("server=GEM\MIRROR;database=sky;integrated security=true;");
                //conn.Open();
            }
            catch (SqlException ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                conn.Close();
            }
        }

        private void 成绩查看ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            SqlConnection conn = null;
            DataSet ds = new DataSet();
            try
            {
                using (conn = new SqlConnection(@"server=GEM\MIRROR;database=sky;integrated security=true;"))
                {
                    conn.Open();
                    string str2 = "select * from dbo.sky_grade,dbo.sky_shouke where 教师编号='" + str + "' AND dbo.sky_grade.课程号=dbo.sky_shouke.课程号 ";
                    SqlDataAdapter da = new SqlDataAdapter(str2, conn);
                    da.Fill(ds);

                    dataGridView1.DataSource = ds.Tables[0].DefaultView;
                }
                //conn = new SqlConnection("server=localhost;database=zoo;integrated security=true;");
                //conn.Open();
            }
            catch (SqlException ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                conn.Close();
            }
        }

        private void 成绩统计ToolStripMenuItem_Click(object sender, EventArgs e)
        {

        }

        private void 成绩添加ToolStripMenuItem_Click(object sender, EventArgs e)
        {

        }

      private void 成绩删除ToolStripMenuItem_Click(object sender, EventArgs e)      //成绩删除。。。。。。。。。。。。。。。。吕俊杰
        {

            string str = this.dataGridView1.CurrentRow.Cells[0].Value.ToString();
            SqlConnection conn = null;
          SqlCommand cmd=null ;
            if (MessageBox.Show("是否确定删除", "提示", MessageBoxButtons.OKCancel) == DialogResult.Cancel)
                return;
            else
            {
               conn = new SqlConnection(@"server=GEM\MIRROR;database=sky;integrated security=true;");

            conn.Open();
            cmd  = new SqlCommand("delete from sky_grade where 编号='" + str + "' ", conn);

               
 
            }
            

           

            if (cmd.ExecuteNonQuery() > 0)                                                       //显示提示信息。。。。。。吕俊杰
            {
                MessageBox.Show("删除成功");
                conn.Close();

            }
            else
            {
                MessageBox.Show("删除失败");

            }

            
            DataSet ds = new DataSet();
            try
            {
                using (conn = new SqlConnection(@"server=GEM\MIRROR;database=sky;integrated security=true;"))  //重新刷新数据库。。。。。吕俊杰
                {
                    conn.Open();
                    string str2 = "select * from dbo.sky_grade,dbo.sky_shouke where 教师编号='" + str + "' AND dbo.sky_grade.课程号=dbo.sky_shouke.课程号 ";
                    SqlDataAdapter da = new SqlDataAdapter(str2, conn);
                    da.Fill(ds);

                    dataGridView1.DataSource = ds.Tables[0].DefaultView;
                }
                //conn = new SqlConnection("server=localhost;database=sky;integrated security=true;");
                //conn.Open();
            }
            catch (SqlException ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                conn.Close();
            }



        }
    }
}