Inserting Data from HTML form into Database : The Official Microsoft ASP.NET Forums

Reply

Inserting Data from HTML form into Database

Nov 13, 2012 08:56 PM|LINK

Hello All,

Till now I have learnt how to add, edit and delete data, But I am confused on how to add data from a 'Select' element into the database table and also from 'checkboxes'

For example: I have a Date Of Birth(DOB) column in my database, I need to add data from the HTML form select element to the DOB column of my database.
Below is my code for DOB.

<p>
<label>Date Of Birth</label>


<select name="DOB_Month">
<option value="-1">Month:</option>
<option value="1">Jan</option>
<option value="2">Feb</option>
<option value="3">Mar</option>
<option value="4">Apr</option>
<option value="5">May</option>
<option value="6">Jun</option>
<option value="7">Jul</option>
<option value="8">Aug</option>
<option value="9">Sep</option>
<option value="10">Oct</option>
<option value="11">Nov</option>
<option value="12">Dec</option>
</select>

<select name="DOB_Day">
<option value="-1">Day:</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>

<select name="DOB_Year">
<option value="-1">Year:</option>
<option value="2012">2012</option>
<option value="2011">2011</option>
<option value="2010">2010</option>
<option value="2009">2009</option>
<option value="2008">2008</option>
<option value="2007">2007</option>
<option value="2006">2006</option>
<option value="2005">2005</option>
<option value="2004">2004</option>
<option value="2003">2003</option>
<option value="2002">2002</option>
<option value="2001">2001</option>
<option value="2000">2000</option>
</select>

How do I accomplish this. I am able to get the data inserted from below select element, which is very simple.

<select name="gender">
<option value="">Select Gender</option> 
<option value="male">Male</option>
<option value="female">Female</option>
</select>

Question 2: How do I get the data from HTML form 'Checkbox' element .
For Example: There are multiple options like in the code below

<input type="checkbox">Drawing<br>
<input type="checkbox">Painting<br>
<input type="checkbox">Dancing<br>
<input type="checkbox">Movies<br>
<input type="checkbox">Music<br>

When user selects multiple check boxes, how do I add the multiple selection into database table.

I hope I have mentioned my questions clearly, I am very new to Web Programming and have just started learning from forums and W3School website.

Thank you.

Edited by aafi on Nov 13, 2012 08:58 PM
Edited by aafi on Nov 13, 2012 08:58 PM

Reply

Mikesdotnett...

All-Star

154929 Points

19869 Posts

Moderator

MVP

Re: Inserting Data from HTML form into Database

Nov 14, 2012 04:52 AM|LINK

You should spend a little time reviewing the tutorial here: http://www.asp.net/web-pages/tutorials/introducing-aspnet-web-pages-2/form-basics

Regards, Mike
Beginning ASP.NET Web Pages with WebMatrix | My Site | Twitter

Reply

Re: Inserting Data from HTML form into Database

Nov 14, 2012 08:13 AM|LINK

Whole of the select statement has a name. The options have just the values. You dont need to give them a name. Your select statement has a value selected from options. thats the value of that div or whatever it is inside.

In your INSERT INTO clause. just use the variable for the <select>

var Month_Date = Request.Form["DOB_Month"];

// Others here too.

In the INSERT INTO statement just use the variables.

For second answer you need to use the IN() clause for example you have a form with some checkboxes you need to name them same. And give them different values. Than while in SELECT statement. Use the variable for Request.Form for the checkbox input names. Then use IN() for them. This will give you the values. Now you can use the values in the INSERT INTO statement.

I guess you are having the WebMatrix try out your SQL statements in your Database workspace.

Please "Marks As Answer" if any answer helped you out!
~~! FIREWALL !~~

Edited by mbanavige on Dec 24, 2012 11:41 AM

Reply

Aafi

Member

32 Points

53 Posts

Re: Inserting Data from HTML form into Database

Nov 14, 2012 02:28 PM|LINK

Mikesdotnetting

You should spend a little time reviewing the tutorial here: http://www.asp.net/web-pages/tutorials/introducing-aspnet-web-pages-2/form-basics

Thanks Mike, I have already followed that tutorials and it helped me a lot.

I am able to add form data to my database.

What I am trying to do is concatenate " DOB_Day + DOB_Month + DOB_Year" into one string and then input that strng value into my database DOB column, but dont know how to do that.

Reply

Aafi

Member

32 Points

53 Posts

Re: Inserting Data from HTML form into Database

Nov 14, 2012 02:30 PM|LINK

Afzaal.Ahmad.Zeeshan

For second answer you need to use the IN() clause for example you have a form with some checkboxes you need to name them same. And give them different values. Than while in SELECT statement. Use the variable for Request.Form for the checkbox input names. Then use IN() for them. This will give you the values. Now you can use the values in the INSERT INTO statement.

I guess you are having the WebMatrix try out your SQL statements in your Database workspace.

Thanks Afzaal, That helped.

Reply

Aafi

Member

32 Points

53 Posts

Re: Inserting Data from HTML form into Database

Nov 14, 2012 03:09 PM|LINK

A little progress with concatenating strings, below is my code which works fine. Please correct if you see any problems with my code.

@{


    var firstname="";
    var lastname="";
    var hobbies="";
    var location="";
    var pnotes="";
    var musicgenre="";
    var dob_month="";
    var dob_day="";
    var dob_year="";
    var dob="";
    
    
    


 if(IsPost){
            firstname=Request["firstname"];
            lastname=Request["lastname"];
            hobbies=Request["hobbies"];
            location=Request["location"];
            pnotes=Request["pnotes"];
            musicgenre=Request["musicgenre"];
            dob_month=Request["dob_month"];
            dob_day=Request["dob_day"];
            dob_year=Request["dob_year"];
            dob=string.Concat(dob_month, "/", dob_day, "/", dob_year);
            

            var db=Database.Open("UserDetails");
            var insertcommand="INSERT INTO Details(firstname, lastname, hobbies, location, musicgenre, pnotes, dob) values (@0, @1, @2, @3, @4, @5, @6)";
            db.Execute(insertcommand, firstname, lastname, hobbies, location, musicgenre, pnotes, dob);
            Response.Redirect("~/users/Profileupdate");
 }
 }