About dynamic textboxes data capturing

chandra_yvr · March 29th, 2007, 09:29 AM

Hi,
I developed a code for dynamic insertion of textboxes on the webpage using vb.net.But i don't know how to insert the dynamic textboxes data into database .I am using placeholder for dynamic textboxes.
cmd.commandtext="insert into test values("what should i write here")

gbianchi · March 29th, 2007, 10:17 AM

hi there..

cmd.commandtext="insert into test values(" & yourtextboxname.text & "," & othertextboxname.text & ")

and so on... remember that in the insert command you have to surround text with ' and dates depending your database...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========

chandra_yvr · March 29th, 2007, 10:28 AM

Hi thanks for ur reply but my problem is not solved.
Because textboxes are inserted in webpage dynamically based on button click.So statically i am not placing textboxes.i am using placeholders for dynamic insertion of textboxes.

Quote:

quote:Originally posted by gbianchi
hi there..

cmd.commandtext="insert into test values(" & yourtextboxname.text & "," & othertextboxname.text & ")

and so on... remember that in the insert command you have to surround text with ' and dates depending your database...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========

gbianchi · March 29th, 2007, 10:38 AM

you are right.. my mistake..

you have to do a findcontrol on your page that returns every textbox and add that textbox (using a little modified code, but the same idea as before)...

findcontrol will take an id (witch you have to put on your textbox when you add it to the page) and will return and object if it can find it. Then ctype that object to the textbox and you are ready...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========

chandra_yvr · March 30th, 2007, 12:31 AM

Thank U sir,
But i am not getting clear idea.
this textbox takes only numerics

dim tb as textbox
tb=placeholder1.findcontrol("what abt id :")
what should i write in insert command
cmd.commandtext="insert into test values("tb.text")

Quote:

quote:Originally posted by gbianchi
you are right.. my mistake..

you have to do a findcontrol on your page that returns every textbox and add that textbox (using a little modified code, but the same idea as before)...

findcontrol will take an id (witch you have to put on your textbox when you add it to the page) and will return and object if it can find it. Then ctype that object to the textbox and you are ready...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========

gbianchi · March 30th, 2007, 09:58 AM

little example:

Code:

dim tb as textbox
tb=placeholder1.findcontrol([b]your textbox.id(in doble quotes)[b])
cmd.commandtext="insert into test values(" & tb.text & ")

now you see it??

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========