如何在gridview_RowCommand中处理多个值 [英] how to handle multiple values in gridview_RowCommand

问题描述

帮助帮助



在我的网格视图中，我有一个链接按钮。
此链接上的
按钮命令参数我必须定义4个参数。
来自GridView1_RowCommand的
来自网格视图的这4个变量的值被传递到数据库中的存储过程，并且在计算后，存储过程返回两个在数据库中更新的值，然后在网格视图中显示，即ToDepotNo和FromDepotNo。





我的代码如下：

.aspx gridview文件代码：

Help help

In my grid view i have a link button.
on this link buttons Command Argument i have to define 4 parameters.
from GridView1_RowCommand value of these 4 variables from grid view are passed to a store procedure in database , and after calculation store procedure returns two values which are updated in database.and then shown in grid view,that are ToDepotNo and FromDepotNo.


My code is below:
.aspx file code for gridview :

<tr>
       <td align="center" colspan="1">

               <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" "Receipt_ID,Depot_Code,Trip_No,Vechicle_Arrival_Date,Total_No_Qty"
                   OnRowEditing="GridView1_RowEditing" OnRowDeleting="GridView1_RowDeleting"
                   AllowPaging="True" onpageindexchanging="GridView1_PageIndexChanging" OnRowCommand="GridView1_RowCommand"
                   PageSize="25"   >
                   <pagersettings mode="NumericFirstLast" position="TopAndBottom" />
                   <columns>

                       <asp:TemplateField HeaderText="<%$ Resources:Language, Common_Sr %>"
                           HeaderStyle-Width="30px" HeaderStyle-HorizontalAlign="Center">
                           <itemtemplate>
                               <asp:Label ID="lblSr" runat="server" Text='<%#Container.DataItemIndex+1%>'>
                           </itemtemplate>
                           <HeaderStyle HorizontalAlign="Center" Width="30px" />

                        <asp:TemplateField HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center"
                           HeaderText="">
                           <itemtemplate>
                               <asp:LinkButton ID="lbnEdit" runat="server"
                                   Text="<%$ Resources:Language, Common_Edit %>" CausesValidation="false"
                                   CommandName="Edit">
                           </itemtemplate>
                           <HeaderStyle HorizontalAlign="Center" />
                           <itemstyle wrap="false" />


                       <asp:TemplateField HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center"
                           HeaderText="">
                           <itemtemplate>
                               <asp:LinkButton ID="lbnDelete" runat="server"
                                   Text="<%$ Resources:Language, Common_Delete %>" CausesValidation="false"
                                   OnClientClick="return confirm('Are you sure you want to delete this record?');"
                                   CommandName="Delete">
                           </itemtemplate>
                           <HeaderStyle HorizontalAlign="Center" />
                           <itemstyle wrap="false" />

                       <asp:TemplateField HeaderStyle-HorizontalAlign="Center" HeaderText="<%$ Resources:Language, lblReceipt_ID %>"
                           ItemStyle-HorizontalAlign="Left">
                           <itemtemplate>
                               <asp:Label ID="lblRcptNo" Text='<%# Bind("Receipt_ID") %>' runat="server">
                           </itemtemplate>
                           <HeaderStyle HorizontalAlign="Center" />
                           <itemstyle wrap="True" />

                       <asp:TemplateField HeaderStyle-HorizontalAlign="Center" HeaderText="<%$ Resources:Language, lblTrip_No %>"
                           ItemStyle-HorizontalAlign="Left">
                           <itemtemplate>
                               <asp:Label ID="lblTripNo" Text='<%# Bind("Trip_No") %>' runat="server">
                           </itemtemplate>
                           <HeaderStyle HorizontalAlign="Center" />
                           <itemstyle wrap="True" />

                       <asp:TemplateField HeaderStyle-HorizontalAlign="Center" HeaderText="<%$ Resources:Language, lblTruck_no %>"
                           ItemStyle-HorizontalAlign="Left">
                           <itemtemplate>
                               <asp:Label ID="lblTrNo" Text='<%# Bind("Vechicle_No") %>'
                                   runat="server">
                           </itemtemplate>
                           <HeaderStyle HorizontalAlign="Center" />
                           <itemstyle wrap="True" />

                       <asp:TemplateField HeaderStyle-HorizontalAlign="Center" HeaderText="<%$ Resources:Language, lblTruck_Drivername %>"
                           ItemStyle-HorizontalAlign="Left">
                           <itemtemplate>
                               <asp:Label ID="lblTDNM"  Text='<%# Bind("Driver_Name") %>'
                                   runat="server">
                           </itemtemplate>
                           <HeaderStyle HorizontalAlign="Center" />
                           <itemstyle wrap="True" />

                       <asp:TemplateField HeaderStyle-HorizontalAlign="Center" HeaderText="<%$ Resources:Language, lblArrivalTime %>"
                        ItemStyle-HorizontalAlign="Left">
                           <itemtemplate>
                               <asp:Label ID="lblArrT"  Text='<%# Bind("Vechicle_Arrival_Time") %>' runat="server">
                           </itemtemplate>
                               <HeaderStyle HorizontalAlign="Center" />
                                <itemstyle wrap="True" />


                        <asp:TemplateField HeaderStyle-HorizontalAlign="Center" HeaderText="<%$ Resources:Language, lblCartingChallanNo %>"
                           ItemStyle-HorizontalAlign="Left">
                           <itemtemplate>
                               <asp:Label ID="lblCartingChNo"  Text='<%# Bind("Carting_ChallanNo") %>'
                                   runat="server">
                           </itemtemplate>
                           <HeaderStyle HorizontalAlign="Center" />
                           <itemstyle wrap="True" />

                       <asp:TemplateField HeaderStyle-HorizontalAlign="Center" HeaderText="<%$ Resources:Language, lblDate %>"
                        ItemStyle-HorizontalAlign="Left">
                           <itemtemplate>
                               <asp:Label ID="lblVechArrD"  Text='<%# Bind("Vechicle_Arrival_Date") %>' runat="server">
                           </itemtemplate>
                               <HeaderStyle HorizontalAlign="Center" />
                                <itemstyle wrap="True" />

                          <asp:TemplateField HeaderStyle-HorizontalAlign="Center" HeaderText="<%$ Resources:Language, CartingChallan_lblDivision_Territorial %>"
                           ItemStyle-HorizontalAlign="Left">
                           <itemtemplate>
                               <asp:Label ID="lblDivHName"  Text='<%# Bind("DIV_HNAME") %>'
                                   runat="server">
                           </itemtemplate>
                           <HeaderStyle HorizontalAlign="Center" />
                           <itemstyle wrap="True" />

                         <asp:TemplateField HeaderStyle-HorizontalAlign="Center" HeaderText="<%$ Resources:Language, lblRange %>"
                           ItemStyle-HorizontalAlign="Left">
                           <itemtemplate>
                               <asp:Label ID="lblRangeHname"  Text='<%# Bind("RANGE_HNAME") %>'
                                   runat="server">
                           </itemtemplate>
                           <HeaderStyle HorizontalAlign="Center" />
                           <itemstyle wrap="True" />

                       <asp:TemplateField HeaderStyle-HorizontalAlign="Center" HeaderText="<%$ Resources:Language, lblCoupeName %>"
                        ItemStyle-HorizontalAlign="Left">
                           <itemtemplate>
                               <asp:Label ID="lblCoupName"  Text='<%# Bind("Coupe_Name") %>' runat="server">
                           </itemtemplate>
                               <HeaderStyle HorizontalAlign="Center" />
                                <itemstyle wrap="True" />

                               <asp:TemplateField HeaderStyle-HorizontalAlign="Center" HeaderText="<%$ Resources:Language, lblDepot_No %>"
                           ItemStyle-HorizontalAlign="Left">
                           <itemtemplate>
                               <asp:Label ID="lblCoupeNo"  Text='<%# Bind("Depot_Code") %>'
                                   runat="server">
                           </itemtemplate>
                           <HeaderStyle HorizontalAlign="Center" />
                                <itemstyle wrap="True" />


                           <asp:TemplateField HeaderStyle-HorizontalAlign="Center" HeaderText="<%$ Resources:Language, lblCoupNo %>"
                           ItemStyle-HorizontalAlign="Left">
                           <itemtemplate>
                               <asp:Label ID="lblCoupeNo"  Text='<%# Bind("Coupe_No") %>'
                                   runat="server">
                           </itemtemplate>
                           <HeaderStyle HorizontalAlign="Center" />
                           <itemstyle wrap="True" />

                       <asp:TemplateField HeaderStyle-HorizontalAlign="Center" HeaderText="<%$ Resources:Language, lbllog %>"
                        ItemStyle-HorizontalAlign="Left">
                           <itemtemplate>
                               <asp:Label ID="lblLogQt"  Text='<%# Bind("Log_Qty") %>' runat="server">
                       </itemtemplate>
                           <HeaderStyle HorizontalAlign="Center" />
                            <itemstyle wrap="True" />


                       <asp:TemplateField HeaderStyle-HorizontalAlign="Center" HeaderText="<%$ Resources:Language, lblPole %>"
                        ItemStyle-HorizontalAlign="Left">
                           <itemtemplate>
                               <asp:Label ID="lblPoleQt"  Text='<%# Bind("Pole_Qty") %>' runat="server">
                       </itemtemplate>
                           <HeaderStyle HorizontalAlign="Center" />
                            <itemstyle wrap="True" />


                        <asp:TemplateField HeaderStyle-HorizontalAlign="Center" HeaderText="<%$ Resources:Language, lblDangri %>"
                        ItemStyle-HorizontalAlign="Left">
                           <itemtemplate>
                               <asp:Label ID="lblDangQt"  Text='<%# Bind("Dangri_Qty") %>' runat="server">
                       </itemtemplate>
                           <HeaderStyle HorizontalAlign="Center" />
                            <itemstyle wrap="True" />


                           <asp:TemplateField HeaderStyle-HorizontalAlign="Center" HeaderText="<%$ Resources:Language, lblTotalQty %>"
                        ItemStyle-HorizontalAlign="Left">
                           <itemtemplate>
                               <asp:Label ID="lblTotQty"  Text='<%# Bind("Total_No_Qty") %>' runat="server">
                       </itemtemplate>
                           <HeaderStyle HorizontalAlign="Center" />
                            <itemstyle wrap="True" />

                           <asp:TemplateField HeaderStyle-HorizontalAlign="Center" HeaderText="<%$ Resources:Language, lblCubicMtlog %>"
                           ItemStyle-HorizontalAlign="Left">
                           <itemtemplate>
                               <asp:Label ID="lblLogcmt1"  Text='<%# Bind("Log_Cmt") %>'
                                   runat="server">
                           </itemtemplate>
                           <HeaderStyle HorizontalAlign="Center" />
                           <itemstyle wrap="True" />

                           <asp:TemplateField HeaderStyle-HorizontalAlign="Center" HeaderText="<%$ Resources:Language, lblCubicMtPole %>"
                        ItemStyle-HorizontalAlign="Left">
                           <itemtemplate>
                               <asp:Label ID="lblPolecmt1"  Text='<%# Bind("Pole_Cmt") %>' runat="server">
                       </itemtemplate>
                           <HeaderStyle HorizontalAlign="Center" />
                            <itemstyle wrap="True" />

                           <asp:TemplateField HeaderStyle-HorizontalAlign="Center" HeaderText="<%$ Resources:Language, lblCubicMtDangri %>"
                        ItemStyle-HorizontalAlign="Left">
                           <itemtemplate>
                               <asp:Label ID="lblDangcmt1"  Text='<%# Bind("Dangri_Cmt") %>' runat="server">
                       </itemtemplate>
                           <HeaderStyle HorizontalAlign="Center" />
                            <itemstyle wrap="True" />


                           <asp:TemplateField HeaderStyle-HorizontalAlign="Center" HeaderText="<%$ Resources:Language, lblTotalQtyCM %>"
                           ItemStyle-HorizontalAlign="Left">
                           <itemtemplate>
                               <asp:Label ID="lblTotcmt"  Text='<%# Bind("TotalQtyCMT") %>' runat="server">
                           </itemtemplate>
                           <HeaderStyle HorizontalAlign="Center" />
                            <itemstyle wrap="True" />


                           <asp:TemplateField HeaderStyle-HorizontalAlign="Center" HeaderText="<%$ Resources:Language, lblHammer %>"
                            ItemStyle-HorizontalAlign="Left">
                           <itemtemplate>
                               <asp:Label ID="lblHam"  Text='<%# Bind("Hammer") %>' runat="server">
                           </itemtemplate>
                           <HeaderStyle HorizontalAlign="Center" />
                            <itemstyle wrap="True" />

                           <asp:TemplateField HeaderStyle-HorizontalAlign="Center" HeaderText="<%$ Resources:Language, lblFrom_Depot_No %>"
                           ItemStyle-Font-Bold="true" ItemStyle-Horizontalalign="left">
                           <itemtemplate>
                               <asp:Label ID="lblFromDepo" runat="server" Text='<%# Bind("From_Depot_No") %>'>
                           </itemtemplate>
                           <HeaderStyle HorizontalAlign="Center" />
                           <itemstyle wrap="True" />


                            <asp:TemplateField HeaderStyle-HorizontalAlign="Center" HeaderText="<%$ Resources:Language, lblTo_Depot_No %>"
                               ItemStyle-Font-Bold="true" ItemStyle-Horizontalalign="left">
                               <itemtemplate>
                                   <asp:Label ID="lblToDepoo" runat="server" Text='<%# Bind("To_Depot_No") %>'>
                               </itemtemplate>
                               <HeaderStyle HorizontalAlign="Center" />
                               <itemstyle wrap="True" />

                           <asp:TemplateField HeaderStyle-HorizontalAlign="Center" ItemStyle-BackColor="#69408F"
                               ItemStyle-Horizontalalign="left">
                            <itemtemplate>
                            <asp:LinkButton ID="lnkGenerateDepotNo" runat="server" CausesValidation="false" CommandArgument='<%#Eval("Depot_Code")+ ";" +Eval("Trip_No")+ ";" +Eval("Vechicle_Arrival_Date")+ ";" +Eval(Total_No_Qty)%>'
                             CommandName="GenerateDepotNo" Text="<%$ Resources:Language, DepotR_Gen_Depot_No %>">
                             <%--<asp:HyperLink ID="hlkFormF" runat="server" Text="<%$ Resources:Language, ContratorT_hlkFormF %>">--%>
                             </itemtemplate>
                             <HeaderStyle HorizontalAlign="Center" />
                            <itemstyle wrap="false" />


                         </columns>


                             <HeaderStyle BackColor="#EFEFEF" />


                                   </td>
                           </tr>

