New WinForm form with lots of bound controls

Ace1000

Member
Joined
Aug 29, 2015
Messages
8
Programming Experience
1-3
I am new to WinForms.
I have a lot of experience with MS Access forms.
I have Visual Studio Express Community 2015 and a database with tables (with data).


Let's say I have a form called Form1 and a table called Table1.
Let's say Table 1 has 30 fields and 100 rows of data.


**What I want to do:**
--------------------------------------
1. In Form1, I want to show 30 textboxes that are bound to the 30 fields in Table1.


2. When I open the form it should show all the data in the 1st record (or row) of Table1.


3. I should be able to change the values in the textbox and automatically update the underlying values in Table1.


------------------------------------
In MS Access I can do this in less than 1 minute.
I am sure there is a way to do this quickly in Visual Studio (Windows Form) also.


In Visual Studio Express 2015 I am adding one control (textbox) at a time and changing the DataBindings in the Properties window.


Any suggestion will be appreciated.
 

IanRyder

Well-known member
Joined
Sep 9, 2012
Messages
1,130
Location
Healing, NE Lincs, UK
Programming Experience
10+

Ace1000

Member
Joined
Aug 29, 2015
Messages
8
Programming Experience
1-3
Thanks Ian.

That definitely helps a little.
Too bad, I cannot drag and drop multiple fields at from the Datasource to the form in one go.
 

IanRyder

Well-known member
Joined
Sep 9, 2012
Messages
1,130
Location
Healing, NE Lincs, UK
Programming Experience
10+
Hi,

Sorry, should have mentioned this. Click on the Table Name in the Datasource Window and click the DropDown Arrow that appears. Change this from DataGridView to Details and then drag the Table Name to the Form. All the individual fields will then be added at the same time.

Cheers,

Ian
 
Top Bottom