Updating SQL database from table lay out panel's auto added rows

manabata

New member
Joined
Nov 20, 2012
Messages
2
Programming Experience
Beginner
On a windows form I've added a table layout panel (TableLayoutPanel1). On its 1st row i've added two text boxes and these text boxes are added into next rows of TableLayoutPanel1 automatically on button click. In runtime i've added 4 rows, now i want to update data from those text boxes into sql database by another button click. I'm using visual basic (visual studio 2010) and Sql Srver 2008.
 
That's not really a good idea. You really should be using either a DataGridView or a DataRepeater. It sounds like you want a table of data so a DataGridView would probably be the most appropriate option. In that case you can simply bind a DataTable to it. Any changes you make to the grid are automatically pushed to the table, so it's ready to be saved with a single Update call to a data adapter.
 
Hi

I've attached part of my project for your review. (WA.Zip)
when 1st left combobox of 1st row of qualification will be set to PhD, the rest of the comboboxes and text box data will be updated to PhD table of my Database
When 2nd Left combobox of 2nd row row of qualification will be set to MPhill, the rest of the comboboxes and text box will be upfated to MPhill Table of my Database
and so on.

And one more button I want to add at the bottom which will remove the last added row of qualification
 

Attachments

Last edited by a moderator:
Back
Top