先来看一下数据和结果
两个表的数据
再来看一下内联查询后的结果
select
contactId, contactName, cellPhone, gp.groupid,gp.groupName
from[dbo].[TblContact] as co inner join[dbo].[TblContactGroup] as gp on co.groupid = gp.groupid
最终读取到datagridview后的样子
初步的数据读取语句
//初始化datagridview数据
string sql = "select contactId, contactName, cellPhone, gp.groupid,gp.groupName from[dbo].[TblContact] as co inner join[dbo].[TblContactGroup] as gp on co.groupid = gp.groupid";
//调reader
//数据读到list
List<TblContact><