GridView显示主细表并一次编辑明细表所有数据

时间:2009-04-16    点击:3025   

部分代码:

  <script type="text/javascript">
  //<![CDATA[
  function ShowHidden(sid,ev)
  {
    ev = ev || window.event;
    var target = ev.target || ev.srcElement;
    var oDiv = document.getElementById("div" + sid);
    oDiv.style.display = oDiv.style.display == "none"?"block":"none";
    target.innerHTML = oDiv.style.display == "none"?"显示":"隐藏";
  }
  //]]>
  </script>

    <asp:GridView ID="MasterGridView" runat="server" AutoGenerateColumns="false" Width="780px"
      BorderWidth="1" OnRowDataBound="MasterGridView_RowDataBound" DataKeyNames="userid"
      ShowHeader="false">
      <Columns>
        <asp:TemplateField>
          <ItemTemplate>
            <div style="width: 100%; padding: 2px; font-weight: bold; background-color: #DEDEDE;
              float: left">
              <span style="float: left">用户名:<%#Eval("username") %></span><span style="float: right;
                color: Red; cursor: pointer" onclick="ShowHidden('<%#Eval("userid") %>',event)">隐藏</span></div>
            <div style="background-color: #FFF; padding-left: 60px; clear: both" id="div<%#Eval("userid") %>">
              <asp:GridView ID="DetailGridView" runat="server" AutoGenerateColumns="false" ShowHeader="true"
                HorizontalAlign="left" DataKeyNames="id" OnRowCommand="DetailGridView_RowCommand"
                OnRowDeleting="DetailGridView_RowDeleting" Width="720px">
                <HeaderStyle BackColor="#9999FF" />
                <Columns>
                  <asp:TemplateField HeaderText="电话" HeaderStyle-Width="540px">
                    <ItemTemplate>
                      <input name="guid" value="<%#Eval("userid") %>" type="hidden" />
                      <input name="Tel<%#Eval("userid") %>" value="<%#Eval("tel") %>" style="width: 100%;border:1px solid gray" />
                    </ItemTemplate>
                  </asp:TemplateField>
                  <asp:TemplateField HeaderText="发布日期" HeaderStyle-Width="100px" ItemStyle-HorizontalAlign="Center">
                    <ItemTemplate>
                      <input name="Date<%#Eval("userid") %>" value="<%# ((DateTime)Eval("addtime")).ToString("yyyy-MM-dd") %>" style="border:1px solid gray"/>
                    </ItemTemplate>
                  </asp:TemplateField>
                  <asp:CommandField DeleteText="删除" ShowDeleteButton="true" ButtonType="Button" HeaderStyle-Width="40px" />
                </Columns>
              </asp:GridView>
            </div>
          </ItemTemplate>
        </asp:TemplateField>
      </Columns>
    </asp:GridView>
    <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="编辑所有数据" />

 

    OleDbConnection cn1;


    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            OleDbConnection cn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("test.mdb"));
            cn.Open();
            cn1 = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("test.mdb"));
            cn1.Open();
            OleDbCommand cmd = new OleDbCommand("select * from [user] where id=0", cn);
            OleDbDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            MasterGridView.DataSource = dr;
            MasterGridView.DataBind();
            dr.Close();
            cmd.Dispose();
            cn.Dispose();
            cn1.Dispose();
            cn = cn1 = null;
        }
    }
    protected void MasterGridView_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {

            GridView oGridView = (GridView)e.Row.FindControl("DetailGridView");
            if (oGridView != null)
            {
                OleDbCommand cmd = new OleDbCommand("select top 10 * from [user] Where id = " + MasterGridView.DataKeys[e.Row.RowIndex].Value, cn1);
                OleDbDataReader dr1 = cmd.ExecuteReader();
                oGridView.DataSource = dr1;
                oGridView.DataBind();
                dr1.Close();
                cmd.Dispose();
            }
        }
    }

    protected void DetailGridView_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        GridView a = (GridView)sender;
        Response.Write("您要删除的记录是:<font color='red'>" + a.DataKeys[e.RowIndex].Value.ToString() + "</font>&nbsp;&nbsp;&nbsp;&nbsp;TODO:执行删除动作");
        // TODO:执行删除动作
    }
    protected void DetailGridView_RowCommand(object sender, GridViewCommandEventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string Guids = Request.Form["guid"];
        if (Guids == null || Guids.Equals(string.Empty))
        {
            Response.Write("没有数据可以修改。");
            return;
        }
        string sql;
        OleDbCommand cmd;
        OleDbConnection cn = new OleDbConnection();
        cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("test.mdb");
        cn.Open();
        string[] ArrGuid = Guids.Split(',');
        for (int i = 0; i < ArrGuid.Length; i++)
        {
            sql = "UPDATE [user] Set tel = @Tel Where userid = @userid";
            cmd = new OleDbCommand(sql, cn);
            cmd.Parameters.AddWithValue("@Tel", Request.Form["Tel" + ArrGuid[i].Trim()]);
            //cmd.Parameters.AddWithValue("@CreateDate", Request.Form["Date" + ArrGuid[i].Trim()]);
            cmd.Parameters.AddWithValue("@userid", ArrGuid[i].Trim());
            cmd.ExecuteNonQuery();
            Response.Write("<li>更新:userid= " + ArrGuid[i] + " " + Request.Form["Tel" + ArrGuid[i].Trim()]);
        }
        cn.Close();
        cn.Dispose();
    }

演示 下载

GridView加载空行并点击编辑
ASP.NET2.0导出到Excel并换行
GridView导出Excel文件如何隐藏指定的列
HyperLink控件控制图片宽度高度的方法
asp.net随机读取access数据库
> 返回     
地址:上海市普陀区胶州路941号长久商务中心 电话: QQ:
© Copyright 2012 上海网络 All Rights Reserved