如题!例如:有2个表
表1:UserInfo--表名 UID-字段 UName-字段 URole-外键对应到UserRole的主键RID
UserRole--表名 RID-字段 RName-名称
DataGridView绑定了数据表UserInfo 那么怎么绑定URole呢??
表1:UserInfo--表名 UID-字段 UName-字段 URole-外键对应到UserRole的主键RID
UserRole--表名 RID-字段 RName-名称
DataGridView绑定了数据表UserInfo 那么怎么绑定URole呢??
{
NewsManagement nm = new NewsManagement();
tb_news[] nList = nm.getNewsInfo(); var source = from n in nList
select new
{
NewsID = n.NewsID,
NewsDate = n.NewsDate,
NewsTitle = n.NewsTitle,
NewsCategoryName = n.tb_newscategory.NewsCategoryName
}; this._newsInfoGridView.DataSource = source;
this._newsInfoGridView.DataBind();
}
1.用实体类,绑定外键对象
class UserInfo
{
string uid = ""; public string Uid
{
get { return uid; }
set { uid = value; }
}
string uname = ""; public string Uname
{
get { return uname; }
set { uname = value; }
}
URole role = new URole(); public URole Role
{
get { return role; }
set { role = value; }
}
}
查的时候把URole也查了填充进去
绑定字段的时候<%#Eval("Role.RName")%> ,这样就可以实现绑定了。
2. 先绑定UserInfo信息,URole先空着, 然后在RowDataBound事件里面再来绑定URole
private void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (e.ColumnIndex==2 && e.Value is int)
{
int i= (int)e.Value;
e.Value = "";
}
}