110,538
社区成员
发帖
与我相关
我的任务
分享
m_class.dll
public class m_userlist
{
public DataGridView userlist_load(DataGridView u_data)
{
//读取用户列表
m_sql_conn fee_conn = new m_sql_conn();
SqlConnection conn = new SqlConnection(fee_conn.sql_conn());
SqlCommand cmd = new SqlCommand(userload,conn);
find_do = new SqlDataAdapter();
find_do.SelectCommand = cmd;
ds = new DataSet();
try
{
u_data.RowHeadersVisible = false;
find_do.Fill(ds, "rs");
}
catch(System.Exception)
{
MessageBox.Show("数据库连接失败", "数据读未读取", MessageBoxButtons.OK);
return null;
}
u_data.DataSource = ds.Tables["rs"];
for (int k = 0; k < u_data.Columns.Count; k++)
{
u_data.Columns[k].SortMode = DataGridViewColumnSortMode.NotSortable;
}
return u_data;
}
}
DataGridView控件所在窗体 m_usermange.cs DGV控件名:d_userlist
private void formload()
{
m_userlist users = new m_userlist();
users.userlist_load(d_userlist);
}
public void form_load()
{
formload();
}
修改数据库窗体 m_useredit.cs 代码:
[code=C#]
m_userlist card_up = new m_userlist();
card_up.user_save(int.Parse(m_usermange.user_id), t_pwd.Text, t_rname.Text, flag, sale, usermanage,
salemanage, allreport,classreport,dbset,dbmanage, deadcard, cardnumset, cardmanage);
m_usermange refresh = new m_usermange();
refresh = (m_usermange)this.Owner;
refresh.form_load();