employeeimf.aspx.cs

很好的啊！中小型企业用的

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 renshi_EmployeeImf : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        readeImfo();
    }
    private void readeImfo()
    {
        String sqlLogin = "select * from UserInfo";

        String con = ConfigurationManager.AppSettings["MyConnection"].ToString();
        SqlConnection MyCon = new SqlConnection(con);
        MyCon.Open();

        SqlDataAdapter dat = new SqlDataAdapter(sqlLogin, con);
        DataSet ds = new DataSet();
        dat.Fill(ds);

        this.GridView1.DataSource = ds;
        this.GridView1.DataBind();

        MyCon.Close();

    }
    //删除指定

    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        String con = ConfigurationManager.AppSettings["MyConnection"].ToString();
        SqlConnection myConn = new SqlConnection(con);
        myConn.Open();
        SqlCommand cmd = new SqlCommand("Delete from UserInfo where Userid ='" + GridView1.DataKeys[e.RowIndex].Value + "'", myConn);

        cmd.ExecuteNonQuery();
        cmd.Dispose();



        string sqlstr = "select Userid ,name ,DepartId ,UserState  from UserInfo ";
        SqlDataAdapter dat = new SqlDataAdapter(sqlstr, con);
        DataSet ds = new DataSet();
        dat.Fill(ds);
        this.GridView1.DataSource = ds;
        this.GridView1.DataBind();
        myConn.Close();

        this.GridView1.DataBind();

    }
}