title: Insert Stored Procedure, Using Asp.Net WebForm to Insert new [Customer]
body: <p>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. </p>
  
  <pre><code>                    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
                      )"&gt;
  
  
          &lt;InsertParameters&gt;
              &lt;asp:Parameter Name="Cust_First" Type="String"&gt;&lt;/asp:Parameter&gt;
              &lt;asp:Parameter Name="Cust_Middle" Type="String"&gt;&lt;/asp:Parameter&gt;
              &lt;asp:Parameter Name="Cust_Last" Type="String"&gt;&lt;/asp:Parameter&gt;
              &lt;asp:Parameter Name="Cust_Phone" Type="String"&gt;&lt;/asp:Parameter&gt;
              &lt;asp:Parameter Name="Cust_Alt_Phone" Type="String"&gt;&lt;/asp:Parameter&gt;
              &lt;asp:Parameter Name="Cust_Email" Type="String"&gt;&lt;/asp:Parameter&gt;
              &lt;asp:Parameter Name="Add_Line1" Type="String"&gt;&lt;/asp:Parameter&gt;
              &lt;asp:Parameter Name="Add_Line2" Type="String"&gt;&lt;/asp:Parameter&gt;
              &lt;asp:Parameter Name="Add_Bill_Line1" Type="String"&gt;&lt;/asp:Parameter&gt;
              &lt;asp:Parameter Name="Add_Bill_Line2" Type="String"&gt;&lt;/asp:Parameter&gt;
              &lt;asp:Parameter Name="City" Type="String"&gt;&lt;/asp:Parameter&gt;
              &lt;asp:Parameter Name="Postal_Zip_Code" Type="String"&gt;&lt;/asp:Parameter&gt;
              &lt;asp:Parameter Name="Cust_ID" Type="Int32"&gt;&lt;/asp:Parameter&gt;
              &lt;asp:Parameter Name="State_Prov_Name" Type="String"&gt;&lt;/asp:Parameter&gt;
              &lt;asp:Parameter Name="Country_Name" Type="String"&gt;&lt;/asp:Parameter&gt;
          &lt;/InsertParameters&gt;
  </code></pre>