如何在多个表里取出自己想要的列

[yu_shu]

string Sql2 ="select blog_LinkCategories.Title, blog_Content.Title,blog_Content.ID,blog_LinkCategories.CategoryID from blog_LinkCategories left outer join blog_Links on blog_LinkCategories.CategoryID = blog_Links.CategoryID left outer join blog_Content on blog_Links.PostID = blog_Content.ID where blog_LinkCategories.ParentID=-1 and blog_LinkCategories.CategoryType = 6 and blog_LinkCategories.Active = 1 Order by DateAdded desc";

现把它做成了myDataSet的数据集
请问
如何把blog_LinkCategories.Title这一列取出来

[sskset]

myDataSet.Table[0].Columns["Title"]

[yu_shu]

sorry，他还有一个表，我是想做Repeater嵌套，所以才这样的 ，只是子列我不会
string Sql1 = "select Title,CategoryID from blog_LinkCategories where blog_LinkCategories.ParentID=-1 and blog_LinkCategories.CategoryType = 6 And blog_LinkCategories.Active = 1 Order BY blog_LinkCategories.UpdateTime desc";
//Sql2之所以与blog_LinkCategories选出来是为了让网站分类没有随笔的都选出来
string Sql2 ="select blog_LinkCategories.Title, blog_Content.Title,blog_Content.ID,blog_LinkCategories.CategoryID from blog_LinkCategories left outer join blog_Links on blog_LinkCategories.CategoryID = blog_Links.CategoryID left outer join blog_Content on blog_Links.PostID = blog_Content.ID where blog_LinkCategories.ParentID=-1 and blog_LinkCategories.CategoryType = 6 and blog_LinkCategories.Active = 1 Order by DateAdded desc";
SqlConnection myConnection = new SqlConnection(Conn);
myConnection.Open();

SqlDataAdapter myDataAdapter1 = new SqlDataAdapter(Sql1,myConnection);
DataSet myDataSet = new DataSet();
myDataAdapter1.Fill(myDataSet);

SqlDataAdapter myDataAdapter2 = new SqlDataAdapter(Sql2,myConnection);
myDataAdapter2.Fill(myDataSet);

myDataSet.Relations.Add("myRelation",myDataSet.Tables["blog_LinkCategories"].Columns["CategoryID"],myDataSet.Tables[1].Columns["CategoryID"]);

[dahuzizyd]

直接写视图不行吗？