通过这个食物种类和价格区间,查询符合要求的Datalist中的食物。
遇到的问题是,我本来用SqlDataSource控件绑定Datalist的,但是,由于我用了PageDataSource,有两个数据源了,冲突了,我就取消了Datalist前台的SqlDataSource控件。但是在这种情况下,我赶脚查询功能貌似我不会实现了······
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
namespace OnlineOrderingSystem.预定服务
{
public partial class OrderingService : System.Web.UI.Page
{
protected static PagedDataSource ps = new PagedDataSource();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Bind(0);
}
}
//进行数据绑定的方法
public void Bind(int CurrentPage)
{
//实例化SqlConnection对象
SqlConnection sqlCon = new SqlConnection();
//实例化SqlConnection对象连接数据库的字符串
sqlCon.ConnectionString = "server=(local);database=Order;uid=sa;pwd=;";
//定义SQL语句
string SqlStr = "select * from Food";
//实例化SqlDataAdapter对象
SqlDataAdapter da = new SqlDataAdapter(SqlStr, sqlCon);
//实例化数据集DataSet
DataSet ds = new DataSet();
da.Fill(ds, "Food");
ps.DataSource = ds.Tables["Food"].DefaultView;
ps.AllowPaging = true; //是否可以分页
ps.PageSize = 4; //显示的数量
ps.CurrentPageIndex = CurrentPage; //取得当前页的页码
this.DataList1.DataSource = ps;
this.DataList1.DataKeyField = "FoodID";
this.DataList1.DataBind();
}
protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
{
switch (e.CommandName)
{
//以下5个为 捕获用户点击 上一页 下一页等时发生的事件
case "first"://第一页
ps.CurrentPageIndex = 0;
Bind(ps.CurrentPageIndex);
break;
case "pre"://上一页
ps.CurrentPageIndex = ps.CurrentPageIndex - 1;
Bind(ps.CurrentPageIndex);
break;
case "next"://下一页
ps.CurrentPageIndex = ps.CurrentPageIndex + 1;
Bind(ps.CurrentPageIndex);
break;
case "last"://最后一页
ps.CurrentPageIndex = ps.PageCount - 1;
Bind(ps.CurrentPageIndex);
break;
case "search"://页面跳转页
if (e.Item.ItemType == ListItemType.Footer)
{
int PageCount = int.Parse(ps.PageCount.ToString());
DropDownList ddl = e.Item.FindControl("DropDownList1") as DropDownList;
int MyPageNum = 0;
MyPageNum = Convert.ToInt32(ddl.SelectedValue);
if (MyPageNum <= 0 || MyPageNum > PageCount)
Response.Write("<script>alert('请输入页数并确定没有超出总页数!')</script>");
else
Bind(MyPageNum - 1);
}
break;
}
}
protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Footer)
{
//以下六个为得到脚模板中的控件,并创建变量
Label CurrentPage = e.Item.FindControl("LabelNowPage") as Label;
Label PageCount = e.Item.FindControl("LabelCount") as Label;
LinkButton FirstPage = e.Item.FindControl("LinkButtonFirstPage") as LinkButton;
LinkButton PrePage = e.Item.FindControl("LinkButtonPrePage") as LinkButton;
LinkButton NextPage = e.Item.FindControl("LinkButtonNextPage") as LinkButton;
LinkButton LastPage = e.Item.FindControl("LinkButtonLastPage") as LinkButton;
CurrentPage.Text = (ps.CurrentPageIndex + 1).ToString();//绑定显示当前页
PageCount.Text = ps.PageCount.ToString();//绑定显示总页数
if (ps.IsFirstPage)//如果是第一页,首页和上一页不能用
{
FirstPage.Enabled = false;
PrePage.Enabled = false;
}
if (ps.IsLastPage)//如果是最后一页"下一页"和"尾页"按钮不能用
{
NextPage.Enabled = false;
LastPage.Enabled = false;
}
DropDownList ddl = e.Item.FindControl("DropDownList1") as DropDownList;
ddl.Items.Clear();
for (int i = 1; i <= ps.PageCount; i++)
{
ddl.Items.Add(i.ToString());
}
}
}
protected void ButtonSelect_Click(object sender, EventArgs e)
{
string wheresql;
if (DropDownListFoodType.SelectedValue == "全部")
{
wheresql = "where FoodPrice Between " + TextBoxLowPrice.Text + " And " + TextBoxHighPrice.Text;
}
else
{
wheresql = "where FoodTypeID =" + DropDownListFoodType.SelectedValue + " and FoodPrice Between " + TextBoxLowPrice.Text + " And " + TextBoxHighPrice.Text;
}
SqlDataSource1.SelectCommand = "SELECT [FoodID],[FoodTypeID],[FoodName],[FoodPrice] ,[FoodIntroduction] ,[FoodCount] ,[FoodImageURL] FROM [Food] " + wheresql + "order by [FoodPrice] desc";
//我原来的思路是通过SqlDataSourceS实现功能,这里还有个Datalist.Bind();
ViewState["SelectCommand"] = SqlDataSource1.SelectCommand;
}
}
}
请问大神们,有没有不用sqlDataSource,实现查询的方法·····
说的比较乱,见谅