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";//显示名称
}
{
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";//显示名称
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货