gridviewusage.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 GridViewUsage : System.Web.UI.Page
{


    
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Session["userID"] == null || Session["userID"].ToString() == "")
            {

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

                lblID.Text = Session["userID"].ToString();
                detailsAllBind();
            }
        }
    }
  
    //private void databind()
    //{
    //    operation op = new operation();
    //    SqlDataReader dr = op.GetAll();
    //    GVUsage.DataSource = dr;
    //    GVUsage.DataBind();
    //    dr.Close();
        
    //}
    private void dataBind()
    {
        string ID = Session["UserID"].ToString();
        string sql1 = "select * from addresslist where userID='" + ID + "'order by id desc";
       DataBase db = new DataBase();
       DataSet ds = db.DataAll(sql1);
       
       GVUsage.DataSource = ds;
       GVUsage.DataKeyField = "id";
       GVUsage.DataBind();
       ShowStatsPage();
       return;
    }

    protected void BtnAdddata_Click(object sender, EventArgs e)
    {
        operation op1 = new operation();
        string msg = op1.Add(lblID.Text, textName.Text, textPhone.Text, textMobile.Text, textAddress.Text, TextQQ.Text, textEmail.Text);
        if (msg == "")
        {
            lblmsg.Text = "好友资料添加成功!";
          
        }
        else 
        {
            lblmsg.Text = msg;
        }
    }
    protected void GVUsage_SelectedIndexChanged(object sender, EventArgs e)
    {

    }
    protected void GVUsage_PageIndexChanged(object sender, EventArgs e)
    {
       
    }

    protected void GVUsage_PageIndexChanged1(object source, DataGridPageChangedEventArgs e)
    {
        GVUsage.CurrentPageIndex = e.NewPageIndex;
        dataBind();
    }
    protected void btnGo_Click(object sender, EventArgs e)
    {

        try
        {
            if (txtGoPage.Text.Trim() != "")
            {
                int PageI = Int32.Parse(txtGoPage.Text.Trim()) - 1;
                if (PageI >= 0 && PageI < (GVUsage.PageCount))
                    GVUsage.CurrentPageIndex = PageI;


            }

        }
        catch 
        {
           
            Response.Write("<script language=javascirpt type='text/javascript'>");
            Response.Write("window.alert('输入非数字字符，请重新输入！')");
            Response.Write("</script>"); 
        }
       
      
        dataBind();
        }
    
    void ShowStatsPage()
    { 
    lblCurrentIndex.Text="当前为第"+((int)GVUsage.CurrentPageIndex+1)+"页";
    lblPageCount.Text="共"+GVUsage.PageCount+"页";
    
    
    }

    protected void PagerButtonClick(object sender, EventArgs e)
    {
        string arg = ((LinkButton)sender).CommandArgument.ToString();
       
        switch (arg)
        { 
            case "next":
                if (GVUsage.CurrentPageIndex < (GVUsage.PageCount - 1))
                {

                    GVUsage.CurrentPageIndex += 1;
                }
                break;
            case"prev":
                if(GVUsage.CurrentPageIndex>0)
                {
                GVUsage.CurrentPageIndex-=1;
                }
                break;
            case "last":
                GVUsage.CurrentPageIndex=(GVUsage.PageCount-1);
                break;
            case "fist":
                GVUsage.CurrentPageIndex = 0;
                break;
            default:
                GVUsage.CurrentPageIndex=System.Convert.ToInt32(arg);
                break;
        
        
        }
        dataBind();
        ShowStatsPage();
    }
    protected void GVUsage_SelectedIndexChanged1(object sender, EventArgs e)
    {
        ViewState["id"] = GVUsage.DataKeys[GVUsage.SelectedIndex].ToString();
        detailsBind();

    }
    private void detailsBind()
    {
        SqlConnection conn1 = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
        string detailsID = ViewState["id"].ToString();
        string sql2 = "select id,userId,frdName,frdPhone,frdMobilePhone,frdAddress,frdQQ,frdEmail from addresslist where id='" + detailsID + "'";
        conn1.Open();
        SqlCommand cmd = new SqlCommand(sql2, conn1);
        SqlDataReader myReader = cmd.ExecuteReader();
        DetailsView1.DataSource = myReader;
        DetailsView1.DataBind();
        myReader.Close();


    
    
    }
    private void detailsAllBind()
    {
        SqlConnection conn2 = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
        string sql3 = "select * from addresslist order by id desc";
        conn2.Open();
        SqlDataAdapter da = new SqlDataAdapter(sql3, conn2);
        DataSet ds=new DataSet();
        da.Fill(ds, "detailsTable");
        DetailsView1.DataSource = ds;
        DetailsView1.DataBind();
        conn2.Close();
    
    
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        textAddress.Text = "";
        textEmail.Text = "";
        textMobile.Text = "";
        textName.Text = "";
        textPhone.Text = "";
        TextQQ.Text = "";
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        Page.Response.Redirect("GridViewUsage.aspx");
    }
    protected void textName_TextChanged(object sender, EventArgs e)
    {
     
    }
}