111,130
社区成员
发帖
与我相关
我的任务
分享datareder 如何读出级联表的字段?
SqlCommand MSCmd = new SqlCommand(@"select * from Person_reg as P
inner join person as r
on p.id=r.id", MSSQLConn);
SqlDataReader MyReader = MSCmd.ExecuteReader();
while (MyReader.Read())
{
StringBuilder RowInfo = new StringBuilder();
for (int i = 0; i < MyReader.FieldCount; i++)
{
RowInfo.Append(" " + MyReader[i].ToString());
}
try
{
Console.Write(Myreder["r.username"].ToString());/// 这,我应该怎么读第2个表的这个字段???
}
}
inner join person as r
on p.id=r.id", MSSQLConn);
SqlDataReader MyReader = MSCmd.ExecuteReader();
while (MyReader.Read())
{
StringBuilder RowInfo = new StringBuilder();
for (int i = 0; i < MyReader.FieldCount; i++)
{
RowInfo.Append(" " + MyReader[i].ToString());
}
try
{
Console.Write(Myreder["r.username"].ToString());/// 这,我应该怎么读第2个表的这个字段???
}
}
...全文
