Hide button based on SQL query

Question

Hi
I am trying to write a c# asp.net web app that shows which SQL jobs are running. The web app has start and stop buttons but I only want to show the start button if the job is stopped or show the stop button if the job is currently running. So how do I hide buttons based on the results of a SQL query.
Thanks
Mike

Madhu K · Accepted Answer

Initially make the buttons visibility as false.
Visible="false" CommandArgument=" "/>
Visible="false" CommandArgument=" "/>
In Row DataBound Event
check the database for whether the job is running or stopped
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
// Button btnStart = e.Row.FindControl("Button1") as Button;
// Button btnStop = e.Row.FindControl("Button2") as Button;
if (e.Row.RowType == DataControlRowType.DataRow)
{
if(job is running)
{
btnStop.Visible = true;
}
else
{
btnStart.Visible = true;
}
}

Mike · Answer

This put me on the right track, thanks alot Madhu. :)