how to insert value to sql db from dynamically generated textboxes asp.net -

first of im new visual studio , asp.net c# , on...

i'm creating simple rental application bicycles , got stuck.

i made formula adding order 1 bike , made insert @ submit buttonclick without problem.

now problem.. possible same customer rent more bikes @ same time , instead of filling out formula again every new bike want able add more bikes same formula (1 bike = serial number)

to found solution on web took away serial number field , made field user fills in amount of bikes customer wants rent , button next field. when user writes example 3 in amount field , presses button automatically pop ups 3 textboxes input of every bikes serial number.

now need solution inserting value of textboxes serial numbers..

after pressing button makes insert sql db have make loop count how many inserts have make , print in different values of serial numbers each order.

example:   1 customer 3 bikes  bike 1 = serial number 123 bike 2 = serial number 234 bike 3 = serial number 345  

now have make 3 insert 3 different serial numbers after clicking send order button.

am on right track?

protected void btngeneratecontrol_click(object sender, eventargs e)     {            int count = convert.toint32(qty.text);         for(int =1; <= count; i++)         {             textbox txtbox = new textbox();             txtbox.text = "textbox - " + i.tostring();             pnltextboxes.controls.add(txtbox);         }     }      protected void btnaddorder_click(object sender, eventargs e)     {         int count = convert.toint32(qty.text);         (int = 1; <= count; i++)         {             string query = "insert orders (custid, orderdate, time, productid, projectid, status, flottenid)values('" + custid.text + "','" + orderdate.text + "','" + time.text + "','" + productid.value + "','" + projectid.value + "','" + status.value +"','" +here need catch value of serial number+ "')";             string query1 = "commit;";             datalayer.dataconnector dat = new datalayer.dataconnector("provider=sqloledb; data source=****;database=event;user id=****;password=*****; persist security info=false");             dat.datainsert(query);             dat.datainsert(query1);         }      } 

write below code in btngeneratecontrol_click1 event(below loop)

 pnltextboxes.controls.add(new literalcontrol("<input id='txt' name='textbox" + + "'type='text'  />"));         pnltextboxes.controls.add(new literalcontrol("<br />")); 

and write below code in btnaddorder_click1 event(below loop)

string query = "insert orders (custid, orderdate, time, productid, projectid, status, flottenid)values('" + custid.text + "','" + orderdate.text + "','" + time.text + "','" + productid.value + "','" + projectid.value + "','" + status.value + "','" + request.form["textbox" + i.tostring()] + "')";         mysqlcommand cmd = new mysqlcommand(query,con);         cmd.executenonquery();