Can someone please help me create a stored procedure to insert a new customer from a web form.
I am having difficulty making the state a drop down list for customer to pick a state from the list and having that inserted into the database.
INSERT INTO Customer
(
Cust_First,
Cust_Middle,
Cust_Last,
Cust_Phone,
Cust_Alt_Phone,
Cust_Email,
Add_Line1,
Add_Line2,
Add_Bill_Line1,
Add_Bill_Line2,
City,
State_Prov_Name,
Postal_Zip_Code,
Country_ID
)
VALUES
(
@Cust_First,
@Cust_Middle,
@Cust_Last,
@Cust_Phone,
@Cust_Alt_Phone,
@Cust_Email,
@Add_Line1,
@Add_Line2,
@Add_Bill_Line1,
@Add_Bill_Line2,
@City,
@State_Prov_Name,
@Postal_Zip_Code,
@Country_ID
)">
<InsertParameters>
<asp:Parameter Name="Cust_First" Type="String"></asp:Parameter>
<asp:Parameter Name="Cust_Middle" Type="String"></asp:Parameter>
<asp:Parameter Name="Cust_Last" Type="String"></asp:Parameter>
<asp:Parameter Name="Cust_Phone" Type="String"></asp:Parameter>
<asp:Parameter Name="Cust_Alt_Phone" Type="String"></asp:Parameter>
<asp:Parameter Name="Cust_Email" Type="String"></asp:Parameter>
<asp:Parameter Name="Add_Line1" Type="String"></asp:Parameter>
<asp:Parameter Name="Add_Line2" Type="String"></asp:Parameter>
<asp:Parameter Name="Add_Bill_Line1" Type="String"></asp:Parameter>
<asp:Parameter Name="Add_Bill_Line2" Type="String"></asp:Parameter>
<asp:Parameter Name="City" Type="String"></asp:Parameter>
<asp:Parameter Name="Postal_Zip_Code" Type="String"></asp:Parameter>
<asp:Parameter Name="Cust_ID" Type="Int32"></asp:Parameter>
<asp:Parameter Name="State_Prov_Name" Type="String"></asp:Parameter>
<asp:Parameter Name="Country_Name" Type="String"></asp:Parameter>
</InsertParameters>