员工信息.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 WindowsApplication1
{
    public partial class 员工信息 : Form
    {
        SqlCommand cmd;
        DataSet ds;
        SqlDataReader dr;
        SqlDataAdapter da;
        SqlConnection cn = new SqlConnection();

        public 员工信息()
        {
            InitializeComponent();
        }

        private void Form9_Load(object sender, EventArgs e)
        {
            cn.ConnectionString = "Data Source=sclab76\\SQLEXPRESS;Initial Catalog=医院管理系统;User id=sa;Password=niit#1234";
            cn.Open();

            cmd = new SqlCommand("Select Number,Name from Salary", cn);
            dr = cmd.ExecuteReader();

            while (dr.Read())
            {
                comboBox1.Items.Add(dr["Number"].ToString());
                //comboBox2.Items.Add(dr["Name"].ToString());
            }

            cn.Close();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            cn.ConnectionString = "Data Source=sclab76\\SQLEXPRESS;Initial Catalog=医院管理系统;User id=sa;Password=niit#1234";
            cn.Open();

            ds = new DataSet();
            da = new SqlDataAdapter();
            if (comboBox1.Text == "")
            {
                MessageBox.Show("请输入查询条件");
            }
            else
            {
                    cmd = new SqlCommand("Select * from Salary where Number=@code", cn);
                    cmd.Parameters.Add(new SqlParameter("@code", comboBox1.Text));

            }
            da.SelectCommand = cmd;
            da.Fill(ds, "Salary");

            dataGridView1.DataSource = ds;
            dataGridView1.DataMember = "Salary";

            cn.Close();
        }
    }
}