DotNetNewsgroup.com  
web access to complete list of Microsoft.NET newsgroups
   home   |   control panel login   |   archive  |  
 
  carried group
academic
adonet
aspnet
aspnet.announcements
aspnet.buildingcontrols
aspnet.caching
aspnet.datagridcontrol
aspnet.mobile
aspnet.security
aspnet.webcontrols
aspnet.webservices
assignment_manager
datatools
dotnet.distributed_apps
dotnet.general
dotnet.myservices
dotnet.nternationalization
dotnet.scripting
dotnet.security
dotnet.vjsharp
dotnet.vsa
dotnet.xml
dotnetfaqs
framework
framework.clr
framework.compactframework
framework.component_services
framework.controls
framework.databinding
framework.drawing
framework.enhancements
framework.interop
framework.odbcnet
framework.performance
framework.remoting
framework.sdk
framework.setup
framework.webservices
framework.windowsforms
framework.wmi
frwk.windowsforms.designtime
lang.csharp
lang.jscript
lang.vb
lang.vb.controls
lang.vb.data
lang.vb.upgrade
lang.vc
lang.vc.libraries
  
 
start date: Tue, 17 Jul 2007 17:01:23 -0400,    posted on: microsoft.public.dotnet.framework.adonet        back       

Thread Index
  1    Jack


Check user input data exist in database: ERROR   
Dim retVal As Boolean = False
        Dim cnSQL As SqlConnection
        Dim cmSQL As SqlCommand
        Dim strSQL As String

        strSQL = "Select * From Table_Contacts where EmailAddress = '" & 
txtEmail.Text & "' OR Name = '" & txtName.Text & "';"
        cnSQL = New SqlConnection(thisConnection)
        cnSQL.Open()

        cmSQL = New SqlCommand(strSQL, cnSQL)
        Dim reader As SqlDataReader = cmSQL.ExecuteReader()

        If Not reader.HasRows Then
            retVal = False
            MessageBox.Show("No Record")
        Else
            MessageBox.Show(" already exists!", " ", MessageBoxButtons.OK, 
MessageBoxIcon.Error)
            retVal = True
        End If

        cnSQL.Close()
        cmSQL.Dispose()
        cnSQL.Dispose()
        retVal = True


Can someone help me with this?
I'm keep getting "already exist" even there is no matching record in the 
database.

- Thanks
Date:Tue, 17 Jul 2007 17:01:23 -0400   Author:  

Google
 
Web dotnetnewsgroup.com


COPYRIGHT ?2005, EUROFRONT WORLDWIDE LTD., ALL RIGHT RESERVE  |   Contact us