No row is being returned from the following query. The problem is with the TryCast expression, cause I can hardcode a value and it works fine.
MyQuery = New SqlCommand("SELECT ACL, FCICCODEV, FSDESC FROM FSS_AFIS WHERE FSN = '" & TryCast(GridView2.FooterRow.FindControl("cbo_statute"), DropDownList).SelectedItem.Value & "'", SmartCopConnection)
and here's the aspx:<asp:TemplateField Go to the complete details ...