Below is the code for a form with several textboxes that I would like to use the values from to insert a record using a stored procedure. I am not having any sucess. After entering all the values and clicking the submit button no record gets entered. Any help would be greatly appreciated.


Thanks in advance


Gary




<%@ Page Language="VB" Debug="true" %>


<%@ import Namespace="System.Data" %>


<%@ import Namespace="System.Data.SqlClient" %>


<script runat="server">


    Sub Register_Click(ByVal sender As Object, ByVal e As ImageClickEventArgs)


    


    


        ' Only attempt a login if all form fields on the page are valid


        If Page.IsValid = True Then


                        


             Call AddCustomer()


    


                


        End If


    


    End Sub


    


    


      Function AddCustomer()


    


            ' Create Instance of Connection and Command Object


    


            Dim ConnectionString As String = "asdfsadf"


            Dim myConnection As New SqlConnection(ConnectionString)


            Dim myCommand As New SqlCommand("Cyclone_CustomerAdd", myConnection)


    


            ' Mark the Command as a SPROC


            myCommand.CommandType = CommandType.StoredProcedure


    


    


            ' Add Parameters to SPROC


            Dim parameterFullName As New SqlParameter("@FullName", SqlDbType.NVarChar, 50)


            parameterFullName.Value = fullname


            myCommand.Parameters.Add(parameterFullName)


    


            Dim parameterEmail As New SqlParameter("@Email", SqlDbType.NVarChar, 50)


            parameterEmail.Value = email


            myCommand.Parameters.Add(parameterEmail)


    


            Dim parameterPassword As New SqlParameter("@Password", SqlDbType.NVarChar, 50)


            parameterPassword.Value = password


            myCommand.Parameters.Add(parameterPassword)


    


    


            Dim parameterFirstName As New SqlParameter("@FirstName", SqlDbType.NVarChar, 50)


            parameterFirstName.Value = firstname


            myCommand.Parameters.Add(parameterFirstName)


    


            Dim parameterMiddleName As New SqlParameter("@MiddleName", SqlDbType.NVarChar, 50)


    


            If middlename is "" Then


            parameterMiddleName.Value = Convert.dbNull


            Else


            parameterMiddleName.Value = middleName


            myCommand.Parameters.Add(parameterMiddleName)


            End if


    


    


            Dim parameterLastName As New SqlParameter("@LastName", SqlDbType.NVarChar, 50)


            parameterLastName.Value = lastName


            myCommand.Parameters.Add(parameterLastName)


    


    


            Dim parameterCompanyName As New SqlParameter("@CompanyName", SqlDbType.NVarChar, 50)


    


            If companyname is "" Then


            parameterCompanyName.Value = Convert.dbNull


            Else


            parameterCompanyName.Value = companyname


            myCommand.Parameters.Add(parameterCompanyName)


            End if


    


            Dim parameterAddress1 As New SqlParameter("@Address1", SqlDbType.NVarChar, 75)


            parameterAddress1.Value = address1


            myCommand.Parameters.Add(parameterAddress1)


    


            Dim parameterAddress2 As New SqlParameter("@Address2", SqlDbType.NVarChar, 75)


    


            If address2 is "" Then


            parameterAddress2.Value = Convert.dbNull


            Else


            parameterAddress2.Value = address2


            myCommand.Parameters.Add(parameterAddress2)


            End if


    


            Dim parameterTown As New SqlParameter("@Town", SqlDbType.NVarChar, 75)


            parameterTown.Value = town


            myCommand.Parameters.Add(parameterTown)


    


            Dim parameterState As New SqlParameter("@State", SqlDbType.NVarChar, 50)


            parameterState.Value = state


            myCommand.Parameters.Add(parameterState)


    


            Dim parameterZip As New SqlParameter("@Zip", SqlDbType.NVarChar, 50)


            parameterZip.Value = zip


            myCommand.Parameters.Add(parameterZip)


    


            Dim parameterPhone As New SqlParameter("@Phone", SqlDbType.NVarChar, 14)


            parameterPhone.Value = phone


            myCommand.Parameters.Add(parameterPhone)


    


            Dim parameterCustomerID As New SqlParameter("@CustomerID", SqlDbType.Int, 4)


            parameterCustomerID.Direction = ParameterDirection.Output


            myCommand.Parameters.Add(parameterCustomerID)


    


            Try


                myConnection.Open()


                myCommand.ExecuteNonQuery()


                myConnection.Close()


    


                ' Calculate the CustomerID using Output Param from SPROC


                Dim customerId As Integer = CInt(parameterCustomerID.Value)


    


                Return customerId.ToString()


            Catch


                Return String.Empty


            End Try


    


        End Function


