New WinForm form with lots of bound controls

[Ace1000]

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]

Hi and welcome to the Forum,

Have a watch of this youtube video:-

Data binding using Datasource DataGrid View & Binding navigator in visual studio 2012

Now that you have see that, to add your 30 individual fields to the form just drag the specific field name from the Datasource to the Form and everything is done for you.

Hope that helps.

Cheers,

Ian

 

[Ace1000]

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]

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