cst_user_select.aspx.cs

小型的一个简单的系统开发的实现了简---添加--删除--修改---（vs2005和SQl2005）用到了一些JS脚本

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;
using System.Xml;
 /***************************************************************************************/
 /*   File Name	: CST_user_select.aspx                                                  */
 /* Description	: select users                                                          */
 /*Programmer 	: zhaoqiongyan                                                          */
 /* Version      :v_0.2                                                                 */
 /***************************************************************************************/




public partial class Admin_CST_uses_add : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=cst;Integrated Security=True");
        con.Open();
        SqlDataAdapter da = new SqlDataAdapter("select * from Users", con);
        DataSet ds = new DataSet();
        da.Fill(ds);
        this.GridView1.DataSource = ds;
        this.GridView1.DataBind();//查询语句的代码，查询过后就在Gridview中显示出来


        if (!IsPostBack)//首次登陆页面时，判断是否为空
        {
            ddlband();
        }

    }
    protected void ddlband()
    {
        SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=cst;Integrated Security=True");
        con.Open();
        SqlDataAdapter da = new SqlDataAdapter("select * from Users", con);// 查询语句
        DataSet ds = new DataSet();
        da.Fill(ds);//数据集的填充
        this.ddl_user_name.DataSource = ds;//把填充的数据集绑定到下拉列表中
        this.ddl_user_name.DataTextField = "name";//用户名的绑定，它和用户的Id是配对的，就好比姓名和身份证的关系
        this.ddl_user_name.DataValueField = "user_id";//用户ID的绑定
        this.ddl_user_name.DataBind();
    }
    protected void gridviewband()
    {
        SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=cst;Integrated Security=True");
        con.Open();
        SqlDataAdapter da = new SqlDataAdapter("select * from Users", con);
        DataSet ds = new DataSet();
       
        da.Fill(ds);
        this.GridView1.DataSource = ds;//数据源的来源
        this.GridView1.DataBind();//把数据表中的数据绑定到G ridview中
    }
    protected void Button1_Click(object sender, EventArgs e)
    {

        if (ddl_user_name.SelectedItem.Text == "全部")
        {
            gridviewband();
           
        }
        else
        {
            string strName = ddl_user_name.SelectedItem.Text;
            SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=cst;Integrated Security=True");
            con.Open();
            SqlDataAdapter da = new SqlDataAdapter("select * from Users where name='"+strName+"'", con);
            DataSet ds = new DataSet();
            da.Fill(ds);
            this.GridView1.DataSource = ds;//数据源的来源
            this.GridView1.DataBind();//把数据表中的数据绑定到G ridview中
        }
    }
    protected void Button4_Click(object sender, EventArgs e)
    {
        string strID = null;
        
        Response.Write("<script>window.open('CST_user_add.aspx?id=" + strID + "','','width=500,height=250,Resizable=no,toolbar=no, menubar=no, scrollbars=no,top=300,left=300, resizable=no,location=no, status=no')</script>");
    }
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)//对行GridView1_RowEditing的编译
    {
        //int i;
        //string n;
        //string n = e.Item.cloums[0].text;
        //string sqldeletet;
        //sqldeletet="update Users set user_id='" + TextBox1.Text + "',name='" + TextBox2.Text + "'";
        //ss.sqldelete();
        
        //Response.Write("<script>window.open('CST_user_edit.aspx?id=" + GridView1.DataKeys[e.NewEditIndex].Value.ToString() + "','','width=400,height=350,Resizable=no,toolbar=no, menubar=no, scrollbars=no,top=300,left=300, resizable=no,location=no, status=no')</script>");
        ////弹出一个新的页面
        string strID = GridView1.DataKeys[e.NewEditIndex].Value.ToString();
        Response.Write("<script>window.open('CST_user_edit.aspx?id=" + strID + "','','width=400,height=350,Resizable=no,toolbar=no, menubar=no, scrollbars=no,top=300,left=300, resizable=no,location=no,status=no')</script>");


    }
  protected void Button3_Click(object sender, EventArgs e)
    {
        string FileName = Server.MapPath("../admin/user.xml");//获取路径
        string Xml_user;


        //Clear xml doument
        XML_user oXcust = new XML_user();//实例化


        XmlDocument oXmlDoc = new XmlDocument();
        oXmlDoc.Load(FileName);

        XmlNode root = oXmlDoc.DocumentElement;


        while (root.ChildNodes.Count>0)
        {
            root.RemoveChild(root.FirstChild); 
        }
        oXmlDoc.Save(FileName);
      




        //input data into xml
        int count_number = GridView1.Rows.Count;
        if (count_number > 0)
        {
            for (int i = 0; i < count_number; i++)
            {
                string ID = GridView1.Rows[i].Cells[0].Text.ToString();
                string Xm = GridView1.Rows[i].Cells[1].Text.ToString();
                string pwd = GridView1.Rows[i].Cells[2].Text.ToString();
                string email = GridView1.Rows[i].Cells[3].Text.ToString();
                oXcust.WriteXml(FileName, ID, Xm, pwd, email); //把数据表中的数据导出到一个相应的XML文件中

            }
        }
       // oXmlDoc.Save(FileName);    
  }



    protected void Button2_Click(object sender, EventArgs e)
    {
        //数据绑定 
        this.GridView1.DataSource = GetData();
        this.GridView1.DataBind();

    }
    private DataTable GetData()
    {
        string path = Server.MapPath("readuser.xml");//获取文件的路径
       // 建一个DataTable 
        DataTable dt = new DataTable();
        dt.Columns.Add("user_id", typeof(string));//添加数据表中对应的行，user_id,name,password,email，同是注明是什么类型
        dt.Columns.Add("name", typeof(String));
        dt.Columns.Add("password", typeof(String));
        dt.Columns.Add("email", typeof(String));

        //读取xml 
        XmlDocument doc = new XmlDocument();//xmldocument是类
        doc.Load(path);//加载路径
        XmlNodeList nodes = doc.SelectNodes(@"//user");//节点的统计
        foreach (XmlNode node in nodes)
        {
            DataRow row = dt.NewRow();
            row["user_id"] = node.ChildNodes[0].ChildNodes[0].InnerText;
            row["name"] = node.ChildNodes[1].ChildNodes[0].InnerText;
            row["password"] = node.ChildNodes[2].ChildNodes[0].InnerText;
            row["email"] = node.ChildNodes[3].ChildNodes[0].InnerText;
            dt.Rows.Add(row);
        }

       // 返回datatable 
        return dt;
    }     
   protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        user oCa = new user();
        string user_id = GridView1.DataKeys[e.RowIndex].Value.ToString();

        if (oCa.delete(user_id))
        {
            Response.Write("<script>alert('删除成功!')</script>");
            this.DataBind();
        }
        else
        {
            Response.Write("<script>alert('删除失败!')</script>");
            this.DataBind();
        }

    }
}