RT.初学者.三层架构模式下写了个程序.这是我的表示层代码:
EmployeeManager epm = new EmployeeManager();
private void button1_Click(object sender, EventArgs e)
{
this.dataGridView1.DataSource = epm.GetAll();
}
private void EmployeeInformation_Load(object sender, EventArgs e)
{
this.dataGridView1.AutoGenerateColumns = false;
this.dataGridView1.DataSource = epm.GetAll();
}
业务层
public List<Employee> GetAll()
{
return es.GetAll();
}
访问层
public List<Employee> GetAll()
{
List<Employee> list = new List<Employee>();
string sql = "select * from employee";
DataTable dt = DBHelper.GetDataTable(sql); foreach (DataRow dr in dt.Rows)
{
Employee emp = new Employee();
emp.Eid = Convert.ToInt32(dr[0]);
emp.Ename = Convert.ToString(dr[1]);
emp.Eidentitycard=Convert.ToString(dr[2]);
emp.Ebirthday = Convert.ToString(dr[3]);
emp.Emale = Convert.ToString(dr[4]);
emp.Edegree = Convert.ToString(dr[5]);
emp.Eemail = Convert.ToString(dr[6]);
emp.Ephone = Convert.ToString(dr[7]);
emp.Edepartment = Convert.ToString(dr[8]);
emp.Eposition = Convert.ToString(dr[9]);
emp.Esalarygrade = Convert.ToString(dr[10]);
emp.Enote = Convert.ToString(dr[11]);
emp.Eentrydate = Convert.ToString(dr[12]);
list.Add(emp);
}
return list;
}
模型层就是设置了些属性.编译的时候没有错误. 就是运行的时候dgv不显示数据...希望有高手帮忙解决一下.谢谢
EmployeeManager epm = new EmployeeManager();
private void button1_Click(object sender, EventArgs e)
{
this.dataGridView1.DataSource = epm.GetAll();
}
private void EmployeeInformation_Load(object sender, EventArgs e)
{
this.dataGridView1.AutoGenerateColumns = false;
this.dataGridView1.DataSource = epm.GetAll();
}
业务层
public List<Employee> GetAll()
{
return es.GetAll();
}
访问层
public List<Employee> GetAll()
{
List<Employee> list = new List<Employee>();
string sql = "select * from employee";
DataTable dt = DBHelper.GetDataTable(sql); foreach (DataRow dr in dt.Rows)
{
Employee emp = new Employee();
emp.Eid = Convert.ToInt32(dr[0]);
emp.Ename = Convert.ToString(dr[1]);
emp.Eidentitycard=Convert.ToString(dr[2]);
emp.Ebirthday = Convert.ToString(dr[3]);
emp.Emale = Convert.ToString(dr[4]);
emp.Edegree = Convert.ToString(dr[5]);
emp.Eemail = Convert.ToString(dr[6]);
emp.Ephone = Convert.ToString(dr[7]);
emp.Edepartment = Convert.ToString(dr[8]);
emp.Eposition = Convert.ToString(dr[9]);
emp.Esalarygrade = Convert.ToString(dr[10]);
emp.Enote = Convert.ToString(dr[11]);
emp.Eentrydate = Convert.ToString(dr[12]);
list.Add(emp);
}
return list;
}
模型层就是设置了些属性.编译的时候没有错误. 就是运行的时候dgv不显示数据...希望有高手帮忙解决一下.谢谢
this.dataGridView1.DataBind();
加一句,初始化也要
这一句
DBHelper类是怎么写的?看看该类能否返回一个充满数据的DataTable?
this.dataGridView1.DataSource = new BindingList<Employee>(epm.GetAll());
搞清楚winform和webform
搞清楚datagridview和gridview的区别
断点根跟进,dataable有数据吗
{
SqlDataAdapter da = new SqlDataAdapter(sql, DBHelper.Connection);
DataSet ds = new DataSet();
da.Fill(ds);
return ds.Tables[0];
}
this.dataGridView1.DataSource = epm.GetAll();
this.dataGridView1.DataBind();
这儿错误; 必须是true;为false的话DataGridView没有生成列,就不显示,OK?
上次偶弄这个整了老长时间;