train.aspx.cs

最优客运乘车路线系统 --作者：山东农业大学 2006级信息与计算科学 张知临 --小组成员：彭建

using System;
using System.Data;
using System.Configuration;
using System.Collections;
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;

public partial class train : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        search_Click(sender, e);//因为每次翻页，页面都需要重新加载，所以在Page-Load中要重新执行搜索。
       
    }
    protected void search_Click(object sender, EventArgs e)
    {
        /*-----------------------------------------------------------------------------------
         * 连接数据源： DBTrains
         * 调用存储过程
         * 加入参数
         * 绑定
        ---------------------------------------------------------------------------------------*/

        SqlConnection con = new SqlConnection("Server=SDAU-B98C4F1625;Database=DBTrains;Uid=sa;Pwd=;Trusted_Connection=False");
            con.Open();
            SqlDataAdapter sd = new SqlDataAdapter("zuiyou1", con);
            sd.SelectCommand.CommandType = CommandType.StoredProcedure;
            
            
            SqlParameter[] para ={
            new SqlParameter("@ssta",SqlDbType.VarChar,50),  //将参数放入数组
            new SqlParameter("@esta",SqlDbType.VarChar,50)

                                };
            para[0].Value = ssta.Text.Trim();
            para[1].Value = esta.Text.Trim();//赋值时单个单个的赋值
            
            //将参数加入到数据源中
            foreach (SqlParameter i in para)
            {
                sd.SelectCommand.Parameters.Add(i);
            }
            
            DataSet ds = new DataSet();
            sd.Fill(ds);
            
            GridView1.DataSource = ds;
            GridView1.DataBind();
        
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        
        
          GridView1.PageIndex = e.NewPageIndex;
          this.GridView1.DataBind();
    }
    

    
}