Check Column Data And Set Yes No In New Column[Answered] RSS

1 reply

Last post Oct 08, 2019 09:33 AM by samwu

‹ Previous Thread|Next Thread ›

Shortcuts

Related Links

Gopi.MCA

Member

294 Points

679 Posts

Check Column Data And Set Yes No In New Column

Oct 07, 2019 06:33 PM|Gopi.MCA|LINK

Hello

This is my code

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="TESTFile.aspx.cs" Inherits="TESTFile" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
 <asp:GridView ID="GridView1" runat="server" Font-Bold="False"
            Font-Names="Calibri" Font-Size="12pt" AutoGenerateColumns="False" >
            <Columns>
                <asp:BoundField DataField="ID" HeaderText="ID" SortExpression="ID">
                    <ItemStyle HorizontalAlign="Left" ForeColor="Black" Wrap="True" Width="100px" />
                </asp:BoundField>
                <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name">
                    <ItemStyle HorizontalAlign="Left" ForeColor="Black" Wrap="True" Width="100px" />
                </asp:BoundField>
                <asp:TemplateField HeaderText="Qty">
                    <EditItemTemplate>
                        <asp:TextBox ID="TextBox4" runat="server" Text='<%# Bind("Qty") %>'></asp:TextBox>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="L1" runat="server" Text='<%# Bind("Qty") %>'></asp:Label>
                    </ItemTemplate>
                    <ItemStyle ForeColor="Black" HorizontalAlign="Right" Width="100px" Wrap="True" />
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Rate">
                    <EditItemTemplate>
                        <asp:TextBox ID="TextBox4" runat="server" Text='<%# Bind("Rate") %>'></asp:TextBox>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="L2" runat="server" Text='<%# Bind("Rate") %>'></asp:Label>
                    </ItemTemplate>
                    <ItemStyle ForeColor="Black" HorizontalAlign="Right" Width="100px" Wrap="True" />
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Name2">
                    <EditItemTemplate>
                        <asp:TextBox ID="TextBox4" runat="server" Text='<%# Bind("Name2") %>'></asp:TextBox>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="L3" runat="server" Text='<%# Bind("Name2") %>'></asp:Label>
                    </ItemTemplate>
                    <ItemStyle ForeColor="Black" HorizontalAlign="Right" Width="100px" Wrap="True" />
                </asp:TemplateField>
            </Columns>
        </asp:GridView>

 
</asp:Content>

code behind example

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Collections.Specialized;
using System.Text;
using System.Drawing;
using System.IO;
using System.Net;
using System.Net.Mail;
using System.Net.Configuration;
public partial class TESTFile : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            DataTable dt = new DataTable();
            dt.Columns.AddRange(new DataColumn[5] { new DataColumn("ID"), new DataColumn("Name"), new DataColumn("Qty"), new DataColumn("Rate"), new DataColumn("Name2") });
            dt.Rows.Add(1, "AA", 10, 1, "AA");
            dt.Rows.Add(2, "BB", 20, 2, "B");
            dt.Rows.Add(3, "CC", 5, 5, "V");
            dt.Rows.Add(4, "DD", 10, 5, "DD");
            dt.Rows.Add(4, "EE", 10, 5, "EE");
            dt.Rows.Add(4, "F", 10, 5, "FF");

           
            GridView1.DataSource = dt;
            GridView1.DataBind();
            
        }
    }

   

    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
       
    }


    
 
}

it showing result set like this

but i want like this

how to do automatically

Thanking You

samwu

Contributor

3370 Points

1409 Posts

Re: Check Column Data And Set Yes No In New Column

Oct 08, 2019 09:33 AM|samwu|LINK

Hi Gopi.MCA,

Gopi.MCA
how to do automatically

According to your description, i made demo for your.

I bulided a TemplateField in aspx firstly, then set the value of TemplateField by comparing the values of name and name2.

The code:

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" OnRowDataBound="GridView1_RowDataBound" >
                <Columns>
                    <asp:BoundField DataField="ID" HeaderText="ID" SortExpression="ID">
                        <ItemStyle HorizontalAlign="Left" ForeColor="Black" Wrap="True" Width="100px" />
                    </asp:BoundField>

                    <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name">
                        <ItemStyle HorizontalAlign="Left" ForeColor="Black" Wrap="True" Width="100px" />
                    </asp:BoundField>

                    <asp:TemplateField HeaderText="Qty">
                        <EditItemTemplate>
                            <asp:TextBox ID="TextBox4" runat="server" Text='<%# Bind("Qty") %>'></asp:TextBox>
                        </EditItemTemplate>
                        <ItemTemplate>
                            <asp:Label ID="L1" runat="server" Text='<%# Bind("Qty") %>'></asp:Label>
                        </ItemTemplate>
                        <ItemStyle ForeColor="Black" HorizontalAlign="Right" Width="100px" Wrap="True" />
                    </asp:TemplateField>

                    <asp:TemplateField HeaderText="Rate">
                        <EditItemTemplate>
                            <asp:TextBox ID="TextBox4" runat="server" Text='<%# Bind("Rate") %>'></asp:TextBox>
                        </EditItemTemplate>
                        <ItemTemplate>
                            <asp:Label ID="L2" runat="server" Text='<%# Bind("Rate") %>'></asp:Label>
                        </ItemTemplate>
                        <ItemStyle ForeColor="Black" HorizontalAlign="Right" Width="100px" Wrap="True" />
                    </asp:TemplateField>

                    <asp:TemplateField HeaderText="Name2">
                        <EditItemTemplate>
                            <asp:TextBox ID="TextBox4" runat="server" Text='<%# Bind("Name2") %>'></asp:TextBox>
                        </EditItemTemplate>
                        <ItemTemplate>
                            <asp:Label ID="L3" runat="server" Text='<%# Bind("Name2") %>'></asp:Label>
                        </ItemTemplate>
                        <ItemStyle ForeColor="Black" HorizontalAlign="Right" Width="100px" Wrap="True" />
                    </asp:TemplateField>


                    <asp:TemplateField HeaderText="Name2">                    
                        <ItemTemplate>                         
                        </ItemTemplate>
                        <ItemStyle ForeColor="Black" HorizontalAlign="Right" Width="100px" Wrap="True" />
                    </asp:TemplateField>
                </Columns>
            </asp:GridView>


protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            Label lb = new Label();
            foreach (GridViewRow row in GridView1.Rows)
            {
                string a = row.Cells[1].Text;
                
                Label l3 = (Label)row.FindControl("L3");
                string b = l3.Text;

                if (a == b)
                {
                    lb.Text = "Yes matched";
                }
                else
                {
                    lb.Text = "No matched";
                }
                row.Cells[5].Controls.Add(lb);
            }
        }

The result:

Best regards,

Sam

.NET forums are moving to a new home on Microsoft Q&A, we encourage you to go to Microsoft Q&A for .NET for posting new questions and get involved today.

‹ Previous Thread|Next Thread ›