使用JS将文本添加到GridView列上的按钮按下

Question

我有一个GridView，可以从服务器上的表中生成数据。我在网格的开头添加了一个按钮，并在网格末端有一个空列。

ASPX：

<asp:GridView ID="MergeInfoGrid" class="FirstCarInfoGrid" runat="server" OnRowDataBound="MergeInfoGrid_RowDataBound">
                            <Columns>
                                <asp:TemplateField HeaderText="Switch">
                                    <ItemTemplate>
                                        <asp:Button ID="btnSwitch" runat="server" CommandName="Select" Text="Switch" />
                                    </ItemTemplate>
                                </asp:TemplateField>
                            </Columns>
                        </asp:GridView>

CS：

protected void bindMergeInfoGrid()
{
    SqlConnection sqlConn = new SqlConnection(Connection);
    sqlConn.Open();
    //vehicle 1//
    string V1Firstname = "";
    string V1LastName = "";
    string V1Address = "";
    string V1City = "";
    string V1State = "";
    string V1Zipcode = "";
    string V1Phone = "";
    string V1Cell = "";
    string V1Plate = "";
    string V1Vin = "";
    string V1ManuVin = "";
    DateTime V1PurchaseDate = DateTime.MinValue;
    string V1eMail = "";
    string V1Notes = "";
    string strQuery = "SELECT Firstname, LastName, Address, City, State, Zipcode, Phone, Cell, LicensePlate, Vin, ManuVin, Purchasedate, EMail, Notes FROM Cusdata where LicensePlate = '" + mergeCarPlate.Text.Trim() + "'";
    SqlCommand cmdQuery = new SqlCommand(strQuery, sqlConn);
    SqlDataReader reader = cmdQuery.ExecuteReader();
    while (reader.Read())
    {
        V1Firstname = reader.IsDBNull(0) ? "" : reader.GetString(0);
        V1LastName = reader.IsDBNull(1) ? "" : reader.GetString(1);
        V1Address = reader.IsDBNull(2) ? "" : reader.GetString(2);
        V1City = reader.IsDBNull(3) ? "" : reader.GetString(3);
        V1State = reader.IsDBNull(4) ? "" : reader.GetString(4);
        V1Zipcode = reader.IsDBNull(5) ? "" : reader.GetString(5);
        V1Phone = reader.IsDBNull(6) ? "" : reader.GetString(6);
        V1Cell = reader.IsDBNull(7) ? "" : reader.GetString(7);
        V1Plate = reader.IsDBNull(8) ? "" : reader.GetString(8);
        V1Vin = reader.IsDBNull(9) ? "" : reader.GetString(9);
        V1ManuVin = reader.IsDBNull(10) ? "" : reader.GetString(10);
        V1PurchaseDate = reader.IsDBNull(11) ? DateTime.MinValue : reader.GetDateTime(11);
        V1eMail = reader.IsDBNull(12) ? "" : reader.GetString(12);
        V1Notes = reader.IsDBNull(13) ? "" : reader.GetString(13);
    }
    reader.Close();

    //vehicle 2//
    string V2Firstname = "";
    string V2LastName = "";
    string V2Address = "";
    string V2City = "";
    string V2State = "";
    string V2Zipcode = "";
    string V2Phone = "";
    string V2Cell = "";
    string V2Plate = "";
    string V2Vin = "";
    string V2ManuVin = "";
    DateTime V2PurchaseDate = DateTime.MinValue;
    string V2eMail = "";
    string V2Notes = "";
    strQuery = "SELECT Firstname, LastName, Address, City, State, Zipcode, Phone, Cell, LicensePlate, Vin, ManuVin, Purchasedate, EMail, Notes FROM Cusdata where LicensePlate = '" + mergePlateSearch.Text.Trim() + "'";
    cmdQuery = new SqlCommand(strQuery, sqlConn);
    reader = cmdQuery.ExecuteReader();
    while (reader.Read())
    {
        V2Firstname = reader.IsDBNull(0) ? "" : reader.GetString(0);
        V2LastName = reader.IsDBNull(1) ? "" : reader.GetString(1);
        V2Address = reader.IsDBNull(2) ? "" : reader.GetString(2);
        V2City = reader.IsDBNull(3) ? "" : reader.GetString(3);
        V2State = reader.IsDBNull(4) ? "" : reader.GetString(4);
        V2Zipcode = reader.IsDBNull(5) ? "" : reader.GetString(5);
        V2Phone = reader.IsDBNull(6) ? "" : reader.GetString(6);
        V2Cell = reader.IsDBNull(7) ? "" : reader.GetString(7);
        V2Plate = reader.IsDBNull(8) ? "" : reader.GetString(8);
        V2Vin = reader.IsDBNull(9) ? "" : reader.GetString(9);
        V2ManuVin = reader.IsDBNull(10) ? "" : reader.GetString(10);
        V2PurchaseDate = reader.IsDBNull(11) ? DateTime.MinValue : reader.GetDateTime(11);
        V2eMail = reader.IsDBNull(12) ? "" : reader.GetString(12);
        V2Notes = reader.IsDBNull(13) ? "" : reader.GetString(13);
    }
    reader.Close();

    DataTable dt = new DataTable();
    dt.Columns.Add("Category", typeof(string));
    dt.Columns.Add("Vehicle 1", typeof(string));
    dt.Columns.Add("Vehicle 2", typeof(string));
    dt.Columns.Add("What Stays", typeof(string));

    for (int rowCounter = 0; rowCounter < 13; rowCounter++)
    {
        switch (rowCounter)
        {
            case 0:
                DataRow dr = dt.NewRow();
                dr["Category"] = "First Name";
                dr["Vehicle 1"] = V1Firstname;
                dr["Vehicle 2"] = V2Firstname;
                dr["What Stays"] = WhatStaysFirstName.Value;
                dt.Rows.Add(dr);
                break;
            case 1:
                dr = dt.NewRow();
                dr["Category"] = "Last Name";
                dr["Vehicle 1"] = V1LastName;
                dr["Vehicle 2"] = V2LastName;
                dr["What Stays"] = WhatStaysLastName.Value;
                dt.Rows.Add(dr);
                break;
            case 2:
                dr = dt.NewRow();
                dr["Category"] = "Address";
                dr["Vehicle 1"] = V1Address;
                dr["Vehicle 2"] = V2Address;
                dr["What Stays"] = WhatStaysAddress.Value;
                dt.Rows.Add(dr);
                break;
            case 3:
                dr = dt.NewRow();
                dr["Category"] = "City";
                dr["Vehicle 1"] = V1City;
                dr["Vehicle 2"] = V2City;
                dr["What Stays"] = WhatStaysCity.Value;
                dt.Rows.Add(dr);
                break;
            case 4:
                dr = dt.NewRow();
                dr["Category"] = "Zipcode";
                dr["Vehicle 1"] = V1Zipcode;
                dr["Vehicle 2"] = V2Zipcode;
                dr["What Stays"] = WhatStaysZipcode.Value;
                dt.Rows.Add(dr);
                break;
            case 5:
                dr = dt.NewRow();
                dr["Category"] = "Phone";
                dr["Vehicle 1"] = V1Phone;
                dr["Vehicle 2"] = V2Phone;
                dr["What Stays"] = WhatStaysPhone.Value;
                dt.Rows.Add(dr);
                break;
            case 6:
                dr = dt.NewRow();
                dr["Category"] = "Cell";
                dr["Vehicle 1"] = V1Cell;
                dr["Vehicle 2"] = V2Cell;
                dr["What Stays"] = WhatStaysCell.Value;
                dt.Rows.Add(dr);
                break;
            case 7:
                dr = dt.NewRow();
                dr["Category"] = "Plate";
                dr["Vehicle 1"] = V1Plate;
                dr["Vehicle 2"] = V2Plate;
                dr["What Stays"] = WhatStaysPlate.Value;
                dt.Rows.Add(dr);
                break;
            case 8:
                dr = dt.NewRow();
                dr["Category"] = "Vin";
                dr["Vehicle 1"] = V1Vin;
                dr["Vehicle 2"] = V2Vin;
                dr["What Stays"] = WhatStaysVin.Value;
                dt.Rows.Add(dr);
                break;
            case 9:
                dr = dt.NewRow();
                dr["Category"] = "ManuVin";
                dr["Vehicle 1"] = V1ManuVin;
                dr["Vehicle 2"] = V2ManuVin;
                dr["What Stays"] = WhatStaysManuVin.Value;
                dt.Rows.Add(dr);
                break;
            case 10:
                dr = dt.NewRow();
                dr["Category"] = "Purchase Date";
                dr["Vehicle 1"] = V1PurchaseDate;
                dr["Vehicle 2"] = V2PurchaseDate;
                dr["What Stays"] = WhatStaysPurchaseDate.Value;
                dt.Rows.Add(dr);
                break;
            case 11:
                dr = dt.NewRow();
                dr["Category"] = "eMail";
                dr["Vehicle 1"] = V1eMail;
                dr["Vehicle 2"] = V2eMail;
                dr["What Stays"] = WhatStayseMail.Value;
                dt.Rows.Add(dr);
                break;
            case 12:
                dr = dt.NewRow();
                dr["Category"] = "Notes";
                dr["Vehicle 1"] = V1Notes;
                dr["Vehicle 2"] = V2Notes;
                dr["What Stays"] = WhatStaysNotes.Value;
                dt.Rows.Add(dr);
                break;
        }
    }
    MergeInfoGrid.DataSource = dt;
    MergeInfoGrid.DataBind();
    dataDifferenceDiv.Style.Add("Display", "block");
    sqlConn.Close();
}

