温馨提示:代码在线浏览功能只能做为源码浏览参考,如果想更进一步了解该代码请下载:人事管理系统(课程设计)源码
当前文件:
Mispersonal/WebFiles/User/User_List.aspx.cs,打开代码结构图
Mispersonal/WebFiles/User/User_List.aspx.cs,打开代码结构图1using System; 2
using System.Data; 3
using System.Configuration; 4
using System.Collections; 5
using System.Web; 6
using System.Web.Security; 7
using System.Web.UI; 8
using System.Web.UI.WebControls; 9
using System.Web.UI.WebControls.WebParts; 10
using System.Web.UI.HtmlControls; 11
using System.Data.SqlClient; 12
//该源码下载自www.51aspx.com(51aspx.com) 13
14
public partial class WebFiles_User_User_List : System.Web.UI.Page 15
{ 16
protected void Page_Load(object sender, EventArgs e) 17
{ 18
if (!IsPostBack) 19
Bind(); 20
} 21
private void Bind() 22
{ 23
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Mispersonalconn"].ConnectionString); 24
string sql = "select ID 用户编号,userName 用户姓名,userRole 用户角色 from [Tb_User_Login]"; 25
SqlDataAdapter sda = new SqlDataAdapter(sql, con); 26
DataSet ds = new DataSet(); 27
sda.Fill(ds, "temp"); 28
con.Close(); 29
List.DataSource = ds.Tables["temp"].DefaultView; 30
List.DataBind(); 31
} 32
// public string GetLinkUser(string userid) 33
// { 34
// return ID; 35
// } 36
37
38
protected void List_PageIndexChanging(object sender, GridViewPageEventArgs e) 39
{ 40
41
List.PageIndex= e.NewPageIndex; 42
DataBind(); 43
} 44
} 45
//5_1_a_s_p_x.c_o_m 46





}
}