namespace HRM
{
    public partial class UserManagement : Form
    {
        OpenFileDialog open;
        GlobalData da = new GlobalData();
        public UserManagement()
        {
            InitializeComponent();
   
        }        private void Form1_Load(object sender, EventArgs e)
        {
            try
            {
                DataSet ds = new DataSet();
                SqlDataAdapter sqlda = new SqlDataAdapter("select * from Worker", da.link());
                sqlda.Fill(ds, "Worker");
                workerview.DataSource = ds;
                workerview.DataMember = "Worker";
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
            LoadDepartComboBox();//加载所属部门到列表框
        }
              private void LoadDepartComboBox()
        {//从branchnum表中加载部门数据
            SqlCommand sqlcomm = new SqlCommand
                ("select branchnumID,branchnumname from branchnum", 
                da.link());//加载部门
            SqlDataAdapter sqlda = new SqlDataAdapter(sqlcomm);
            DataSet ds = new DataSet();
            sqlda.Fill(ds);
            branchtxt.DataSource = ds.Tables[0].DefaultView;//指定数据源
            branchtxt.ValueMember = "branchnumID";//指定值成员
            branchtxt.DisplayMember = "branchnumname";//显示名称
        }