Inserting Information Into An SQL Database Using Stored Procedures

Hello,

I'm building an ecommerce website which requires customers to create an account before they go ahead with a purchase. I have a createaccount.aspx page in Visual Web Developer 2005 with text boxes where users can enter their details (email, password, name and address).  I'm trying to insert the information which users type into the text boxes into an SQL database table called Customers.

I've dragged and dropped an SQL data source onto my page and have set it to operate on my AddCustomer stored procedure. I've confirgured my data source such that the parameter for each field in the database is set to the appropriate control on the webpage (for example the Email parameter source is "textboxEmail").

I've also placed a button onto my page so that the button click event can act as the trigger for sending the information in the text boxes to the database. I wasn't totally sure how to write code for the button click event such that when the button is clicked, the INSERT stored procedure runs. At the moment I'm using:

Protected Sub btnSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSubmit.Click

SqlDataSource1.Insert()

End Sub

When I try to run my application I'm getting an error which reads:

Cannot insert the value NULL into column 'Email', table 'C:DOCUMENTS AND SETTINGSLUKE JACKSONMY DOCUMENTSVISUAL STUDIO 2005WEBSITESJACKSONSNURSERIESAPP_DATADATABASE.MDF.dbo.Customers'; column does not allow nulls. INSERT fails.
The statement has been terminated.

The error message implies that I haven't set the necessary parameters correctly but I really don't know where I'm going wrong!

The code I'm using for my stored procedure is as follows:

ALTER PROCEDURE AddCustomer

(

@CustomerID int,

@Email nvarchar(50),

@Password nvarchar(MAX),

@Name nvarchar(50),

@Address1 nvarchar(50),

@Address2 nvarchar(50),

@Address3 nvarchar(50),

@City nvarchar(50),

@County nvarchar(50),

@PostCode nvarchar(50)

)

AS

INSERT INTO Customers

(Email, Password, Name, Address1, Address2, Address3, City, County, PostCode)

VALUES

(@Email, @Password, @Name, @Address1, @Address2, @Address3, @City, @County, @PostCode)

I'd be really grateful if anyone could help me out with this.

Thanks in advance,

Luke

p.s. just incase it helps, here's my createaccount.aspx page:

<%@ Page Language="VB" MasterPageFile="~/Master.master" AutoEventWireup="false" CodeFile="createaccount.aspx.vb" Inherits="createaccount" title="Untitled Page" %>

<%-- Add content controls here --%>

<asp:Content ID="Content1" runat="server" ContentPlaceHolderID="ContentPlaceHolder1">

<span style="text-decoration: underline"><strong>Create Account<br />

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="AddCustomer" SelectCommandType="StoredProcedure" InsertCommand="INSERT INTO Customers&#13;&#10;&#9;(Email, Password, Name, Address1, Address2, Address3, City, County, PostCode)&#13;&#10;&#9;VALUES&#13;&#10;&#9;(@Email, @Password, @Name, @Address1, @Address2, @Address3, @City, @County, @PostCode)">

<SelectParameters>

<asp:Parameter Name="CustomerID" Type="Int32" />

<asp:ControlParameter ControlID="textboxEmail" Name="Email" PropertyName="Text" Type="String" />

<asp:ControlParameter ControlID="textboxPassword" Name="Password" PropertyName="Text"

Type="String" />

<asp:ControlParameter ControlID="textboxName" Name="Name" PropertyName="Text" Type="String" />

<asp:ControlParameter ControlID="textboxAddress" Name="Address1" PropertyName="Text"

Type="String" />

<asp:ControlParameter ControlID="textboxAddress2" Name="Address2" PropertyName="Text"

Type="String" />

<asp:ControlParameter ControlID="textboxAddress3" Name="Address3" PropertyName="Text"

Type="String" />

<asp:ControlParameter ControlID="textboxCity" Name="City" PropertyName="Text" Type="String" />

<asp:ControlParameter ControlID="textboxCounty" Name="County" PropertyName="Text"

Type="String" />

<asp:ControlParameter ControlID="textboxPostCode" Name="PostCode" PropertyName="Text"

Type="String" />

</SelectParameters>

<InsertParameters>

<asp:Parameter Name="Email" Type="String" />

<asp:Parameter Name="Password" Type="String" />

<asp:Parameter Name="Name" Type="String" />

<asp:Parameter Name="Address1" Type="String" />

<asp:Parameter Name="Address2" Type="String" />

<asp:Parameter Name="Address3" Type="String" />

<asp:Parameter Name="City" Type="String" />

<asp:Parameter Name="County" Type="String" />

<asp:Parameter Name="PostCode" Type="String" />

</InsertParameters>

</asp:SqlDataSource>

<br />

</strong></span>

<table style="font-weight: bold; width: 394px; text-decoration: underline">

<tr>

<td style="width: 111px; height: 21px; text-align: left">

Email:</td>

<td style="height: 21px">

<asp:TextBox ID="textboxEmail" runat="server" Width="147px"></asp:TextBox></td>

</tr>

<tr>

<td style="width: 111px; height: 21px; text-align: left">

Password:</td>

<td style="height: 21px">

<asp:TextBox ID="textboxPassword" runat="server"></asp:TextBox></td>

</tr>

<tr>

<td style="width: 111px; height: 21px; text-align: left">

Name:</td>

<td style="height: 21px">

<asp:TextBox ID="textboxName" runat="server"></asp:TextBox></td>

</tr>

<tr>

<td style="width: 111px; text-align: left">

Address 1:</td>

<td>

<asp:TextBox ID="textboxAddress" runat="server"></asp:TextBox></td>

</tr>

<tr>

<td style="width: 111px; height: 21px; text-align: left">

Address 2:</td>

<td style="height: 21px">

<asp:TextBox ID="textboxAddress2" runat="server"></asp:TextBox></td>

</tr>

<tr>

<td style="width: 111px; text-align: left">

Address 3:</td>

<td>

<asp:TextBox ID="textboxAddress3" runat="server"></asp:TextBox></td>

</tr>

<tr>

<td style="width: 111px; text-align: left">

City:</td>

<td>

<asp:TextBox ID="textboxCity" runat="server"></asp:TextBox></td>

</tr>

<tr>

<td style="width: 111px; height: 21px; text-align: left">

County:</td>

<td style="height: 21px">

<asp:TextBox ID="textboxCounty" runat="server"></asp:TextBox></td>

</tr>

<tr>

<td style="width: 111px; text-align: left">

Post Code:</td>

<td>

<asp:TextBox ID="textboxPostCode" runat="server"></asp:TextBox></td>

</tr>

</table>

<asp:Button ID="btnSubmit" runat="server" Text="Submit" />

</asp:Content>

Thanks again