Datagrid Not Showing Top Record 1

[sila]

Hi
I have a datagrid using a datareader to populate it. On running it the top record seems to be cut off each time in all cases. The stored procedure behind it is showing all records correctly?

Any ideas greatly appreciated.

Sila.

 

[ca8msm]

On running it the top record seems to be cut off each time in all cases

What do you mean "cut off"?

----------------------------------------------------------------------

Need help finding an answer?

Try the search facilty (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[sila]

It doesnt actually show the first record that I know show should be there from the stored procedure output.

 

[ca8msm]

IS it maybe confusing the first row with a Header row?

----------------------------------------------------------------------

Need help finding an answer?

Try the search facilty (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[checkai]

post how you bind your datagrid...

"...we both know I'm training to become a cagefigher...see what happens if you try 'n hit me..."

 

[sila]

DistrictID = Me.Request.QueryString("id")
ElecID = Session("ElecID")
Me.SqlComm_SelectDivList.Parameters("@DistrictID").Value = DistrictID
Me.SqlComm_SelectDivList.Parameters("@ElecID").Value = ElecID
Me.SqlConnection1.Open()
dtrDivisionList = Me.SqlComm_SelectDivList.ExecuteReader
If dtrDistrict.Read Then
Session("DisName") = dtrDivisionList("DisName")
End If
Me.DataGrid1.DataSource = dtrDivisionList
Me.DataGrid1.DataBind()
dtrDivisionList.Close()
Me.SqlConnection1.Close()

 

[ca8msm]

Just as a side point why do you do the following if it is returning more than one record:

        If dtrDistrict.Read Then
            Session("DisName") = dtrDivisionList("DisName")
        End If

That will just overwrite the session variable each time.

----------------------------------------------------------------------

Need help finding an answer?

Try the search facilty (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[sila]

I just removed....

If dtrDistrict.Read Then
Session("DisName") = dtrDivisionList("DisName")
End If

and its now showing the top row or the datagrid.

Thanks!

Sila

 

[checkai]

If dtrDistrict.Read Then
   Session("DisName") = dtrDivisionList("DisName")
End If

could this section be calling the first record, then by the time you bind it, you're at the second record already?


"...we both know I'm training to become a cagefigher...see what happens if you try 'n hit me..."