读书人

两次输出数据到页面第二回输出怎样不

发布时间: 2011-12-23 23:32:01 作者: rapoo

两次输出数据到页面,第二次输出怎样不包扩第一次的数据?
Sql = "Select top 9 ID ,Title From Image_Topic Where GroupID = 13 Order By AddTime Desc ";
Comm = new SqlCommand( Sql, Conn );
Adapter = new SqlDataAdapter( Comm );
Adapter.Fill(Rs);
Table = Rs.Tables[0];
//把数据输出页面一

Sql = "Select top 9 ID ,Title From Image_Topic Where GroupID = 10 Order By AddTime Desc ";
Comm = new SqlCommand( Sql, Conn );
Adapter = new SqlDataAdapter( Comm );
Adapter.Fill(Rs);
Table = Rs.Tables[0];
//把数据输出页面二,问题是输出二里竟然包括输出一!是不是我哪里没关闭?

[解决办法]
输出页面二前要清理数据集
Sql = "Select top 9 ID ,Title From Image_Topic Where GroupID = 10 Order By AddTime Desc ";
Comm = new SqlCommand( Sql, Conn );
Adapter = new SqlDataAdapter( Comm );
Rs.Clear();
Adapter.Fill(Rs);
Table = Rs.Tables[0];

读书人网 >asp.net

热点推荐