Databindings and default value

[=?Utf-8?B?Tmljb2xhcw==?=]

Yes another question about databindings.

All my controls are have databindings and works fine for navigating, adding,
deleting etc.
What I want is when I create a New record have those fields pre-fill with
some value stored in my user.setting so the user doesn't have to re-type
evrything all the time.
Should be so straight forward that I don't get it! The fields are not
getting populated with those values.

What is wrong with this code or method that I'm using?

Private Sub TenantsBindingSource_AddingNew(ByVal sender As Object, ByVal e
As System.ComponentModel.AddingNewEventArgs) Handles
TenantsBindingSource.AddingNew
Me.txt_Address.Text = My.Settings.Address
Me.txt_BasicPrice.Value = My.Settings.BasicPrice
Me.txt_City.Text = My.Settings.City
Me.txt_Country.Text = My.Settings.Country
Me.txt_PostalCode.Value = My.Settings.PostalCode
Me.txt_Province.Text = My.Settings.Province
Me.txt_Suite.Text = My.Settings.Suite
End Sub
Thanks for the help

[Cor Ligthert[MVP]]

Nicolas,

Why are you filling the controls and not to new source?
I always use the source for this kind of problems.

Cor

"Nicolas" <Ni*****@discussions.microsoft.comschreef in bericht
news:ED**********************************@microsof t.com...

Yes another question about databindings.

All my controls are have databindings and works fine for navigating,
adding,
deleting etc.
What I want is when I create a New record have those fields pre-fill with
some value stored in my user.setting so the user doesn't have to re-type
evrything all the time.
Should be so straight forward that I don't get it! The fields are not
getting populated with those values.

What is wrong with this code or method that I'm using?

Private Sub TenantsBindingSource_AddingNew(ByVal sender As Object, ByVal e
As System.ComponentModel.AddingNewEventArgs) Handles
TenantsBindingSource.AddingNew
Me.txt_Address.Text = My.Settings.Address
Me.txt_BasicPrice.Value = My.Settings.BasicPrice
Me.txt_City.Text = My.Settings.City
Me.txt_Country.Text = My.Settings.Country
Me.txt_PostalCode.Value = My.Settings.PostalCode
Me.txt_Province.Text = My.Settings.Province
Me.txt_Suite.Text = My.Settings.Suite
End Sub
Thanks for the help

[=?Utf-8?B?Tmljb2xhcw==?=]

I want the user to see the field been filled properly and also I did not find
where to change the new row source from the BindingsSource_AddingNew function.

Yes I would also prefer your idea. Do you have any hint for this using the
datasource navigator feature which is the one I use.
Thank you.

"Cor Ligthert[MVP]" wrote:

Nicolas,

Why are you filling the controls and not to new source?
I always use the source for this kind of problems.

Cor

"Nicolas" <Ni*****@discussions.microsoft.comschreef in bericht
news:ED**********************************@microsof t.com...

Yes another question about databindings.

All my controls are have databindings and works fine for navigating,
adding,
deleting etc.
What I want is when I create a New record have those fields pre-fill with
some value stored in my user.setting so the user doesn't have to re-type
evrything all the time.
Should be so straight forward that I don't get it! The fields are not
getting populated with those values.

What is wrong with this code or method that I'm using?

Private Sub TenantsBindingSource_AddingNew(ByVal sender As Object, ByVal e
As System.ComponentModel.AddingNewEventArgs) Handles
TenantsBindingSource.AddingNew
Me.txt_Address.Text = My.Settings.Address
Me.txt_BasicPrice.Value = My.Settings.BasicPrice
Me.txt_City.Text = My.Settings.City
Me.txt_Country.Text = My.Settings.Country
Me.txt_PostalCode.Value = My.Settings.PostalCode
Me.txt_Province.Text = My.Settings.Province
Me.txt_Suite.Text = My.Settings.Suite
End Sub
Thanks for the help

[Cor Ligthert[MVP]]

Nicolas,

What is your source?

Cor

"Nicolas" <Ni*****@discussions.microsoft.comwrote in message
news:6D**********************************@microsof t.com...

>I want the user to see the field been filled properly and also I did not
find
where to change the new row source from the BindingsSource_AddingNew
function.

Yes I would also prefer your idea. Do you have any hint for this using the
datasource navigator feature which is the one I use.
Thank you.

"Cor Ligthert[MVP]" wrote:

>Nicolas,

Why are you filling the controls and not to new source?
I always use the source for this kind of problems.

Cor

"Nicolas" <Ni*****@discussions.microsoft.comschreef in bericht
news:ED**********************************@microso ft.com...

Yes another question about databindings.

All my controls are have databindings and works fine for navigating,
adding,
deleting etc.
What I want is when I create a New record have those fields pre-fill
with
some value stored in my user.setting so the user doesn't have to
re-type
evrything all the time.
Should be so straight forward that I don't get it! The fields are not
getting populated with those values.

What is wrong with this code or method that I'm using?

Private Sub TenantsBindingSource_AddingNew(ByVal sender As Object,
ByVal e
As System.ComponentModel.AddingNewEventArgs) Handles
TenantsBindingSource.AddingNew
Me.txt_Address.Text = My.Settings.Address
Me.txt_BasicPrice.Value = My.Settings.BasicPrice
Me.txt_City.Text = My.Settings.City
Me.txt_Country.Text = My.Settings.Country
Me.txt_PostalCode.Value = My.Settings.PostalCode
Me.txt_Province.Text = My.Settings.Province
Me.txt_Suite.Text = My.Settings.Suite
End Sub
Thanks for the help

