判断大于几并且小于几的代码怎么写

[duanpengde]

#region 经典案例
public void ShowProductView2Info()
{
WebProject.BLL.BaseData.ZT_COM_Product bll_Product = new WebProject.BLL.BaseData.ZT_COM_Product();
DataSet ds = bll_Product.GetList(int.MaxValue, "ProductID>6", "ProductOrder asc");
if (ds.Tables.Count > 0)
{
this.DLProduct2.DataSource = ds;
this.DLProduct2.DataBind();
}
#endregion
}
}



我想把这段代码里的PRODUCTID>6 写成大于6小于9 该怎么写呢

[tan598121925]

PRODUCTID>6 and PRODUCTID<9

[newxdlysk]

DataSet ds = bll_Product.GetList(int.MaxValue, "ProductID>6 and ProductID<9", "ProductOrder asc");