this.DataGrid1.DataSource = new DataProviders().ExecuteSqlDs("select * from YongShop..ShopItemMap a,WEB_ITEMTYPE b where b.used=1 and a.ItemType=b.id and ItemStock>0" + this.sqlwhere, "DataGrid1");
this.DataGrid1.CurrentPageIndex = 0;
this.DataGrid1.DataBind();