User809760674 posted
I have a gridview and when I select a row in the gridview the detailsview containing the data of that row opens. I want to show the submit button only when there is entry date in my table but I am getting script eror while doing so
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
DetailsView1.ChangeMode(DetailsViewMode.ReadOnly);
BindDetailsView();
Button1.Visible = true;
Button1.Text = "Edit";
con.Open();
string fin_dt = "select vendor_creation_req.ucs_entry_dt from vendor_creation_req where req_no='" + GridView1.SelectedValue + "'";
OleDbCommand cmd = new OleDbCommand(fin_dt, con);
OleDbDataReader dr = cmd.ExecuteReader();
dr.Read();
if (dr.HasRows && dr["ucs_entry_dt"] == DBNull.Value)
{
submit.Visible = false;
}
else if (dr.HasRows && dr["ucs_entry_dt"] != DBNull.Value)
{
submit.Visible = true;
}
dr.Close();
con.Close();
BindGrid();
GridView1.DataBind();
}
