用Sql语句不就可以了? string SQL = "select * from News Inner Join Type On News.TypeID = Type.ID"; DataAdapter da = new SqlDataAdapter (conn, SQL); DataSet ds = new DataSet(); da.Fill(ds,"News");
下面是我参照楼上的写的程序 Dim sql As String = "select id,title,addtime,fid from news Inner Join news_fenlei On News.fid = news_fenlei.id where ishomepage=1 order by news.id desc" Dim comm As New SqlDataAdapter(sql, conn.dbconn) Dim ds As New DataSet comm.Fill(ds, "news") news.DataSource = ds.Tables("news") Me.DataBind()页面引用 <%#container.dataitem("fid")%>运行后错误提示:名 'id' 不明确。 这是怎么回事,请问应该如何修改?
Dim sql As String = "select news.id,news.title,news.addtime,news.fid from news Inner Join news_fenlei On News.fid = news_fenlei.id where ishomepage=1 order by news.id desc" Dim comm As New SqlDataAdapter(sql, conn.dbconn) Dim ds As New DataSet comm.Fill(ds, "news") news.DataSource = ds.Tables("news") Me.DataBind()
string SQL = "select * from News Inner Join Type On News.TypeID = Type.ID";
DataAdapter da = new SqlDataAdapter (conn, SQL);
DataSet ds = new DataSet();
da.Fill(ds,"News");
Dim sql As String = "select id,title,addtime,fid from news Inner Join news_fenlei On News.fid = news_fenlei.id where ishomepage=1 order by news.id desc"
Dim comm As New SqlDataAdapter(sql, conn.dbconn)
Dim ds As New DataSet
comm.Fill(ds, "news")
news.DataSource = ds.Tables("news")
Me.DataBind()页面引用
<%#container.dataitem("fid")%>运行后错误提示:名 'id' 不明确。
这是怎么回事,请问应该如何修改?
Dim comm As New SqlDataAdapter(sql, conn.dbconn)
Dim ds As New DataSet
comm.Fill(ds, "news")
news.DataSource = ds.Tables("news")
Me.DataBind()