</script>


<html>


<head>


    <link href="../Style/Base.css" type="text/css" rel="stylesheet" />


</head>


<body bottommargin="0" leftmargin="0" topmargin="0" rightmargin="0" marginwidth="0" marginheight="0">


    <div align="center">


        <center>


            <form runat="server">


                <table width="739">


                    <tbody>


                        <tr>


                            <td>


                            </td>


                            <td colspan="2">


                                Car Wash Club</td>


                        </tr>


                        <tr>


                            <td>


                            </td>


                            <td>


                            </td>


                            <td>


                                <asp:Label id="MyError" runat="Server" enableviewstate="false" font-size="9pt" font-names="verdana" font-bold="True" font-underline="True"></asp:Label></td>


                        </tr>


                        <tr>


                            <td width="25" border="0">


                            </td>


                            <td>


                                <span><font size="2">Full Name:</font></span></td>


                            <td valign="top" height="2" border="0">


                                <asp:TextBox id="FullName" runat="server" size="25"></asp:TextBox>


                                <asp:RequiredFieldValidator id="RequiredFieldValidator1" runat="server" ErrorMessage="'Name' must not be left blank." Font-Size="9pt" Font-Name="verdana" Display="dynamic" ControlToValidate="FullName"></asp:RequiredFieldValidator>


                                <font size="2"></font></td>


                        </tr>


                        <tr>


                            <td>


                            </td>


                            <td>


                                <span><font size="2">Email:</font></span></td>


                            <td valign="top" height="2" border="0">


                                <asp:TextBox id="Email" runat="server" size="25"></asp:TextBox>


                                <asp:RegularExpressionValidator id="RegularExpressionValidator1" runat="server" ErrorMessage="Must use a valid email address." Font-Size="9pt" Font-Name="verdana" Display="Dynamic" ControlToValidate="Email" ValidationExpression="[\w\.-]+(\+[\w-]*)?@([\w-]+\.)+[\w-]+"></asp:RegularExpressionValidator>


                                <asp:RequiredFieldValidator id="RequiredFieldValidator2" runat="server" ErrorMessage="'Email' must not be left blank." Font-Size="9pt" Font-Name="verdana" Display="dynamic" ControlToValidate="Email"></asp:RequiredFieldValidator>


                                <font size="2"></font></td>


                        </tr>


                        <tr>


                            <td>


                            </td>


                            <td>


                                <span><font size="2">Password:</font></span></td>


                            <td height="2" border="0">


                                <asp:TextBox id="Password" runat="server" size="25" TextMode="Password"></asp:TextBox>


                                <asp:RequiredFieldValidator id="RequiredFieldValidator3" runat="server" ErrorMessage="'Password' must not be left blank." Font-Size="9pt" Font-Name="verdana" Display="dynamic" ControlToValidate="Password"></asp:RequiredFieldValidator>


                                <font size="2"></font></td>


                        </tr>


                        <tr>


                            <td>


                            </td>


                            <td>


                                <span><font size="2">Confirm Pwd:</font></span></td>


                            <td height="2" border="0">


                                <asp:TextBox id="ConfirmPassword" runat="server" size="25" TextMode="Password"></asp:TextBox>


                                <asp:RequiredFieldValidator id="RequiredFieldValidator4" runat="server" ErrorMessage="'Confirm' must not be left blank." Font-Size="9pt" Font-Name="verdana" Display="dynamic" ControlToValidate="ConfirmPassword"></asp:RequiredFieldValidator>


                                <asp:CompareValidator id="CompareValidator1" runat="server" ErrorMessage="Password fields do not match." Font-Size="9pt" Font-Name="verdana" Display="Dynamic" ControlToValidate="ConfirmPassword" ControlToCompare="Password"></asp:CompareValidator>


                                <font size="2"></font></td>


                        </tr>


                        <tr>


                            <td>


                            </td>


                            <td>


                                <span><font size="2">First Name:</font></span></td>


                            <td height="2" border="0">


                                <asp:TextBox id="FirstName" runat="server" size="25"></asp:TextBox>


                                <asp:RequiredFieldValidator id="RequiredFieldValidator6" runat="server" ErrorMessage="'First Name' must not be left blank." Font-Size="9pt" Font-Name="verdana" Display="dynamic" ControlToValidate="FirstName"></asp:RequiredFieldValidator>


                                <font size="2"></font></td>


                        </tr>


                        <tr>


                            <td>


                            </td>


                            <td>


                                <span><font size="2">Middle Name:</font></span></td>


                            <td height="2" border="0">


                                <asp:TextBox id="MiddleName" runat="server" size="25"></asp:TextBox>


                                <font size="2"></font></td>


                        </tr>


                        <tr>


                            <td>


                            </td>


                            <td>


                                <span><font size="2">Last Name:</font></span></td>


                            <td nowrap="nowrap" height="2" border="0">


                                <asp:TextBox id="LastName" runat="server" size="25"></asp:TextBox>


                                <asp:RequiredFieldValidator id="RequiredFieldValidator12" runat="server" ErrorMessage="'Last Name' must not be left blank." Font-Size="9pt" Font-Name="verdana" Display="dynamic" ControlToValidate="LastName"></asp:RequiredFieldValidator>


                                <font size="2"></font></td>


                        </tr>


                        <tr>


                            <td>


                            </td>


                            <td>


                                <span><font size="2">Company:</font></span></td>


                            <td height="2" border="0">


                                <asp:TextBox id="CompanyName" runat="server" size="25"></asp:TextBox>


                                <font size="2"></font></td>


                        </tr>


                        <tr>


                            <td>


                            </td>


                            <td>


                                <span><font size="2">Address1:</font></span></td>


                            <td height="2" border="0">


                                <asp:TextBox id="Address1" runat="server" size="25"></asp:TextBox>


                                <asp:RequiredFieldValidator id="RequiredFieldValidator5" runat="server" ErrorMessage="'Address' must not be left blank." Font-Size="9pt" Font-Name="verdana" Display="dynamic" ControlToValidate="Address1"></asp:RequiredFieldValidator>


                                <font size="2"></font></td>


                        </tr>


                        <tr>


                            <td>


                            </td>


                            <td>


                                <span><font size="2">Address2:</font></span></td>


                            <td height="2" border="0">


                                <asp:TextBox id="Address2" runat="server" size="25"></asp:TextBox>


                                <font size="2"></font></td>


                        </tr>


                        <tr>


                            <td>


                            </td>


                            <td>


                                <span><font size="2">Town/City:</font></span></td>


                            <td height="2" border="0">


                                <asp:TextBox id="Town" runat="server" size="25"></asp:TextBox>


                                <asp:RequiredFieldValidator id="RequiredFieldValidator7" runat="server" ErrorMessage="'Town/City' must not be left blank." Font-Size="9pt" Font-Name="verdana" Display="dynamic" ControlToValidate="Town"></asp:RequiredFieldValidator>


                                <font size="2"></font></td>


                        </tr>


                        <tr>


                            <td>


                            </td>


                            <td>


                                <span><font size="2">State:</font></span></td>


                            <td height="2" border="0">


                                <asp:TextBox id="State" runat="server" size="25"></asp:TextBox>


                                <asp:RequiredFieldValidator id="RequiredFieldValidator8" runat="server" ErrorMessage="'State' must not be left blank." Font-Size="9pt" Font-Name="verdana" Display="dynamic" ControlToValidate="State"></asp:RequiredFieldValidator>


                                <font size="2"></font></td>


                        </tr>


                        <tr>


                            <td>


                            </td>


                            <td>


                                <span><font size="2">Zip:</font></span></td>


                            <td height="2" border="0">


                                <asp:TextBox id="Zip" runat="server" size="25"></asp:TextBox>


                                <asp:RequiredFieldValidator id="RequiredFieldValidator9" runat="server" ErrorMessage="'Zip' must not be left blank." Font-Size="9pt" Font-Name="verdana" Display="dynamic" ControlToValidate="Zip"></asp:RequiredFieldValidator>


                                <asp:RegularExpressionValidator id="ZipCodeValidator" runat="server" ErrorMessage="Zip Code Not Entered Correctly" Font-Size="9pt" ControlToValidate="Zip" ValidationExpression="\d{5}(-\d{4})?" Font-Names="verdana"></asp:RegularExpressionValidator>


                                <font size="2"></font></td>


                        </tr>


                        <tr>


                            <td>


                            </td>


                            <td>


                                <span><font size="2">Phone:</font></span></td>


                            <td height="2" border="0">


                                <asp:TextBox id="Phone" runat="server" size="25"></asp:TextBox>


                                <asp:RequiredFieldValidator id="RequiredFieldValidator10" runat="server" ErrorMessage="'Phone' must not be left blank." Font-Size="9pt" Font-Name="verdana" Display="dynamic" ControlToValidate="Phone"></asp:RequiredFieldValidator>


                                <asp:RegularExpressionValidator id="PhoneValidation" runat="server" ErrorMessage="Please Enter the Phone in the Correct Format" Font-Size="9pt" ControlToValidate="Phone" ValidationExpression="((\(\d{3}\) ?)|(\d{3}-))?\d{3}-\d{4}" Font-Names="verdana"></asp:RegularExpressionValidator>


                                <font size="2"></font></td>


                        </tr>


                        <tr>


                            <td>


                            </td>


                            <td valign="top">


                                <font size="2"></font></td>


                            <td valign="top" height="2" border="0">


                                <asp:ImageButton id="RegisterBtn" onclick="Register_Click" runat="server" ImageUrl="../../images/submit.gif" BorderColor="Black" BorderStyle="Solid" BorderWidth="1px"></asp:ImageButton>


                                <font size="2"></font></td>


                        </tr>


                        <tr valign="top">


                            <td>


                            </td>


                            <td>


                                <font size="2"></font></td>


                            <td width="550">


                                <font size="2"></font></td>


                        </tr>


                    </tbody>


                </table>


            </form>


        </center>


    </div>