.cs file code for

.cs file code for

  protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        //if (e.CommandName == "GenerateDepotNo")
        //{
             string[] arg = new string[4];
             arg = e.CommandArgument.ToString().Split(';');
             Session["IdEntity"] = arg[0];
             Session["IdEntity"] = arg[1];
             Session["IdEntity"] = arg[2];
             Session["IdEntity"] = arg[3];
             //Response.Redirect("Samplepage.aspx");
            /*if (objDepoReceiptRegister.GenerateDepotNo(string Depot_Code,Convert.ToInt64(e.CommandArgument),))
            {
                lblStatus.Text = Resources.Language.Contractor_RegNoGenerate_Success;
                BindGrid(Session["Language"].ToString());
            }*/
        //}
    }


.cls file code :

public bool GenerateDepotNo(string Depot_Code, string Trip_No, string Vechicle_Arrival_Date, int Total_No_Qty)
        {
            bool res = false;
            System.Collections.ArrayList sel = new System.Collections.ArrayList();

            sel.Add("SP_m_Receipt_GenerateDepotNoNew");
            ArrayList lstParam = new System.Collections.ArrayList();

            SqlParameter param;

            param = new SqlParameter();
            param.ParameterName = "@Depot_Code";
            param.SqlDbType = SqlDbType.Char;
            param.Size = 2; 
            param.Value = Depot_Code;
            lstParam.Add(param);

            param = new SqlParameter();
            param.ParameterName = "@Trip_No";
            param.SqlDbType = SqlDbType.NVarChar;
            param.Value = Trip_No;
            lstParam.Add(param);

            param = new SqlParameter();
            param.ParameterName = "@Vechicle_Arrival_Date";
            param.SqlDbType = SqlDbType.SmallDateTime;
            param.Value = Vechicle_Arrival_Date;
            lstParam.Add(param);

            param = new SqlParameter();
            param.ParameterName = "@Total_No_Qty";
            param.SqlDbType = SqlDbType.Int;
            param.Value = Total_No_Qty;
            lstParam.Add(param);

            res = new eAuctionDAL.SQLDAL().UpdateTransData(sel, lstParam, false);
            return res;
        }

