using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Drawing; using System.Web; using System.Web.SessionState; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; using System.Data.SqlClient;namespace tichnoffice.usermanager { /// <summary> /// userinfo 的摘要说明。 /// </summary> public class userinfo : System.Web.UI.Page { protected System.Web.UI.WebControls.DataGrid groupDataGrid; protected System.Web.UI.WebControls.Button Button1; protected config conn=new config(); protected string groupKey,userKey,myText; protected System.Web.UI.WebControls.Button Button2; protected System.Web.UI.WebControls.Button Button3; protected System.Web.UI.WebControls.Button Button4; protected System.Web.UI.WebControls.DataGrid userDataGrid;
在csdn俩面搜索DataGrid,能找到你需要的
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>userinfo</title>
<meta content="Microsoft Visual Studio 7.0" name="GENERATOR">
<meta content="C#" name="CODE_LANGUAGE">
<meta content="JavaScript" name="vs_defaultClientScript">
<meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
<LINK href="config/css.css" type="text/css" rel="stylesheet">
<style>
A:hover { FONT-WEIGHT: normal; COLOR: #ff3300; FONT-STYLE: normal; FONT-FAMILY: "Verdana", "宋体"; TEXT-DECORATION: none }
</style>
</HEAD>
<body>
<form id="userinfo" method="post" runat="server">
<FONT face="宋体">
<P align="center">
<asp:datagrid id="groupDataGrid" runat="server" Width="500px" BackColor="#EFF7E7" AutoGenerateColumns="False">
<HeaderStyle BackColor="#949B94"></HeaderStyle>
<Columns>
<asp:BoundColumn DataField="Group_sKey" HeaderText="Key" Visible="False"></asp:BoundColumn>
<asp:BoundColumn DataField="Group_iIndex" HeaderText="序号"></asp:BoundColumn>
<asp:BoundColumn DataField="Group_sCaption" HeaderText="部门名称"></asp:BoundColumn>
<asp:BoundColumn DataField="Group_sDiscription" HeaderText="描述"></asp:BoundColumn>
<asp:BoundColumn DataField="Group_dCreateTime" HeaderText="创建日期"></asp:BoundColumn>
<asp:BoundColumn DataField="Group_sCreater" HeaderText="创建者"></asp:BoundColumn>
<asp:ButtonColumn Text="编辑" HeaderText="编辑" CommandName="editRow"></asp:ButtonColumn>
<asp:ButtonColumn Text="删除" HeaderText="删除" CommandName="deleteRow"></asp:ButtonColumn>
</Columns>
</asp:datagrid></P>
<P align="center"><FONT face="宋体"><asp:button id="Button1" runat="server" Text="新增部门"></asp:button></FONT></P>
<P align="center">
<asp:datagrid id="userDataGrid" runat="server" Width="500px" BackColor="#EFF7E7" AutoGenerateColumns="False">
<HeaderStyle BackColor="#949B94"></HeaderStyle>
<SelectedItemStyle BackColor="#0066cc"></SelectedItemStyle>
<Columns>
<asp:TemplateColumn ItemStyle-Width="18">
<ItemTemplate>
<asp:LinkButton ID="arrow" Runat="server" CommandName="select" Font-Names="Webdings">4</asp:LinkButton>
</ItemTemplate>
</asp:TemplateColumn>
<asp:BoundColumn DataField="User_sKey" HeaderText="Key" Visible=False></asp:BoundColumn>
<asp:BoundColumn DataField="User_iIndex" HeaderText="序号"></asp:BoundColumn>
<asp:BoundColumn DataField="User_sName" HeaderText="用户名"></asp:BoundColumn>
<asp:BoundColumn DataField="User_sCaption" HeaderText="中文名"></asp:BoundColumn>
<asp:BoundColumn DataField="User_sDiscription" HeaderText="描述"></asp:BoundColumn>
<asp:BoundColumn DataField="User_dCreateTime" HeaderText="创建日期"></asp:BoundColumn>
<asp:BoundColumn DataField="User_sCreater" HeaderText="创建者"></asp:BoundColumn>
</Columns>
</asp:datagrid></P>
<P align="center"><FONT face="宋体">
<asp:Button id="Button2" runat="server" Text="增加"></asp:Button>
<asp:Button id="Button3" runat="server" Text="编辑"></asp:Button>
<asp:Button id="Button4" runat="server" Text="删除"></asp:Button></FONT></P>
</FONT>
</form>
</body>
</HTML>
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;namespace tichnoffice.usermanager
{
/// <summary>
/// userinfo 的摘要说明。
/// </summary>
public class userinfo : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataGrid groupDataGrid;
protected System.Web.UI.WebControls.Button Button1;
protected config conn=new config();
protected string groupKey,userKey,myText;
protected System.Web.UI.WebControls.Button Button2;
protected System.Web.UI.WebControls.Button Button3;
protected System.Web.UI.WebControls.Button Button4;
protected System.Web.UI.WebControls.DataGrid userDataGrid;
private void Page_Load(object sender, System.EventArgs e)
{
conn.open1();
string sqlAdapter,sqlUserAdapter;
groupKey=Request.QueryString["groupKey"];
myText=Request.QueryString["myText"];
userKey=groupKey;
//绑定用户组
if(groupKey!=null)
{
sqlAdapter="select * from KsWeb_GroupTable where Group_sParentKey="+"'"+groupKey+"'";
SqlDataAdapter myAdapter1=new SqlDataAdapter(sqlAdapter,conn.conn);
DataSet mySet1=new DataSet();
myAdapter1.Fill(mySet1,"KsWeb_GroupTable");
groupDataGrid.DataSource=mySet1;
groupDataGrid.DataBind();
}
else
{
SqlDataAdapter myAdapter=new SqlDataAdapter("select * from KsWeb_GroupTable where Group_sParentKey='KsGroup0000000000' order by Group_sNode",conn.conn);
DataSet mySet=new DataSet();
myAdapter.Fill(mySet,"KsWeb_GroupTable");
groupDataGrid.DataSource=mySet;
groupDataGrid.DataBind();
}
//绑定用户
if(userKey!=null)
{
sqlUserAdapter="select * from KsWeb_UserTable where User_sParentKey="+"'"+userKey+"'";
SqlDataAdapter myUserAdapter=new SqlDataAdapter(sqlUserAdapter,conn.conn); DataSet myUserSet=new DataSet();
myUserAdapter.Fill(myUserSet,"KsWeb_UserTable");
userDataGrid.DataSource=myUserSet;
userDataGrid.DataBind();
}
} #region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN:该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.groupDataGrid.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.groupDataGrid_ItemCommand);
this.groupDataGrid.SelectedIndexChanged += new System.EventHandler(this.groupDataGrid_SelectedIndexChanged);
this.Button1.Click += new System.EventHandler(this.Button1_Click);
this.userDataGrid.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.userDataGrid_ItemCommand);
this.userDataGrid.SelectedIndexChanged += new System.EventHandler(this.userDataGrid_SelectedIndexChanged);
this.Button2.Click += new System.EventHandler(this.Button2_Click);
this.Button3.Click += new System.EventHandler(this.Button3_Click);
this.Button4.Click += new System.EventHandler(this.Button4_Click);
this.Load += new System.EventHandler(this.Page_Load); }
#endregion private void groupDataGrid_SelectedIndexChanged(object sender, System.EventArgs e)
{
} private void groupDataGrid_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
string sKey=e.Item.Cells[0].Text;
if(((LinkButton)e.CommandSource).CommandName=="deleteRow")
{
string sqlDelete,sqlsNode,sqlDelUser;
string sNode;
//首先获得要删除的用户组的sNode字符串
sqlsNode="select * from KsWeb_GroupTable where Group_sKey="+"'"+sKey+"'";
SqlDataAdapter myDelAdapter=new SqlDataAdapter(sqlsNode,conn.conn);
DataSet myDelSet=new DataSet();
myDelAdapter.Fill(myDelSet,"KsWeb_GroupTable");
sNode=myDelSet.Tables[0].Rows[0]["Group_sNode"].ToString();
//删除用户组及其下面所有的用户组
sqlDelete="Delete FROM KsWeb_GroupTable Where Left(Group_sNode,Len('" + sNode + "'))='" + sNode + "'";
SqlCommand myCom=new SqlCommand(sqlDelete,conn.conn);
myCom.ExecuteNonQuery(); //删除该用户组下的所有的用户,注意用户组和用户可以是相同的sNode属性
sqlDelUser="Delete FROM KsWeb_UserTable Where Left(User_sNode,Len('" + sNode + "'))='" + sNode + "' And Len(User_sNode) <> Len('" + sNode + "')";
SqlCommand myComDelUser=new SqlCommand(sqlDelUser,conn.conn);
myComDelUser.ExecuteNonQuery();
Response.Redirect("userinfo.aspx?groupKey="+groupKey+"&myText="+myText); }
else if(((LinkButton)e.CommandSource).CommandName=="editRow")
{
Response.Redirect("groupedit.aspx?groupKey="+sKey+"&myText="+myText+"&myParentKey="+groupKey);
}
} private void Button1_Click(object sender, System.EventArgs e)
{
if(groupKey==null)
{
groupKey="KsGroup0000000000";
}
if(myText==null)
{
myText="部门";
} int myIndex=groupDataGrid.Items.Count-1; if(myIndex<0)
{
myIndex=1;
}
else
{
myIndex=Convert.ToInt32(groupDataGrid.Items[myIndex].Cells[1].Text)+1;
}
Response.Redirect("groupadd.aspx?groupKey="+groupKey+"&myText="+myText+"&myIndex="+myIndex.ToString());
} private void Button2_Click(object sender, System.EventArgs e)
{
int myIndex=userDataGrid.Items.Count-1; if(myIndex<0)
{
myIndex=1;
}
else
{
myIndex=Convert.ToInt32(userDataGrid.Items[myIndex].Cells[2].Text)+1;
}
Response.Redirect("useradd.aspx?groupKey="+groupKey+"&myText="+myText+"&myIndex="+myIndex.ToString());
} private void userDataGrid_SelectedIndexChanged(object sender, System.EventArgs e)
{
} private void userDataGrid_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
string i=e.Item.DataSetIndex.ToString();
//if(((LinkButton)e.CommandSource).CommandName=="select")
// Response.Write(i);
} private void Button3_Click(object sender, System.EventArgs e)
{
string userKey;
userKey=userDataGrid.Items[userDataGrid.SelectedIndex].Cells[1].Text;
Response.Redirect("useredit.aspx?userKey="+userKey+"&groupKey="+groupKey+"&myText="+myText);
} private void Button4_Click(object sender, System.EventArgs e)
{
string skey,sqlDelete;
skey=userDataGrid.Items[userDataGrid.SelectedIndex].Cells[1].Text;
sqlDelete="Delete from KsWeb_UserTable where User_sKey='"+skey+"'";
SqlCommand myCom=new SqlCommand(sqlDelete,conn.conn);
myCom.ExecuteNonQuery();
Response.Redirect("userinfo.aspx?groupKey="+groupKey+"&myText="+myText);
}
}
}