I have a group of data items that I'm displaying using a repeater. Two of the data items are the same (date and employee) for all records. I want to pull these out of the report and just show them once in my table. I've tried using the <%# DataBinder.Eval(Container.DataItem, "date")%> in the Repeater header, but it does not show up.

I've taken these fields out of the repeater and set up two labels (consultdate and consultemp). Now I've tried to assign the values to these using the following code:

SqlConnection1.Open()
   GetConsultHist.Parameters.Item("@pid").Value = ptid.Text

   Dim myHistReader As SqlDataReader = GetConsultHist.ExecuteReader

   If myHistReader.Read Then
      consultdate.Text = myHistReader.Item(1)
      consultemp.Text = myHistReader.Item(0)
   Else
      consultdate.Text = "data not available"
   End If

   ConsultRepeater.DataSource = myHistReader
   ConsultRepeater.DataBind()

SqlConnection1.Close()

The problem with this solution is that the data in the repeater is missing the first record. I solved that by setting the datasource and databinding above the myHistReader.read, but doing that always returns "data not available" although there are clearly records on the page.

So, I'm thinking that I need to reset the reader before I do a .read, but I don't know how to do this.

Any hints would be greatly appreciated!

DataReaders are forward-only read-only. Also known as firehose data providers. Once you open the hose, you can't put the water back into it: i.e. once you have read any record (with either .Read() or by binding to a control) you can't go back. You could solve this by using a dataset and then access the datatable for the two values and still be able to bind the table to the repeater.

Peter
------------------------------------------------------
Work smarter, not harder.