</body>


</html>

heres some sample code to call a stored proc and pass parameters and obtain an output parameter..see if you can tweak this code for your app




Dim myCommand As SqlCommand


Dim myParam  As SqlParameter


myCommand = New SqlCommand()


myCommand.Connection = objcon


myCommand.CommandText = "TestProc"


myCommand.CommandType = CommandType.StoredProcedure


'input parameter


myCommand.Parameters.Add(New SqlParameter("@userid",SqlDbType.int))


myCommand.Parameters("@userid").Value = Trim(userid)


'output parameter


myParam = mycommand.CreateParameter()


myParam.ParameterName = "@result"


myParam.Direction = ParameterDirection.Output


myParam.SqlDbType = SqlDbType.bigint


mycommand.Parameters.Add(myParam)


If objCon.State = 0 Then objCon.Open()


mycommand.ExecuteNonQuery()


return convert.todouble((mycommand.Parameters("@result").Value))


objcon.close





hth
***********************
Dinakar Nethi
Life is short. Enjoy it.
***********************

Thanks for the reply, but I have a question on the placement of the connection string?


Gary

Hi Gary,


The most commonly way to store the connection string is the "Web.Config" file.


FYI: http://www.dotnetbips.com/displayarticle.aspx?id=104


Colt

Colt,


