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. 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