asp.net 毕业设计遗忘的知识点(十)

点击gridview控件中linkbotton跳转到详细页面进行编辑

>请看到上图“查看详情”这一列，就是今天所说的内容。通过点击编辑链接，将GridView控件这一行的数据加载到编辑页面中，而后就可以进行您所需要的修改了。编辑>列，前台代码示例如下：

    <div style="margin:100px 100px" >
    <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False" BackColor="White" BorderColor="White" BorderStyle="Ridge" BorderWidth="2px" CellPadding="3" CellSpacing="1" DataKeyNames="uid" DataSourceID="SqlDataSource1" GridLines="None" OnRowCommand="GridView1_RowCommand">
        <Columns>
            <asp:BoundField DataField="uid" HeaderText="uid" ReadOnly="True" SortExpression="uid" />
            <asp:BoundField DataField="upw" HeaderText="upw" SortExpression="upw" />
            <asp:BoundField DataField="uname" HeaderText="uname" SortExpression="uname" />
            <asp:BoundField DataField="email" HeaderText="email" SortExpression="email" />
            <asp:BoundField DataField="upwe" HeaderText="upwe" SortExpression="upwe" />
            <asp:BoundField DataField="hs" HeaderText="hs" SortExpression="hs" />
            <asp:BoundField DataField="cost" HeaderText="cost" SortExpression="cost" />
            <asp:BoundField DataField="address" HeaderText="address" SortExpression="address" />
            <asp:BoundField DataField="tel" HeaderText="tel" SortExpression="tel" />
            <asp:TemplateField>
                <ItemTemplate>
                    <asp:LinkButton ID="LinkButton1" runat="server" CommandArgument='<%# Eval("uid")+","+Eval("upw")+","+Eval("uname")+","+Eval("email")+","+Eval("upwe")+","+Eval("hs")+","+Eval("cost")+","+Eval("address")+","+Eval("tel") %>' CommandName="go">编辑</asp:LinkButton>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField>
                <ItemTemplate>
                    <asp:Image ID="Image1" runat="server" Height="150px" ImageUrl='<%# Eval("hs") %>' Width="150px" />
                </ItemTemplate>
            </asp:TemplateField>
        </Columns>
        <FooterStyle BackColor="#C6C3C6" ForeColor="Black" />
        <HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#E7E7FF" />
        <PagerStyle BackColor="#C6C3C6" ForeColor="Black" HorizontalAlign="Right" />
        <RowStyle BackColor="#DEDFDE" ForeColor="Black" />
        <SelectedRowStyle BackColor="#9471DE" Font-Bold="True" ForeColor="White" />
        <SortedAscendingCellStyle BackColor="#F1F1F1" />
        <SortedAscendingHeaderStyle BackColor="#594B9C" />
        <SortedDescendingCellStyle BackColor="#CAC9C9" />
        <SortedDescendingHeaderStyle BackColor="#33276A" />
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:DesignAndImplementationOfHEYTEAConnectionString %>" SelectCommand="SELECT * FROM [UserInfo]"></asp:SqlDataSource>
        <asp:Button ID="Button1" runat="server" Text="返回" OnClick="Button1_Click" />
    </div>

>编辑链接的属性CommandArgument有多个参数，其实就是GridView控件中各个列的值。利用GridView控件的RowCommand事件将值传到编辑界面。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class AdministratorUser : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }

    protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "go")
        {
            
            string[] estr = e.CommandArgument.ToString().Split(',');
            string uid = Convert.ToString(estr[0]);
            string upw = Convert.ToString(estr[1]);
            string uname = Convert.ToString(estr[2]);
            string email = Convert.ToString(estr[3]);
            string upwe = Convert.ToString(estr[4]);
            string hs = Convert.ToString(estr[5]);
            string cost = Convert.ToString(estr[6]);
            string address = Convert.ToString(estr[7]);
            string tel = Convert.ToString(estr[8]);

            Response.Redirect("AdministratorUserInfo.aspx?uid=" + uid + "&upw=" + upw + "&uname=" + uname + "&email=" + email + "&upwe=" + upwe + "&hs=" + hs + "&cost=" + cost + "&address=" + address + "&tel=" + tel, false);
        }
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        Response.Redirect("AdministratorMain.aspx");
    }
}

>上面的代码就是将GridView控件的行数据值绑定到后台，通过Response.Redirect()跳转再将值传到编辑页面中的各个控件中。需要在编辑页面的后台代码Page_Load()方>法中加载这些被传过来的数据.