The form that I am working with is not part of a application, It is just one .net page in basically a front page site that I was trying to intergrate. so I am under the impression that a web config file not going to help me here, or is it? 


Thanks


Gary

I tried to go with a insert statement, so I used the wizard and to create one and get a error. "Compiler Error Message: BC30455: Argument not specified for parameter 'addressOne' of 'Public Function MyInsertMethod(fullName As String, emailAddress As String, password As String, firstName As String, middleName As String, lastName As String, companyName As String, addressOne As String, addressTwo As String, town As String, state As String, zip As String, phone As String) As Integer'."


I noticed that I have gotten this error before using the code that I posted with a stored proceedure. I checked that table and stored procedure and do not see any thing wrong with it. In fact I took this entire code and and stored procedure from a working form I did once before, that is what is driving me a bit nutty..


Thanks again for your effort.


Gary

do a response.write of each of your parameters to see what values they hold before you pass them on to the stored proc..


hth
***********************
Dinakar Nethi
Life is short. Enjoy it.
***********************

I placed a response.write (fullname) in the function above all parameters and enter some values in the form to get the following "System.Web.UI.WebControls.TextBox" am I missing this statement at the top of the code?


Thanks 


Gary

fullname is the Id of the textbox. if you want to access the value in it you shoould use fullname.text. do the same for all the textboxes...


hth
***********************
Dinakar Nethi
Life is short. Enjoy it.
***********************

Thanks that did the trick, still do not understand why some times it seem unneeded to do that. but thanks again.


Gary

BTW - 


Storing your connection string in your web.config file has nothing to do with whether or not you have a full blown application or just one page - you store it there, then you can access and use it from any page that has access to that web.config.
David Wier
MCP/ASPInsider
ASPNet101.com - where to look first!
Control Grouper - easily control properties for multiple controls with one control!
Calendar Express - The Best HTML Calendar Generator on the web!
(Please 'Mark as Answer' when it applies)

As long as the weg.config file is located in a directory that is set up as an IIS application, it will be parsed, regardless of whether or not the entire site is built on .NET.


AutoFed