public void MergeInfoGrid_RowDataBound(Object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        e.Row.Attributes.Add("onmouseover", "this.style.backgroundColor='#ceedfc'");
        e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=''");
    }
    
}

我想使用按钮在“车辆1”和“车辆2”列中的数据之间切换“停留”列中的内容。我还希望使用JavaScript在按钮上单击“这样做”，以便每次点击时都不需要任何后备。

Answer 1

您实际上是否认为有人会拖延您发布的所有代码？您真的觉得有必要带一个大型木制俱乐部，然后将海报击中果肉，然后痛苦和痛苦地将其送往医院，以阅读所有代码？

根本不清楚该代码应该做什么，但是更糟糕的是，您的问题似乎根本没有遵循发布的代码，对吗？

使用按钮在“车辆1”和“车辆2”列中的数据之间切换内容。

在哪里？我看不到任何标记或一些称为车辆1的列。

此外，甚至还没有清楚为什么您有所有这些变量和代码？做什么的？

因此，您当然可以加载数据表，然后将其发送给GridView。

因此，说我们有一个网格视图：

        <asp:GridView ID="GHotels" runat="server" CssClass="table" AutoGenerateColumns="false"
            width="45%" DataKeyNames="ID" >
            <Columns>
                <asp:BoundField DataField="FirstName" HeaderText="FirstName"  />
                <asp:BoundField DataField="LastName" HeaderText="LastName"    />
                <asp:BoundField DataField="HotelName" HeaderText="HotelName"  />
                <asp:BoundField DataField="Description" HeaderText="Description" ItemStyle-Width="270" />

                <asp:TemplateField HeaderText = "Copy hotel" ItemStyle-HorizontalAlign ="Center" >
                    <ItemTemplate>
                    <asp:Button ID="cmdRow" runat="server" Text="Copy hotel" 
                       CssClass="btn"  OnClick="cmdRow_Click" />
                    </ItemTemplate>
                </asp:TemplateField>

                <asp:TemplateField HeaderText = "copy of Hotel name" >
                    <ItemTemplate>
                        <asp:Label ID="txtHotelC" runat="server" Width="140px"></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>

            </Columns>
        </asp:GridView>

