TabControls & Saving to a Database

[Ray]

Hi

I have designed a database app using a windows form and a tab control with
comboboxes and edit controls on each tab control. The problem that I am
having is with the edit form that I have created.

On the forms onload event handler I databind the controls on the various tab
controls to the dataset for the selected record.

The problem comes when I save the record. If I haven't clicked on each tab
page and I click on the "Save Changes" button the sql query only posts data
for the controls in the tab pages that I have clicked on. The rest of the
data for the rest of the controls are posted as blanks. It seems that the
data is only populates the edit controls when the tab page becomes or is set
as active.

This becomes a problem if the user only needs to edit data on the first tab
page and not the rest.

Is there anyway that this can be changed or should I loop through the tab
pages and set tabcontrols.Sel ectedTab each page to initialise the data...

Any suggestions or help will be greatly appreciated...

Thanks
Ray G

[Cor Ligthert]

Ray,

I am not sure, however did you try the endcurrentedit before your update?
BindingContext( ds.Tables[0]).EndCurrentEdi t();

In this case is ds.tables[0] the datasource you are using.

I hope this helps?

Cor

"Ray" <ra*@mweb.co.za >

Hi

I have designed a database app using a windows form and a tab control
with
comboboxes and edit controls on each tab control. The problem that I am
having is with the edit form that I have created.

On the forms onload event handler I databind the controls on the various
tab
controls to the dataset for the selected record.

The problem comes when I save the record. If I haven't clicked on each tab
page and I click on the "Save Changes" button the sql query only posts
data
for the controls in the tab pages that I have clicked on. The rest of the
data for the rest of the controls are posted as blanks. It seems that the
data is only populates the edit controls when the tab page becomes or is
set
as active.

This becomes a problem if the user only needs to edit data on the first
tab
page and not the rest.

Is there anyway that this can be changed or should I loop through the tab
pages and set tabcontrols.Sel ectedTab each page to initialise the data...

Any suggestions or help will be greatly appreciated...

Thanks
Ray G

[Ray]

On the form load I am using TextBox1.DataBi ndings.Add("Tex t", ds,
"master.fieldna me); to populate the edit boxes on various tab pages...

I am creating the connection, dataset and doing the binding via code and not
via components...

Is this the wrong way of doing things.

"Cor Ligthert" <no************ @planet.nl> wrote in message
news:er******** ******@TK2MSFTN GP15.phx.gbl...

Ray,

I am not sure, however did you try the endcurrentedit before your update?
BindingContext( ds.Tables[0]).EndCurrentEdi t();

In this case is ds.tables[0] the datasource you are using.

I hope this helps?

Cor

"Ray" <ra*@mweb.co.za >

Hi

I have designed a database app using a windows form and a tab control
with
comboboxes and edit controls on each tab control. The problem that I am
having is with the edit form that I have created.

On the forms onload event handler I databind the controls on the various
tab
controls to the dataset for the selected record.

The problem comes when I save the record. If I haven't clicked on each
tab
page and I click on the "Save Changes" button the sql query only posts
data
for the controls in the tab pages that I have clicked on. The rest of the
data for the rest of the controls are posted as blanks. It seems that the
data is only populates the edit controls when the tab page becomes or is
set
as active.

This becomes a problem if the user only needs to edit data on the first
tab
page and not the rest.

Is there anyway that this can be changed or should I loop through the tab
pages and set tabcontrols.Sel ectedTab each page to initialise the data...

Any suggestions or help will be greatly appreciated...

Thanks
Ray G