search

Home  >  Q&A  >  body text

mysql - Now that I have used CommandArgument to get the value of t_ID, I now want to get the value of t_Name and put it into the sql statement in the cs file. What should I do?

<asp:Repeater ID="Repeater1" runat="server" OnItemCommand="Repeater1_ItemCommand">

                            <ItemTemplate>
                                <p class="bellows__header">
                                    <img src="image/daili.jpg" /><h3 style="display: block"><%#Eval("t_Name")%></h3>
                                </p>
                                <p class="bellows__content">
                                    <p class="down_list" id="agent_detail_0" style="display: none">
                                        <p>
                                            <p>
                                                司机:<%#Eval("t_ID")%>
                                            </p>
                                        </p>
                                        <p>
                                            <p>
                                                管家:<%#Eval("t_Account")%>
                                            </p>
                                        </p>
                                        <p>
                                            <p>
                                                手机:<%#Eval("t_Tel") %>
                                            </p>
                                        </p>
                                        <p>
                                            <p>
                                                微信:<%#Eval("t_Wechat")%>
                                            </p>
                                        </p>
                                        <p>
                                            <p>
                                               酒店:<%#Eval("t_lastCard")%>
                                            </p>
                                        </p>
                                        <p>
                                            <p>
                                                房间:<%#Eval("t_gCard")%>
                                            </p>
                                        </p>
                                        <p>
                                            <p>
                                                时间:<%#Eval("t_Creatime")%>
                                            </p>
                                        </p>
                                        <p>
                                            <p>
                                                备注:<%#Eval("t_Comment")%>
                                            </p>
                                        </p>
                                        <p>
                                            酒店:<asp:TextBox ID="num0" runat="server" onkeyup="value=value.replace(/[^0-9]/g,'')" MaxLength="6"></asp:TextBox>
                                        </p>
                                                                                    <asp:Button ID="send_agent_card_btn1" runat="server" Text="发放" CommandName="Insert" CommandArgument='<%#Eval("t_ID")%>' class="submit_btn" OnClick="send_agent_card_btn1_Click" />

                                    </p>
                                </p>
                            </ItemTemplate>
                        </asp:Repeater>
                        后台cs代码

DataSet ch = DbHelperMySQL.Query("INSERT INTO t_dRecordCards VALUES(NULL,'" Convert.ToInt32(e.CommandArgument) "','" name.ToString() "','" card.Text "',NOW())");

大家讲道理大家讲道理2711 days ago966

reply all(1)I'll reply

  • 曾经蜡笔没有小新

    曾经蜡笔没有小新2017-06-30 09:55:20

    Your question is just like "How to do XXX", it's too big and meaningless.

    Or maybe you didn’t describe your problem clearly, I suggest you make it more clear.

    If you really don’t know how to do it, there is a lot of information online, just be patient and follow it.

    If you can’t find it online, it means you haven’t mastered the basics yet. It’s better to work on the basics first.

    reply
    0
  • Cancelreply