How to handle this .

please help me.



thanks

How to handle this .
please help me.

thanks

推荐答案

Resources:Language, Common_Sr %>\"
HeaderStyle-Width=\"30px\" HeaderStyle-HorizontalAlign=\"Center\">
<itemtemplate>
<asp:Label ID=\"lblSr\" runat=\"server\" Text='<%#Container.DataItemIndex+1%>'>
</itemtemplate>
<HeaderStyle HorizontalAlign=\"Center\" Width =\"30px\" />

<asp:TemplateField HeaderStyle-HorizontalAlign=\"Center\" ItemStyle-HorizontalAlign=\"Center\"
HeaderText=\"\">
<itemtemplate> $ b$b <asp:LinkButton ID=\"lbnEdit\" runat=\"server\"
Text=\"<%

Resources:Language, Common_Sr %>" HeaderStyle-Width="30px" HeaderStyle-HorizontalAlign="Center"> <itemtemplate> <asp:Label ID="lblSr" runat="server" Text='<%#Container.DataItemIndex+1%>'> </itemtemplate> <HeaderStyle HorizontalAlign="Center" Width="30px" /> <asp:TemplateField HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" HeaderText=""> <itemtemplate> <asp:LinkButton ID="lbnEdit" runat="server" Text="<%

Resources:Language, Common_Edit %>\" CausesValidation=\"false\"
CommandName=\"Edit\">
</itemtemplate>
<HeaderStyle HorizontalAlign=\"Center\" />
<itemstyle wrap=\"false\" />


