HospitalInformation/AdmDoc_Detail.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

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 HospitalInformation
{
    public partial class AdmDoc_Detail : Form
    {
        public AdmDoc_Detail()
        {
            InitializeComponent();
        }

        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {

        }

        private void 返回ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void AdmDoc_Detail_Load(object sender, EventArgs e)
        {
            SqlDataAdapter da;
            DataSet ds;
            string sql = "select DoctorNo AS 医生号,DoctorName AS 医生登录名,DoctorPwd AS 医生登录密码,DoctorDutyTime AS 医生值班时间,DoctorSection AS 医生科室,DoctorGender AS 医生性别,DoctorBirthDate AS 医生出生日期,DoctorTitle AS 医生职称,DoctorRegistrationPrice AS 医生挂号费用 from Doctor order by DoctorNo desc";
            using (SqlConnection conn = new SqlConnection(DBHelper.connString))
            {
                da = new SqlDataAdapter(sql, conn);
                ds = new DataSet();
                da.Fill(ds);
                dgv_DocDetail.DataSource = ds.Tables[0];
            }
        }

        private void menuStrip1_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
        {

        }
    }
}