Naters,

I've seen an error already, look at the code.

Why do you have a closing "End If" on the Sub Page_Load were you don't have an opening If? That should be End Sub

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

displayrecord()
End If


Post the the SQL error message that way it is easy to troubleshoot.

Dexter Zafra
http://www.myasp-net.com