Empty row in Datagrid

I have a problem with Datagrid. I use a ADODC in combination with Datagrid, but when I activate the datagrid, I get a extra row (row 1) which is empty. How can I get rid of this extra useless (empty) row.

My code:

Const sSql = "SELECT * FROM xTable ORDER BY yField"

Adodc1.LockType = adLockOptimistic
Adodc1.CursorType = adOpenDynamic
Adodc1.RecordSource = App.Path & "\data\algemeen.mdb
Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & App.Path & "\data\Algemeen.mdb"

selecteer (sSql)


Function selecteer(ByVal sSql As String)
Adodc1.CommandType = adCmdText
Adodc1.RecordSource = sSql
Adodc1.Refresh
End Function

Please help me!
Thanks in advance.

If you are talking about the blank row at the end with the * in the left,
that is so that you can add new records. If you don't want to add new
records, then set the AllowAddNew property of the datagrid = False.

I think therefore I am... sometimes right. images/icons/wink.gif

It is not the blank row(*) at the end of the datagrid but a new blank row at the beginning of the datagrid.

Have you checked that the original DB table does not have this extra line. This would creep through because you are selecting everythin from the table.