hi every one...!

em creating a create user account page.

i want to check the username is already exists in my database table or not?

if exists then give me a error message that username is already exists if not then account will be successfully create.

em using this code but its not work correctly..

i dont know whatz de problem. and please remember em using Access database.

please point out my mistakes.





<script language="VB" runat="server">
Dim objConnection As OleDbConnection
Sub Page_Load(Source As Object, E As EventArgs)
objConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; " _
& "DATA SOURCE=" _
& Server.MapPath("nwind.mdb;"))
End Sub




Sub btnInsert_Click(ByVal Sender As Object, ByVal E As EventArgs)

Dim query As String
query = "Select Count(*) From login Where username = ? "
Dim result As Integer = 0

If result > 0 Then



Dim strSQL As String = "INSERT INTO login (username, [password]) " & _
"VALUES (?, ?) "


Dim dbComm As New OleDbCommand(strSQL, objConnection)
dbComm.Parameters.Add("UserName", OleDbType.VarChar, 32, "UserName")
dbComm.Parameters.Add("Password", OleDbType.VarChar, 128, "Password")

dbComm.Parameters("UserName").Value = txtUserName.Text
dbComm.Parameters("Password").Value = txtPassword.Text

Try
objConnection.Open()
dbComm.ExecuteNonQuery()
Catch ex As Exception
Response.Write(ex.Message)
Response.End()
Finally
If objConnection.State = ConnectionState.Open Then
objConnection.Close()
End If
End Try

Response.Write("A new record has been added")
Response.End()


Else
Response.Write("your username is already exist")
End If


End Sub

</script>