selectdata.aspx.cs

开发工具：Visual Studio 2005 开发平台：Windows XP sp2 数据库：Sql server 2000 从学校走入社会

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 selectData : System.Web.UI.Page
{
    SqlConnection conn;
    
    string sql1 = "select [id],selectname from listname";
    string sql2 = "select * from addresslist where ";
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Session["userID"] == null || Session["userID"].ToString() == "")
            {

                Page.Response.Redirect("default.aspx");
            }
            else
            {
                ddldataBind();

                dataBind();
            }
        }
    }
    private void dataBind()
    {
        
        string Myid = Session["UserID"].ToString();
       string sql = "select * from addresslist where userID='"+Myid+"'order by id desc ";
       SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
        SqlDataAdapter da = new SqlDataAdapter(sql, conn);
        DataSet ds = new DataSet();
        conn.Open();
        da.Fill(ds, "addressTable");
        GridView1.DataSource = ds;
        GridView1.DataKeyNames = new string[] { "id" };
        GridView1.DataBind();
        conn.Close();
    
    
    
    }
    private void ddldataBind()
    {
        conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
        SqlDataAdapter da = new SqlDataAdapter(sql1, conn);
        DataSet ds = new DataSet();
        conn.Open();
        da.Fill(ds, "DDLTable");
        DropDownList1.DataSource = ds;
        DropDownList1.DataTextField = "selectname";
      
        DropDownList1.DataBind();
        conn.Close();
        
    
    
    }
    protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {

    }
    protected void BtnSelect_Click(object sender, EventArgs e)
    {
        conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
        string selectID = DropDownList1.SelectedValue.ToString();
        string txtinfo = TextBox1.Text.Trim();
        if (selectID == "好友姓名")
        {
            sql2 += "frdName like '%" + txtinfo + "%'";
        
        }
        else if (selectID == "地址")
        {
        
        sql2+="frdAddress like '%"+txtinfo+"%'";
        
        }
        else if (selectID == "好友QQ号")
        {
            sql2 += "frdQQ like '" + txtinfo + "'";



        }
        else
        {

            sql2 += "frdMobilePhone like '" + txtinfo + "'";
        
        }
        conn.Open();
        //SqlCommand cmd = new SqlCommand(sql2, conn);
        //SqlDataReader dr = cmd.ExecuteReader();
        SqlDataAdapter da = new SqlDataAdapter(sql2, conn);
        DataSet ds = new DataSet();
        da.Fill(ds, "selectData");

        GridView1.DataSource = ds;
      
      
        GridView1.DataBind();
        if (GridView1.Rows.Count == 0)
        {
            lblMsg.Text = "未找到您所需要的信息！";
            lblMsg.Style["color"] = "red";

        }
        else
        {
            lblMsg.Text = "搜索完毕！";
            lblMsg.Style["color"] = "red";
        
        }
        conn.Close();
       
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        dataBind();
    }
}