Change ASP.Net GridView cell value based on condition using C# and VB.Net

Tevin

SOLVED CLOSED ACTIVE ANSWERED
User: Tevin
Posted: on Jun 10, 2019 04:57 AM
Forum: Data Controls
Answer: 1
Views: 10434

I have a Grid view control with a few columns that is populated from a form that the user fills in.

In the form some values are not mandatory and if the user does not select them, then it is displayed as "select" in the Grid view.

How do i go about changing that value to something for relative like "none" when i load the Grid view.

In other words, if that column contains "select" then change it to "None"

This is my code behind to populate my Gridview

Private Sub LoadGridAll()
    txtSearchEmployee.Text = ""
    Try
        Using conn As New SqlConnection(ConfigurationManager.ConnectionStrings("XXX").ConnectionString)

            Using cmd As New SqlCommand("SELECT EmployeeCodes.Code, EmployeeCodes.FirstName , EmployeeCodes.LastName , EmployeeCodes.EmployeeID , CostCentre , ExaminationType.ExaminationTypeName  , PhysicalExam.PhysicalExamName , ExaminationType.ExaminationTypeName  , PhysicalExam.PhysicalExamName , Audiogram.AudiogramName , AudiogramRec.AudiogramRecName,LungFunction.LungFunctionName,ChestResults,ECGResult,DrugScreeningResult,BloodGlucoseResult,GGTResult,LeftEyeDayNight,RightEyeDayNight,LeftEyeCorrDayNight,RightEyeCorrDayNight,VisualFieldLeftDayNight,VisualFieldRightDayNight,ColourVisionDayNight,DeptPerceptionDayNight,OptometristYesNo,Outcome.Name , OutcomeRecommendations.OutcomeRecommendationsName,OtherProblems,Notes,DateTested,NextDueDate FROM  MedicalResults,EmployeeCodes,ExaminationType,PhysicalExam,Audiogram,AudiogramRec,LungFunction,Outcome,OutcomeRecommendations WHERE MedicalResults.EmployeeID = EmployeeCodes.EmployeeID AND ExaminationType.ExaminationTypeID = MedicalResults.ExaminationTypeID AND PhysicalExam.PhysicalExamID = MedicalResults.PhysicalExamType AND Audiogram.AudiogramID = MedicalResults.AudiogramID AND MedicalResults.AudiogramRecID = AudiogramRec.AudiogramRecID AND LungFunction.LungFunctionID = MedicalResults.LungFunctionID AND OutcomeRecommendations.OutcomeRecommendationsID = MedicalResults.OutcomeRecommendationsID AND Outcome.OutcomeID = MedicalResults.OutcomeID ", conn)
                conn.Open()
                Dim sda As New SqlDataAdapter(cmd)
                Dim dt As New DataTable()
                sda.Fill(dt)
                For Each row As DataRow In dt.Rows
                    Dim strDetail As Object
                    strDetail = row.Item(10)
                    If strDetail = "Select" Then
                        strDetail = "None"
                    End If
                Next row
                GridViewAll.DataSource = dt               
                GridViewAll.DataBind()
                conn.Close()
            End Using
        End Using
    Catch ex As Exception
    End Try
End Sub

Download FREE API for Word, Excel and PDF in ASP.Net

pandeyis...

0 4

Reply
ANSWER
User: pandeyism
Replied: on Jun 10, 2019 06:39 AM
Report

Hi Tevin,

Refer below sample.

HTML

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" OnRowDataBound="GridView1_RowDataBound">
    <Columns>
        <asp:BoundField DataField="EmployeeCode" HeaderText="EmployeeCode" />
        <asp:BoundField DataField="Name" HeaderText="Name" />
        <asp:BoundField DataField="Type" HeaderText="Type" />
    </Columns>
</asp:GridView>

Namespaces

using System.Data;

VB.Net

Imports System.Data

Code

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        DataTable dt = new DataTable();
        dt.Columns.AddRange(new DataColumn[] { new DataColumn("EmployeeCode", typeof(int)), new DataColumn("Name", typeof(string)), new DataColumn("Type", typeof(string)) });
        dt.Rows.Add(1, "Mudassar", "Select");
        dt.Rows.Add(2, "John", "Deselect");
        dt.Rows.Add(3, "Robert", "Select");
        dt.Rows.Add(4, "Suzanne", "Select");
        this.GridView1.DataSource = dt;
        this.GridView1.DataBind();
    }
}

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        if (e.Row.Cells[2].Text == "Select")
        {
            e.Row.Cells[2].Text = "None";
        }
    }
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    If Not Me.IsPostBack Then
        Dim dt As DataTable = New DataTable()
        dt.Columns.AddRange(New DataColumn() {New DataColumn("EmployeeCode", GetType(Integer)), New DataColumn("Name", GetType(String)), New DataColumn("Type", GetType(String))})
        dt.Rows.Add(1, "Mudassar", "Select")
        dt.Rows.Add(2, "John", "Deselect")
        dt.Rows.Add(3, "Robert", "Select")
        dt.Rows.Add(4, "Suzanne", "Select")
        Me.GridView1.DataSource = dt
        Me.GridView1.DataBind()
    End If
End Sub

Protected Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As GridViewRowEventArgs)
    If e.Row.RowType = DataControlRowType.DataRow Then
        If e.Row.Cells(2).Text = "Select" Then
            e.Row.Cells(2).Text = "None"
        End If
    End If
End Sub

Screenshot

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Change ASP.Net GridView cell value based on condition using C# and VB.Net

Company

Explore

Follow us

Contact Us