DataSet中的数据在与GridView中绑定数据中间的转换

Question

select CMS_Articles.title,ArticleFrom,CMS_Categories.Title from CMS_Articles 
                                              join CMS_Categories
                                     on CMS_Categories.CategoryID=CMS_Articles.CategoryID

Answer 1

//CMS_Articles 新闻列表，CMS_Categories新闻类别表
CMS_Articles.title新闻标题，ArticleFrom新闻来源，CMS_Categories.Title新闻类别标题。
两个表进行联结查询，所以建议你弄两个表select CMS_Articles.title,ArticleFrom,CMS_Categories.Title from CMS_Articles 
                                              join CMS_Categories
                                     on CMS_Categories.CategoryID=CMS_Articles.CategoryID

Answer 2

可以实现。
GridView1_OnRowDataBound(object sender,GridViewRowEventArgs e)
{
  if(e.Row.RowType == DataControlRowType.DataRow)
   Case Int.Parse(e.Row.Cells[index].Text)
    1:
     e.Row.Cells[index].Text="一等品";
     break;
    2:
     e.Row.Cells[index].Text.="二等品";     ....
  }
}