因此，可以这样说：

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
            LoadData();
    }

    void LoadData()
    {
        using (SqlConnection conn = new SqlConnection(Properties.Settings.Default.TEST4))
        {
            string strSQL = 
                "SELECT * FROM tblHotelsA ORDER BY HotelName";
            using (SqlCommand cmdSQL = new SqlCommand(strSQL, conn))
            {
                DataTable rstData = new DataTable();
                conn.Open();
                rstData.Load(cmdSQL.ExecuteReader());
                GHotels.DataSource = rstData;
                GHotels.DataBind();
            }
        }
    }

<

a href =“ https://i.sstatic.net/haidb.png” noreferrer”>

因此，现在让我们将一个按钮行汇总到我们拥有的一个按钮行，然后说将酒店名称复制到最后一列。这将使您了解如何在GV中单击的一行操作。

因此，我们可以使用此代码进行按钮单击：

    protected void cmdRow_Click(object sender, EventArgs e)
    {
        Button btn = sender as Button;
        GridViewRow gRow = btn.NamingContainer as GridViewRow;

        string sHotelName = gRow.Cells[2].Text;

        // now copy this value over to the last colum - the label

        Label tHotel = gRow.FindControl("txtHotelC") as Label;

        tHotel.Text = sHotelName;

        // addtional information we can use aboput this row click

        Debug.Print("Row index click = " + gRow.RowIndex);
        Debug.Print("ID (data keys) = " + GHotels.DataKeys[gRow.RowIndex]["ID"].ToString());
        Debug.Print("FirstName = " + gRow.Cells[0].Text);
        Debug.Print("Last Name = " + gRow.Cells[1].Text);
    }

当我说单击第二行时，网格现在显示以下显示：

和输出窗口显示我们有关该行的其他信息，请单击问题：

所以，上面是Nutshell显示了如何获取行信息。显示您如何在一行上进行某些操作。

因此，从上方，您应该能够建立在尝试在一行中工作的操作。

一旦您丢弃了您发布的大量代码（以节省世界贫困），我们就可以使该代码用于行单击。完成后，我们可以考虑将该代码运行并在JavaScript中运行和操作客户端。

但是，我们首先需要摆脱您发布的大量代码 - 您不需要它，然后我们就可以提出一个问题 - 一个基于试图滥用和殴打海报的基于俱乐部和俱乐部，您发布的代码的船只船是没有意义的，不需要的。换句话说？尽量不要对愿意为您提供帮助的堆栈中的人们表现出如此巨大的仇恨和厌恶。