绑定到集合的相关技巧

1.DataTable与ObservableCollection互换
ObservableCollection<CustomerModel> models;
DataTable dataTable = SQLHelper.ExecteAdapter("select top 0 * from Customer", CommandType.Text, null);
foreach (var m in models)
{
DataRow dataRow = dataTable.NewRow();
dataRow[1] = m.Name;
dataRow[2] = m.Add;
dataRow[3] = m.Email;
dataRow[4] = m.Phone;
dataTable.Rows.Add(dataRow);
}
from: http://www.cnblogs.com/Kingly/archive/2012/08/22.html

private ObservableCollection<WebSiteItem> siteItems = new ObservableCollection<WebSiteItem>();
DbDataReader dr = dbHelper.ExecuteReader(dbHelper.GetSqlStringCommond("select * from st_sites"));
siteItems.Clear();
while (dr.Read())
{
siteItems.Add(new WebSiteItem(
(int)dr["s_id"],
(string)dr["site_name"],
(string)dr["site_url"],
(string)dr["site_desc"],
(int)dr["depth"],
(string)dr["need_filter"]
));
}

2.DataGrid使用技巧
http://blog.csdn.net/sanjiawan/article/details/6785394

DataGrid绑定到DataTable
DataRowView selectedItem = sitesDataGrid.SelectedItem as DataRowView;
再以selectedItem[index]或者selectedItem["fieldname"]获取数据。

绑定到对象list
sitesDataGrid.SelectedItem as 对象即可。