在读取文章列表时如果针对ClassID从Class表中将ClassName的值读取出来
所属类别 标题
12 asdfadsf
13 eeeeeeerrrr
12 ererererer
10 fefe33f3f3
(如何将上面的ClassID换成ClassName的值?)
我的解决方法是:
代码页面:
<asp:BoundField HeaderText="所属分类" DataField="classname" />
cs页面:
sqlstr = "select *,(select ClassName from News_Class where ClassID=News.ClassID) as ClassName from News";
//连接到数据库
String strCon = ConfigurationManager.ConnectionStrings["test1"].ConnectionString;
SqlConnection sqlcon = new SqlConnection(strCon);
SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);
DataSet myds = new DataSet();
sqlcon.Open();
myda.Fill(myds, "news");
GridView1.DataSource = myds;
GridView1.DataKeyNames = new string[] { "id" };//主键
GridView1.DataBind();
sqlcon.Close();