UI层
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
Title="PersonnelUI" Height="300" Width="300" Loaded="Window_Loaded">
private void LoadData()
{
Perget.ItemsSource = new DalPersonnel().ListAll();
}
DAL层
public Personnel[] ListAll()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * ");
strSql.Append("from Personnel ");
DataTable table = OleDbHelper.ExecuteDataset(conn, strSql.ToString()).Tables[0];
Personnel[] items = new Personnel[table.Rows.Count];
for (int i = 0; i < table.Rows.Count; i++)
{
Personnel personnel = ToModel(table.Rows[i]);
items[i] = personnel;
}
return items;
}
public Personnel ToModel(DataRow row)
{
Personnel per = new Personnel();
per.Address=(string)row["Address"];
per.PerID=(int)row["PerID"];
per.Phone=(string)row["Phone"];
per.UserName=(string)row["UserName"];
return per;
}
运行后数据绑定一直是空白的 access里是有数据的 找了一宿了 求大神看看那里错了谢谢
Perget.ItemsSource = new DalPersonnel().ListAll();
Perget.Bind(); //加上这个看看