frame work sdk 有完整的例子

解决方案 »

  1.   


    在csdn俩面搜索DataGrid,能找到你需要的
      

  2.   

    你装的.net框架是不是中文版的?是中文版的话里面的帮助当然也是中文版的,若没有中文版的可以看看这个:http://chs.gotdotnet.com/quickstart/aspplus/default.aspx
      

  3.   

    <%@ Page language="c#" Codebehind="userinfo.aspx.cs" AutoEventWireup="false" Inherits="tichnoffice.usermanager.userinfo" %>
    <!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>&nbsp;
    <asp:Button id="Button3" runat="server" Text="编辑"></asp:Button>&nbsp;&nbsp;
    <asp:Button id="Button4" runat="server" Text="删除"></asp:Button></FONT></P>
    </FONT>
    </form>
    </body>
    </HTML>
      

  4.   

    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;

    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);
    }
    }
    }