<asp:TemplateField HeaderStyle-HorizontalAlign=\"Center\" ItemStyle-HorizontalAlign=\"Center\"
HeaderText=\"\">
<itemtemplate>
<asp:LinkButton ID=\"lbnDelete\" runat=\"server\"
Text=\"<%

Resources:Language, Common_Edit %>" CausesValidation="false" CommandName="Edit"> </itemtemplate> <HeaderStyle HorizontalAlign="Center" /> <itemstyle wrap="false" /> <asp:TemplateField HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" HeaderText=""> <itemtemplate> <asp:LinkButton ID="lbnDelete" runat="server" Text="<%

Resources:Language, Common_Delete %>\" CausesValidation=\"false\"
OnClientClick=\"return confirm('Are you sure you want to delete this record?');\"
CommandName=\"Delete\">
</itemtemplate>
<HeaderStyle HorizontalAlign=\"Center\" />
<itemstyle wrap=\"false\" />

<asp:TemplateField HeaderStyle-HorizontalAlign=\"Center\" HeaderText=\"<%

Resources:Language, Common_Delete %>" CausesValidation="false" OnClientClick="return confirm('Are you sure you want to delete this record?');" CommandName="Delete"> </itemtemplate> <HeaderStyle HorizontalAlign="Center" /> <itemstyle wrap="false" /> <asp:TemplateField HeaderStyle-HorizontalAlign="Center" HeaderText="<%

这篇关于如何在gridview_RowCommand中处理多个值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！