H
hfk0
Hi,
I'm using the following parameters in my web form:
cmdTest.Parameters.Add(New SqlParameter("@FirstN",
SqlDbType.NVarChar, 25))
cmdTest.Parameters.Add(New SqlParameter("@LastN",
SqlDbType.NVarChar, 25))
cmdTest.Parameters.Add(New SqlParameter("@Org",
SqlDbType.NVarChar, 50))
cmdTest.Parameters.Add(New SqlParameter("@Addr1",
SqlDbType.NVarChar, 50))
cmdTest.Parameters.Add(New SqlParameter("@City",
SqlDbType.NVarChar, 50))
cmdTest.Parameters.Add(New SqlParameter("@Email",
SqlDbType.NVarChar, 50))
cmdTest.Parameters("@FirstN").Value = "FirstN"
cmdTest.Parameters("@LastN").Value = "LastN"
cmdTest.Parameters("@Org").Value = "Org"
cmdTest.Parameters("@Addr1").Value = "Addr1"
cmdTest.Parameters("@City").Value = "City"
cmdTest.Parameters("@Email").Value = "Email"
When I submit the form, somehow it didn't insert the info. I'm only
seeing "FirstN" "LastN" "Org" "Addr1" "City" and "Email" in the
corresponding columns in the database.
Could anyone help me with this? Am I using the right code?
Thanks,
hfk0
I'm using the following parameters in my web form:
cmdTest.Parameters.Add(New SqlParameter("@FirstN",
SqlDbType.NVarChar, 25))
cmdTest.Parameters.Add(New SqlParameter("@LastN",
SqlDbType.NVarChar, 25))
cmdTest.Parameters.Add(New SqlParameter("@Org",
SqlDbType.NVarChar, 50))
cmdTest.Parameters.Add(New SqlParameter("@Addr1",
SqlDbType.NVarChar, 50))
cmdTest.Parameters.Add(New SqlParameter("@City",
SqlDbType.NVarChar, 50))
cmdTest.Parameters.Add(New SqlParameter("@Email",
SqlDbType.NVarChar, 50))
cmdTest.Parameters("@FirstN").Value = "FirstN"
cmdTest.Parameters("@LastN").Value = "LastN"
cmdTest.Parameters("@Org").Value = "Org"
cmdTest.Parameters("@Addr1").Value = "Addr1"
cmdTest.Parameters("@City").Value = "City"
cmdTest.Parameters("@Email").Value = "Email"
When I submit the form, somehow it didn't insert the info. I'm only
seeing "FirstN" "LastN" "Org" "Addr1" "City" and "Email" in the
corresponding columns in the database.
Could anyone help me with this? Am I using the right code?
Thanks,
hfk0