Missing first record

28 Oct 2007 10:26 PM

EdwardH

Using asp.net and .net framework 2 and SQL server 2000
I am using simple SELECT statement in SP to retrieve data and then bind to a
datagrid but fail to pick up the first record in the dataset:

        invConn = New
SqlConnection(ConfigurationManager.ConnectionStrings("Connectstring").ConnectionString)
        invConn.Open()
        invComm = New SqlCommand(zStrg, invConn)
        invComm.CommandType = Data.CommandType.StoredProcedure
        invComm.Parameters.AddWithValue("@ClCode", strClCode)
        iP = invComm.ExecuteReader
        iP.Read()
        dgPInv.DataSource = iP
        dgPInv.DataBind()
        iP.Close()
        invConn.Close()

The SP is pulling back the full dataset but code above misses first rec.
with thanks

28 Oct 2007 10:49 PM

Norman Yuan

Remove

iP.Read()

before binding the DataReader to the grid; In the grid's DataBind() method,
a loop is made to call the DataReader's Read() method until DataReader's
end.

If you called Read() before DataBind(), of course the first row would be
missed, since DataReader is read only and forward only.

Show quote

"EdwardH" <Edwa***@discussions.microsoft.com> wrote in message
news:3E2EABDC-24E1-42F3-8DB1-FB0CCD685666@microsoft.com...
> Using asp.net and .net framework 2 and SQL server 2000
> I am using simple SELECT statement in SP to retrieve data and then bind to
> a
> datagrid but fail to pick up the first record in the dataset:
>
>        invConn = New
> SqlConnection(ConfigurationManager.ConnectionStrings("Connectstring").ConnectionString)
>        invConn.Open()
>        invComm = New SqlCommand(zStrg, invConn)
>        invComm.CommandType = Data.CommandType.StoredProcedure
>        invComm.Parameters.AddWithValue("@ClCode", strClCode)
>        iP = invComm.ExecuteReader
>        iP.Read()
>        dgPInv.DataSource = iP
>        dgPInv.DataBind()
>        iP.Close()
>        invConn.Close()
>
> The SP is pulling back the full dataset but code above misses first rec.
> with thanks
>