namespace News.Business
{
public class News
{
public DataTable GetNewsList(string strCond)
{
DataSet ds = new DataSet();
string strSql = "select a.*,CategoryName from News_News a inner join News_Category b on a.CategoryId=b.CategoryId " + strCond + " order by NewsDate desc";
Database db = DatabaseFactory.CreateDatabase();
DbCommand cmd = db.GetSqlStringCommand(strSql);
try
{
ds = db.ExecuteDataSet(cmd); ;
}
catch (Exception ex)
{
this.ErrMsg = ex.Message.ToString();
}
return ds.Tables[0];
}另一个文件using News.Business;private void SetBind()
{
this.gvNewsList.DataSource = news.GetNewsList();
this.gvNewsList.DataBind();
}我怎么从news.getnewslist中筛选数据啊
{
public class News
{
public DataTable GetNewsList(string strCond)
{
DataSet ds = new DataSet();
string strSql = "select a.*,CategoryName from News_News a inner join News_Category b on a.CategoryId=b.CategoryId " + strCond + " order by NewsDate desc";
Database db = DatabaseFactory.CreateDatabase();
DbCommand cmd = db.GetSqlStringCommand(strSql);
try
{
ds = db.ExecuteDataSet(cmd); ;
}
catch (Exception ex)
{
this.ErrMsg = ex.Message.ToString();
}
return ds.Tables[0];
}另一个文件using News.Business;private void SetBind()
{
this.gvNewsList.DataSource = news.GetNewsList();
this.gvNewsList.DataBind();
}我怎么从news.getnewslist中筛选数据啊
this.gvNewsList.DataSource = bus.GetNewsList(strCond); 你是要这样?
可以从 sql语句选取响应的数据,二楼的方法 是可以的
Dv1.RowFilter = "id=1";
this.gvNewsList.DataSource = Dv;
this.gvNewsList.DataBind();
还有不明白的可以看这个帖子:http://www.cnblogs.com/caicaihui/archive/2007/12/06/984978.html
比如
news.GetNewsList().Select("id>3")
Dv1.RowFilter = "id=1";
this.gvNewsList.DataSource = Dv;
this.gvNewsList.DataBind();
上面是dataview ,
或datatable.select()
二种都可以.
Dv1.RowFilter = "id=1";
this.gvNewsList.DataSource = Dv;
this.gvNewsList.DataBind();
上面是dataview ,
或datatable.select()
二种都可以.
datatable.select()
而且该方法返回的是DataTable类型,楼主也可以用DataTable的Select来筛选