I've just started using ASP.NET again after a long layoff. I wasn't any good back then and now I'm worse. This is also my first work with Oracle 9i. Long story short:

GetSellOffDates SQL in TableAdapter
Code:
select
  to_date(custd.FIELD_VALUE, 'dd-mon-yyyy'),
  ag.AGREEMENTS_ABBR,
  ag.AGREEMENTS_NAME,
  ag.CONTRACTSTATUS_NAME,
  ag.CONTRACT_CODE,
  ag.SITE_CODE,
  custd.INTERNAL_DESCRIPTIONS_CODE,
  custd.DESCRIPTIONS_NAME
from V_REPCUSTOMFIELDDATA custd
  right join V_AGREEMENT ag
    on custd.ASSOCIATED_WITH_INTERNAL_KEY = ag.CONTRACT_CODE
where 
  custd.INTERNAL_DESCRIPTIONS_CODE = 35
  and ag.AGREEMENTS_ABBR like upper(:licensorNum)
  and custd.FIELD_VALUE between 
    to_date(:sellOffStart, 'mm/dd/yyyy') and to_date(:sellOffEnd, 'mm/dd/yyyy')
order by
  custd.FIELD_VALUE,
  ag.AGREEMENTS_ABBR
Building and filling the GridView:
vb.net Code:
  1. ' Blank column
  2. Dim sellOff As New BoundField()
  3. sellOff.HeaderText = "Sell Off Date"
  4. sellOff.DataField = "FIELD_VALUE"
  5. Me.GridView1.Columns.Add(sellOff)
  6.  
  7. ' This one is fine as are all others.
  8. Dim licensorNum As New BoundField()
  9. licensorNum.HeaderText = "Licensor Number"
  10. licensorNum.DataField = "AGREEMENTS_ABBR"
  11. Me.GridView1.Columns.Add(licensorNum)
  12.  
  13. <snip>
  14.  
  15. Dim ta As New MMDataSetTableAdapters.V_REPCUSTOMFIELDDATATableAdapter
  16. Dim dt As Data.DataTable = ta.GetSellOffDates("%" & Me.licensorNum.Text & "%", Me.sellOffStart.Text, Me.sellOffEnd.Text)
  17.  
  18. Me.GridView1.DataSource = dt
  19. Me.GridView1.DataBind()

Everything works just fine, except for the fact that the "Sell Off Date" column in my GridView is blank. Every cell in this column is empty. However, the results appear to be returned correctly - i.e. I get the right number of rows based upon the values of my Parameters, the Order By clause orders the rows correctly and all the columns are populated EXCEPT for the "Sell Off Date" column. Does that make sense?

I'm sure I'm missing some easy, probably in the formatting of the column, but I've been staring at it a long time to no avail. Any help is appreciated.