How to dinamically display a button on a GridView based on Cell value ASP C#

Question

0.00/5 (No votes)

See more:

Hiya, I wonder if anyone can help me with this code.
What I am trying to do, is to read records from a database and display them on a gridview. However my last column of the grid is a templateField which I display an imageButton to do something once clicked.
My problem is :

How to display the ImageButton only when a particularly Cell of the grid is value true.
I was trying to set the ImageButton to false when the value was False, but it is not working

Any help please

*******************************************************

private void BindCustomDateBookings()
{
try
{
//Gets the date chosen by the user
var customDate = Convert.ToDateTime(txtDatePicker.Text);

//Creates a connection to the database
SqlConnection connectionViewBookings = new SqlConnection(connectionString);
//Query builder
SqlDataAdapter dataAdapterViewBookings = new SqlDataAdapter(queryCustomDateBookings, connectionViewBookings);
dataAdapterViewBookings.SelectCommand.Parameters.AddWithValue("@customDate", customDate);

//Create the data that will hold the result of DB
DataSet dataSetViewTodaysBookings = new DataSet();

//open, save results and close connection
connectionViewBookings.Open();
dataAdapterViewBookings.Fill(dataSetViewTodaysBookings);
connectionViewBookings.Close();

//fill the grid with results
GridViewCustomDate.DataSource = dataSetViewTodaysBookings.Tables[0];
GridViewCustomDate.DataBind();
}
catch (SqlException SqlExceptionTomorrow)
{
Response.Write(@"<SCRIPT LANGUAGE=""JavaScript"">alert('Could not connect to the database This date bookings')</SCRIPT>");
}
}//Ends Bind Custom Date bookings

***********************************************************
And the grid view has the following coded

XML

<asp:GridView ID="GridViewCustomDate" runat="server" AutoGenerateColumns="False" CssClass="viewBookingTable" GridLines="None"
             HeaderStyle-CssClass="gridViewHeader">
             <HeaderStyle CssClass="gridViewHeader" />
             <RowStyle CssClass="GridViewRowStyle" />
             <AlternatingRowStyle CssClass="GridViewAlternatingRowStyle " />

              <Columns>
                  <asp:BoundField DataField="bookingID" ItemStyle-CssClass="displayGridViewID"
                      HeaderStyle-CssClass="displayGridViewID" >
                  <HeaderStyle CssClass="displayGridViewID" />
                  <ItemStyle CssClass="displayGridViewID" />
                  </asp:BoundField>
             <asp:BoundField DataField="visitorName" HeaderText="Visitor Name" />
             <asp:BoundField DataField="contactNo" HeaderText="contactNo" />
             <asp:BoundField DataField="hostName" HeaderText="Host Name" />
             <asp:BoundField DataField="roomName" HeaderText="Room Name" />
             <asp:BoundField DataField="timeIn" HeaderText="Time In" />
             <asp:BoundField DataField="smartCardNo" HeaderText="Smart Card No" />
                  <asp:TemplateField HeaderText="Required Access">
                      <ItemTemplate>
                          <asp:ImageButton ID="btnGetRequiredAccessCustomDate" runat="server"
                              ImageUrl="~/images/buttons/clickMe.png"
                              onclick="btnGetRequiredAccessCustomDate_Click" />
                      </ItemTemplate>
                  </asp:TemplateField>
              </Columns>

        </asp:GridView>

Posted 17-Dec-13 2:52am

Member 10409553

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ehsan Skardu · Answer 1 · 2013-12-17T03:29:00

Hi,
you can just add the following cond in your imagebutton code

ASP.NET

<asp:imagebutton id="btnGetRequiredAccessCustomDate" runat="server" xmlns:asp="#unknown">
                              ImageUrl="~/images/buttons/clickMe.png"
                  Visible='<%#string.IsNullOrEmpty(Eval('ColumnName')==true? "false":"true" %>'
                              onclick="btnGetRequiredAccessCustomDate_Click" /></asp:imagebutton>

Karthik_Mahalingam · Answer 2 · 2013-12-17T03:54:00

Have a look at this simple example, It might help you..
You have to assign a bound field ( boolean ) value to the visible property of the button.

C#

DataTable dt = new DataTable();
              dt.Columns.Add("smartCardNo", typeof(string));
              dt.Columns.Add("FlagVisible_Invisible", typeof(bool));
              dt.Rows.Add("one", false);
              dt.Rows.Add("two", true);
              dt.Rows.Add("three", true);

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

XML

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" Width="100%">
        <Columns>
         <asp:BoundField DataField="smartCardNo" HeaderText="Smart Card No" />
            <asp:TemplateField HeaderText="Required Access">
                <ItemTemplate>
                    <asp:ImageButton ID="btnGetRequiredAccessCustomDate" Visible='<%# Eval("FlagVisible_Invisible") %>' runat="server" ImageUrl="~/images/buttons/clickMe.png"
                          />
                </ItemTemplate>
            </asp:TemplateField>
        </Columns>
    </asp:GridView>

Ganesh KP · Answer 3 · 2013-12-17T04:28:00

Solution 3

Have a look at this link http://stackoverflow.com/questions/17588934/how-to-add-button-in-gridview-dynamically[^]

or this link

How to create template columns dynamically in a grid view[^]

Thanks
Ganesh

Posted 17-Dec-13 4:28am

Ganesh KP

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 4 · 2013-12-17T04:39:00

You can use RowDataBound Event.
Add OnRowDataBound="GridViewCustomDate_RowDataBound" to the GridView Markup.

C#

protected void GridViewCustomDate_RowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        // Get that Column value.
        if (!thatValue)
        {
            ((Image)e.Row.FindControl("btnGetRequiredAccessCustomDate")).Visible = false;
        }
    }
}

How to dinamically display a button on a GridView based on Cell value ASP C#

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0