First time using Parameters.
Connection String correct.
SQL Table fields match with parameter.
Field datatype and length match
Sql Table permissions are all there.

I got this code from a few books but I can't get it to display "Success" only "Failed".
What is my problem???



Private Sub btnGo_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGo.Click
        Dim myCONN As SqlConnection = New SqlConnection(ConfigurationSettings.AppSettings("C onnectionString"))



Dim sSql As String = "INSERT INTO Member (FName, LName) VALUES (@FName, @LName)"

        Dim insertCmd As New SqlCommand(sSql, myCONN)
        insertCmd.Parameters.Add("@FName", SqlDbType.NVarChar, 50)
        insertCmd.Parameters.Add("@LName", SqlDbType.NVarChar, 50)

        insertCmd.Parameters("@FName").Value = txtFName.Text
        insertCmd.Parameters("@LName").Value = TxtLName.Text


        Dim bSuccess As Boolean
        bSuccess = True

        Try
            myCONN.Open()
            insertCmd.ExecuteScalar()
            myCONN.Close()

        Catch ex As Exception
            bSuccess = False
            Response.Write("Failed")
        Finally
            If myCONN.State = ConnectionState.Open Then
                myCONN.Close()
            End If
        End Try

        If bSuccess = True Then
            Response.Write("Sucess")
        End If



    End Sub

Hey,

Are you sure you are establishing a connection? In addition, in the catch block, add:

Response.Write(ex.ToString())

And post that to this thread.

Brian

I added:
insertCmd.CommandType = CommandType.Text
        insertCmd.Connection = myCONN

And it works.
Thanks.

Hey,

That's weird... the default is Text, so you shouldn't have to define it. And you pass in a connection... but if it works it works.

Glad to hear it.

Brian