>e.CommandArgument.ToString().Split(',');绑定多值

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using Business;
using Entity;
public partial class AdministratorUserInfo : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (IsPostBack == false)
        {
            Bind();
        }
    }
    public void Bind()
    {
        if (Request.QueryString["uid"] == null)
        {
            Response.Write("<script>alert('对不起，请登录！'),location.href='AdministratorLogin.aspx'</script>");
        }
        else
        {
            TextBox1.Text = Request.QueryString["uid"].ToString().Trim();
            TextBox2.Text = Request.QueryString["upw"].ToString().Trim();
            TextBox3.Text = Request.QueryString["uname"].ToString().Trim();
            TextBox4.Text = Request.QueryString["email"].ToString().Trim();
            TextBox5.Text = Request.QueryString["upwe"].ToString().Trim();
            Image1.ImageUrl = Request.QueryString["hs"].ToString().Trim();
            TextBox6.Text = Request.QueryString["cost"].ToString().Trim();
            TextBox7.Text = Request.QueryString["address"].ToString().Trim();
            TextBox8.Text = Request.QueryString["tel"].ToString().Trim();
        }
    }



    protected void Button1_Click(object sender, EventArgs e)
    {
        UserBusiness u = new UserBusiness();
        UserEntity ue = new UserEntity();
        ue.Uid = TextBox1.Text.Trim();
        ue.Upw = TextBox2.Text.Trim();
        ue.Uname = TextBox3.Text.Trim();
        ue.Email = TextBox4.Text.Trim();
        ue.Upwe = TextBox5.Text.Trim();
        
        string path = Server.MapPath("~/Image/");
        if (FileUpload1.HasFile)
        {
            string fileName = FileUpload1.FileName;
            path += fileName;
            string ext = System.IO.Path.GetExtension(path);
            ue.Hs = "~/Image/" + fileName;
        }
        ue.Cost =TextBox6.Text.Trim();
        ue.Address = TextBox7.Text.Trim();
        ue.Tel = TextBox8.Text.Trim();
        int res = 0;
        res = u.Update(ue);
        if (res > 0)
        {
            Response.Write("<script>alert('修改成功！'),location.href='AdministratorUser.aspx'</script>");
        }
        
    }

    protected void Button2_Click(object sender, EventArgs e)
    {
        Response.Redirect("AdministratorUser.aspx");
    }
}

>Request.QueryString（取得地址栏参数值）获取地址栏中的参数，意思就是取得”？"号后面的参数值．如果是多个是用这”＆”符号连接起来的．

>前端

    <div style="margin:100px 100px" >
    <table class="auto-style1">
        <tr>
            <td style="text-align:right">uid:</td>
            <td>
                <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
            </td>
        </tr>
        <tr>
            <td style="text-align:right">upw:</td>
            <td>
                <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
            </td>
        </tr>
        <tr>
            <td style="text-align:right">uname:</td>
            <td>
                <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
            </td>
        </tr>
        <tr>
            <td style="text-align:right">email:</td>
            <td>
                <asp:TextBox ID="TextBox4" runat="server"></asp:TextBox>
            </td>
        </tr>
        <tr>
            <td style="text-align:right">upwe:</td>
            <td>
                <asp:TextBox ID="TextBox5" runat="server"></asp:TextBox>
            </td>
        </tr>
        <tr>
            <td style="text-align:right">hs:</td>
            <td>
                <asp:Image ID="Image1" runat="server" Height="150px" Width="150px" />
                <asp:FileUpload ID="FileUpload1" runat="server" />
            </td>
        </tr>
        <tr>
            <td style="text-align:right">cost:</td>
            <td>
                <asp:TextBox ID="TextBox6" runat="server"></asp:TextBox>
            </td>
        </tr>
        <tr>
            <td style="text-align:right">address:</td>
            <td>
                <asp:TextBox ID="TextBox7" runat="server"></asp:TextBox>
            </td>
        </tr>
        <tr>
            <td style="text-align:right">tel:</td>
            <td>
                <asp:TextBox ID="TextBox8" runat="server"></asp:TextBox>
            </td>
        </tr>
        <tr>
            <td>&nbsp;</td>
            <td>
                <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="修改" />
                <asp:Button ID="Button2" runat="server" Text="返回" OnClick="Button2_Click" />
            </td>
        </tr>
    </table>
        </div>

>解释下CommandArgument 获取或设置与关联的 CommandName 属性一起传递到 Command 事件处理程序的可选参数。

>备注
>使用 CommandArgument 属性指定补充 CommandName 属性的参数。

>注意 CommandArgument 属性通常只在设置 CommandName 属性时使用。
>CommandArgument 属性补充 CommandName 属性，允许提供要执行的命令的任何附加信息。例如，可以将 CommandName 属性设置为 Sort 并将 >CommandArgument 属性设置为 Ascending，以指定按升序排序的命令。

参考链接

http://zhidao.baidu.com/question/2744158.html

https://zhidao.baidu.com/question/103507238.html

https://www.cnblogs.com/litao4047/archive/2013/06/14/3135977.html