如何获取数据列表中单击的行ID并转移到另一页 [英] how to get row id clicked in datalist and transfer to another page

问题描述

大家好
我想获得在数据列表中单击的linkbutton的行ID，以将其数据显示到另一页中
我知道如何使用
获取行的索引

hi all
i want to get row id of linkbutton clicked in datalist to display its data into another page
i know how to get index of row using

if (e.CommandName == "select")
        {
            
            int Id = int.Parse(e.CommandArgument.ToString());
            Response.Redirect("~/ArabicPage/download_ar.aspx?Id=" + Id.ToString());

        }

但我想获取行ID并将其传输到另一页

but i want to get id of row and transfer it to another page

推荐答案

shimaa010，

我创建了2个Web表单，sampledlist由员工有限的详细信息组成，并放置了链接按钮以查看完整的详细信息.如果单击链接按钮，则将导航到另一个页面，名为details.aspx
代码如下，

sampledlist.aspx:
设计:

Hi shimaa010,

I have created 2 webforms,sampledlist consists of employee limited details and placed link button to view full details.if you click on link button you will navigate another page called details.aspx
code as follows,

sampledlist.aspx:
Design:

<div>
    
        <asp:datalist id="DataList1" runat="server" style="text-align: center" xmlns:asp="#unknown">
            <itemtemplate>
                <table class="style1">
                    <tr>
                        <td class="style3">
                            Name:</td>
                        <td style="text-align: left">
                            <asp:label id="Label1" runat="server" style="text-align: left">
                                Text=''<%# Eval("ename") %>''></asp:label>
                        </td>
                    </tr>
                    <tr>
                        <td class="style2">
                            Department NO:</td>
                        <td style="text-align: left">
                            <asp:label id="Label2" runat="server" style="text-align: left">
                                Text=''<%# Eval("dept") %>''></asp:label>
                        </td>
                    </tr>
                    <tr>
                        <td class="style2">
                             </td>
                        <td style="text-align: left">
                             </td>
                    </tr>
                    <tr>
                        <td class="style2" colspan="2">
                            <asp:linkbutton id="LinkButton1" runat="server">
                                PostBackUrl=''<%# "~/Details.aspx?empno="+Eval("empno") %>''>View Details</asp:linkbutton>
                        </td>
                    </tr>
                </table>
            </itemtemplate>
        </asp:datalist>
    
    </div>

背后的代码:

Code Behind:

string cs = ConfigurationManager.ConnectionStrings["samplecnstring"].ConnectionString;
       SqlConnection cn = new SqlConnection(cs);
       SqlCommand cmd = new SqlCommand("select * from emp", cn);
       SqlDataAdapter da = new SqlDataAdapter(cmd);
       DataSet ds = new DataSet();
       da.Fill(ds, "employee");

       DataList1.DataSource = ds;
       DataList1.DataBind();

Details.aspx:
设计:

Details.aspx:
Design:

<asp:datalist id="DataList1" runat="server" xmlns:asp="#unknown">
        <itemtemplate>
            <table class="style1">
                <tr>
                    <td class="style2">
                        Employee No:</td>
                    <td>
                        <asp:label id="Label1" runat="server" text="<%# Eval("empno") %>"></asp:label>
                    </td>
                </tr>
                <tr>
                    <td class="style2">
                        Name:</td>
                    <td>
                        <asp:label id="Label2" runat="server" text="<%# Eval("ename") %>"></asp:label>
                    </td>
                </tr>
                <tr>
                    <td class="style2">
                        Department No:</td>
                    <td>
                        <asp:label id="Label3" runat="server" text="<%# Eval("dept") %>"></asp:label>
                    </td>
                </tr>
                <tr>
                    <td class="style2">
                        Address:</td>
                    <td>
                        <asp:label id="Label4" runat="server" text="<%# Eval("adder") %>"></asp:label>
                    </td>
                </tr>
                <tr>
                    <td class="style2">
                        Phone No:</td>
                    <td>
                        <asp:label id="Label5" runat="server" text="<%# Eval("phoneno") %>"></asp:label>
                    </td>
                </tr>
                <tr>
                    <td class="style2">
                        Email Id:</td>
                    <td>
                        <asp:label id="Label6" runat="server" text="<%# Eval("emailid") %>"></asp:label>
                    </td>
                </tr>
            </table>
        </itemtemplate>
    </asp:datalist>

背后的代码:

Code Behind:

protected void Page_Load(object sender, EventArgs e)
    {
        if (Request.QueryString.Count != 0)
        {
            int EmpNo = Convert.ToInt32(Request.QueryString["empno"]);
            if (!IsPostBack)
            {
                string cs = ConfigurationManager.ConnectionStrings["samplecnstring"].ConnectionString;
                SqlConnection cn = new SqlConnection(cs);
                SqlCommand cmd = new SqlCommand("select * from emp where empno="+EmpNo, cn);
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                DataSet ds = new DataSet();
                da.Fill(ds, "employee");

                DataList1.DataSource = ds;
                DataList1.DataBind();
            }

        }

希望它能清除您的查询.如果有任何问题，请问我.

祝你玩得开心！！！

I hope it clears your query.If any problem just ask me.

Have a good time!!!

这篇关于如何获取数据列表中单击的行ID并转移到另一页的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！