HOW CHECK THAT FORM VALUE IS EXIST IN SQL DATABASE OR NOT VB.NET

Question

I want to check that in my database value is exist or not for example email is  i want register in my website it this email is already registerd then it shows i am using sql server 2005 and vbnet 2005

vinayak · Accepted Answer

use following code to call Store Procedure Dim strConnString As String  ConfigurationManagerConnectionStrings34conString34ConnectionStringDim con As New SqlConnectionstrConnStringDim cmd As New SqlCommandcmdCommandType  CommandTypeStoredProcedurecmdCommandText  34SPIsEmailExists34cmdParametersAdd34Email34 SqlDbTypeVarCharValue  txtEmailTextTrimcmdConnection  conTry    conOpen    Dim IsEmailExists As bool  cmdExecuteScalar    if IsEmailExists34true34 then    lblMessageText  34Email already exists34    end Catch ex As Exception    Throw exFinally      conClose    conDisposeEnd Try

HOW CHECK THAT FORM VALUE IS EXIST IN SQL DATABASE OR NOT VB.NET

Company

Explore

Follow us

Contact Us