[Cor Ligthert[MVP]]

I mean the Type of the DataSource
"Nicolas" <Ni*****@discussions.microsoft.comwrote in message
news:6D**********************************@microsof t.com...

>I want the user to see the field been filled properly and also I did not
find
where to change the new row source from the BindingsSource_AddingNew
function.

Yes I would also prefer your idea. Do you have any hint for this using the
datasource navigator feature which is the one I use.
Thank you.

"Cor Ligthert[MVP]" wrote:

>Nicolas,

Why are you filling the controls and not to new source?
I always use the source for this kind of problems.

Cor

"Nicolas" <Ni*****@discussions.microsoft.comschreef in bericht
news:ED**********************************@microso ft.com...

Yes another question about databindings.

All my controls are have databindings and works fine for navigating,
adding,
deleting etc.
What I want is when I create a New record have those fields pre-fill
with
some value stored in my user.setting so the user doesn't have to
re-type
evrything all the time.
Should be so straight forward that I don't get it! The fields are not
getting populated with those values.

What is wrong with this code or method that I'm using?

Private Sub TenantsBindingSource_AddingNew(ByVal sender As Object,
ByVal e
As System.ComponentModel.AddingNewEventArgs) Handles
TenantsBindingSource.AddingNew
Me.txt_Address.Text = My.Settings.Address
Me.txt_BasicPrice.Value = My.Settings.BasicPrice
Me.txt_City.Text = My.Settings.City
Me.txt_Country.Text = My.Settings.Country
Me.txt_PostalCode.Value = My.Settings.PostalCode
Me.txt_Province.Text = My.Settings.Province
Me.txt_Suite.Text = My.Settings.Suite
End Sub
Thanks for the help

[=?Utf-8?B?Tmljb2xhcw==?=]

I am using the dataset, dataAdapter, datasource, databindingSource object
created automaticaly by dotnet connecting to my ms-access table
I navigate over record via the datanavigator from dotnet.
Basic stuff.
When I create a new record I click on the add new button in the navigatorbar
which is working fine and do what it is suppose to do. But at this point this
is where I would like to have my field populated by default instead of having
them blank

Thanks
Me.TenantsTableAdapter.Fill(Me.MTIDataSet.Tenants)
"Cor Ligthert[MVP]" wrote:

Nicolas,

What is your source?

Cor

"Nicolas" <Ni*****@discussions.microsoft.comwrote in message
news:6D**********************************@microsof t.com...

I want the user to see the field been filled properly and also I did not
find
where to change the new row source from the BindingsSource_AddingNew
function.

Yes I would also prefer your idea. Do you have any hint for this using the
datasource navigator feature which is the one I use.
Thank you.

"Cor Ligthert[MVP]" wrote:

Nicolas,

Why are you filling the controls and not to new source?
I always use the source for this kind of problems.

Cor

"Nicolas" <Ni*****@discussions.microsoft.comschreef in bericht
news:ED**********************************@microsof t.com...
Yes another question about databindings.

All my controls are have databindings and works fine for navigating,
adding,
deleting etc.
What I want is when I create a New record have those fields pre-fill
with
some value stored in my user.setting so the user doesn't have to
re-type
evrything all the time.
Should be so straight forward that I don't get it! The fields are not
getting populated with those values.

What is wrong with this code or method that I'm using?

Private Sub TenantsBindingSource_AddingNew(ByVal sender As Object,
ByVal e
As System.ComponentModel.AddingNewEventArgs) Handles
TenantsBindingSource.AddingNew
Me.txt_Address.Text = My.Settings.Address
Me.txt_BasicPrice.Value = My.Settings.BasicPrice
Me.txt_City.Text = My.Settings.City
Me.txt_Country.Text = My.Settings.Country
Me.txt_PostalCode.Value = My.Settings.PostalCode
Me.txt_Province.Text = My.Settings.Province
Me.txt_Suite.Text = My.Settings.Suite
End Sub
Thanks for the help

[Steve Gerrard]

Nicolas wrote:

>
This then create me all the object like dataset, datatable,
dataadapter, datasourcebindings, etc.

Then I do a databindings from the field property window with the
"TenantsBindingSource - Name" bounded to Text

I would not try to do default values with a bound textbox, or by catching an
event of the binding source or navigator.

The better place to set some default values is on the columns of the datatable
itself.

You sould be able to do something like
TenantsTable.Columns("PostalCode").DefaultValue = My.Settings.PostalCode

If you need to, you can also process the TenantsTable.TableNewRow event to set
initial values.

[=?Utf-8?B?Tmljb2xhcw==?=]

Excellent, this is what I was looking for.
Was my first time using those control and did not know everything about those.

Thank you

"Steve Gerrard" wrote:

Nicolas wrote:

This then create me all the object like dataset, datatable,
dataadapter, datasourcebindings, etc.

Then I do a databindings from the field property window with the
"TenantsBindingSource - Name" bounded to Text

I would not try to do default values with a bound textbox, or by catching an
event of the binding source or navigator.

The better place to set some default values is on the columns of the datatable
itself.

You sould be able to do something like
TenantsTable.Columns("PostalCode").DefaultValue = My.Settings.PostalCode

If you need to, you can also process the TenantsTable.TableNewRow event to set
initial values.