sql - retrieve dynamic ID of textbox in asp.net -


i have control creates textboxes dynamically.

for each of these textboxes want make insert sql database.

for example have 3 textboxes id flottenid1, flottenid2, flottenid3.

every textbox has default of flottenid , comes number 1,2,3,4,5 depending on how many have.

now need how can in insert loop should start inserting flottenid1 , next time flottenid2 , on...

my other id's have same name there no problem. there can write cust.text example. hope understand i'm searching for. thanks!

protected void btngeneratecontrol_click(object sender, eventargs e) {         int count = convert.toint32(qty.text);          for(int =1; <= count; i++)         {             label lbl = new label();             textbox txtbox = new textbox();             lbl.text = " flotten id velo nr" + (i).tostring() + " ";             //txtbox.text = "textbox - " + i.tostring();             txtbox.id = "flottenid" + i.tostring();             txtbox.enableviewstate = true;             pnltextboxes.controls.add(lbl);             pnltextboxes.controls.add(txtbox);             pnltextboxes.controls.add(new literalcontrol("<br /><br />"));         }     }  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 + "','" + " flottenid " + "')";             string query1 = "commit;";             datalayer.dataconnector dat = new datalayer.dataconnector("provider=sqloledb; data source=****;database=***;user id=event;password=****; persist security info=false");             dat.datainsert(query);             dat.datainsert(query1);       } }

i think asked same question gave solution that.anyway give code now..

write below code in btngeneratecontrol_click1 event(below loop)

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

this generates textbox ids (flottenid1,flottenid2,..........based on loop)


Comments

Post a Comment

Popular posts from this blog

matlab - Deleting rows with specific rules -

i got 20*3 cell array , need delete rows contains "137", "2" , "n:t" origin data: 't' '' '' 'np(*)' '' '' [ 137] '' '' [ 2] '' '' 'are' 'and' 'np(fcc_a1#1)' '' '' '1:t' [ 1200] [0.7052] '' [1.2051e+03] [0.7076] '' 'are' 'and' 'np(fcc_a1#3)' '' '' '2:t' [ 1200] [0.0673] '' [1.2051e+03] [0.0671] '' 'are' 'and' 'np(m23c6)' '' '' '3:t' [ 1200] [0.227...
Read more

php - MySQLi multi_query results for later use -

i using mysqli multi_query work several select statemets @ time. know how handle results, able use them later in code. example: <?php //connection stuff $query = "select name, surname database1;"; $query.= "select car, year, type database2 carid='1';"; $query.= "select product, price database3;"; if ($mysqli->multi_query($query)) { if($result = $mysqli->store_result()) { while($row = $result->fetch_row()) { --> here? } } } ?> <html> <div id='persona'> <?php foreach() { --> print name + surname } ?> </div> <div id='cars'> <?php foreach() { --> print car + year + type } ?> </div> <div id='product'> <?php foreach() { --> print product + price } ?> </div> </html> one more thing, prepared statements not possible when using multiple_query, right? there no benefit in putting unrelated queries in 1 multi ...
Read more