null in textbox

[Frank]

Hello,
a small problem. In a bound textbox I delete the contents and when I go to
another control de text reappears. No events and so on. The db column
accepts null. If the textbox is empty and I put something in, or change
something, no problem. Someone else had the same problem (read in some
newsgroup) and solved it because his databinding was screwy, no further
explanation. I use this (shortened version):

Dim kol As DataColumn
for each kol in ds.tables(0).columns
objNew = New TextboxUser(kol) (my own userclass, inherits textbox)
objNew.databindings.add("Text", ds.Tables(0), kol.ColumnName)
next
myCM = CType(Me.BindingContext(ds.Tables(0)), CurrencyManager)

Please advice
Thanks
Frank

[::P:e:s:c:e:::M:a:r:c:o::]

"Frank" <fr***@frank.com> ha scritto nel messaggio
news:ca**********@news5.tilbu1.nb.home.nl...

Hello,
a small problem. In a bound textbox I delete the contents and when I go to
another control de text reappears. No events and so on. The db column
accepts null. If the textbox is empty and I put something in, or change
something, no problem. Someone else had the same problem (read in some
newsgroup) and solved it because his databinding was screwy, no further
explanation. I use this (shortened version):

Dim kol As DataColumn
for each kol in ds.tables(0).columns
kol.AllowDBNull = true
objNew = New TextboxUser(kol) (my own userclass, inherits textbox)
objNew.databindings.add("Text", ds.Tables(0), kol.ColumnName)
next
myCM = CType(Me.BindingContext(ds.Tables(0)), CurrencyManager)

[Cor Ligthert]

Hi Frank,

Have a look at an earlier message I sand about this.

http://groups.google.com/groups?selm...TNGP10.phx.gbl

I hope this helps?

Cor

a small problem. In a bound textbox I delete the contents and when I go to
another control de text reappears. No events and so on. The db column
accepts null. If the textbox is empty and I put something in, or change
something, no problem. Someone else had the same problem (read in some
newsgroup) and solved it because his databinding was screwy, no further
explanation. I use this (shortened version):

Dim kol As DataColumn
for each kol in ds.tables(0).columns
objNew = New TextboxUser(kol) (my own userclass, inherits textbox)
objNew.databindings.add("Text", ds.Tables(0), kol.ColumnName)
next
myCM = CType(Me.BindingContext(ds.Tables(0)), CurrencyManager)

Please advice
Thanks
Frank

[Frank]

"::P:e:s:c:e:::M:a:r:c:o::" <it***************@hotmail.com> wrote in message
news:Ok**************@tk2msftngp13.phx.gbl...

"Frank" <fr***@frank.com> ha scritto nel messaggio
news:ca**********@news5.tilbu1.nb.home.nl...

Hello,
a small problem. In a bound textbox I delete the contents and when I go to another control de text reappears. No events and so on. The db column
accepts null. If the textbox is empty and I put something in, or change
something, no problem. Someone else had the same problem (read in some
newsgroup) and solved it because his databinding was screwy, no further
explanation. I use this (shortened version):

Dim kol As DataColumn
for each kol in ds.tables(0).columns

kol.AllowDBNull = true

objNew = New TextboxUser(kol) (my own userclass, inherits textbox)

objNew.databindings.add("Text", ds.Tables(0), kol.ColumnName)
next
myCM = CType(Me.BindingContext(ds.Tables(0)), CurrencyManager)

"::P:e:s:c:e:::M:a:r:c:o::" , it's a bound column so that prop is already
set!!!!

[Frank]

"Cor Ligthert" <no**********@planet.nl> wrote in message
news:eS**************@TK2MSFTNGP11.phx.gbl...

Hi Frank,

Have a look at an earlier message I sand about this.

http://groups.google.com/groups?selm...TNGP10.phx.gbl
I hope this helps?

Cor

a small problem. In a bound textbox I delete the contents and when I go to another control de text reappears. No events and so on. The db column
accepts null. If the textbox is empty and I put something in, or change
something, no problem. Someone else had the same problem (read in some
newsgroup) and solved it because his databinding was screwy, no further
explanation. I use this (shortened version):

Dim kol As DataColumn
for each kol in ds.tables(0).columns
objNew = New TextboxUser(kol) (my own userclass, inherits textbox)
objNew.databindings.add("Text", ds.Tables(0), kol.ColumnName)
next
myCM = CType(Me.BindingContext(ds.Tables(0)), CurrencyManager)

Please advice
Thanks
Frank

Cor, very nice, but are you telling me there is no better (read: simpler)
solution? There must be, because, as I wrote, someone else solved it by a
change in his databinding.
Frank

[Cor Ligthert]

Hi Frank,

I misreaded your question.

Dim kol As DataColumn
for each kol in ds.tables(0).columns
objNew = New TextboxUser(kol) (my own userclass, inherits textbox)
objNew.databindings.add("Text", ds.Tables(0), kol.ColumnName)
next
myCM = CType(Me.BindingContext(ds.Tables(0)), CurrencyManager)

Why is that objNew = New TextboxUser(kol)
I assume you want to set the databindings to an existing textbox so I would
expect something as
dim objNew as Textbox = TextboxUser(kol)

Just guessing I see to few now,

Cor

[Frank]

"Cor Ligthert" <no**********@planet.nl> wrote in message
news:ez**************@TK2MSFTNGP12.phx.gbl...

Hi Frank,

I misreaded your question.

Dim kol As DataColumn
for each kol in ds.tables(0).columns
objNew = New TextboxUser(kol) (my own userclass, inherits textbox)
objNew.databindings.add("Text", ds.Tables(0), kol.ColumnName)
next
myCM = CType(Me.BindingContext(ds.Tables(0)), CurrencyManager)
Why is that objNew = New TextboxUser(kol)
I assume you want to set the databindings to an existing textbox so I

would expect something as
dim objNew as Textbox = TextboxUser(kol)

Just guessing I see to few now,

Cor

Cor,
there is a dim: dim objNew as object. But it doesn't show in this small
piece of code.
I don't think u misread the question, because your solution probably works.
But it's a lot of work for something that looks like a bug. If the dbcol is
varchar or so, then this behaviour does not occur.
I'm still researching and so far I discovered that at the end of the
validating event, the old contents are put back into the textbox.
Regards
Frank

[Cor Ligthert]

Hi Frank,

Not the dim, the New is what I tried to show you.
You are setting references to an existing textbox I assume.

Cor

[Frank]

"Cor Ligthert" <no**********@planet.nl> wrote in message
news:Or**************@TK2MSFTNGP12.phx.gbl...

Hi Frank,

Not the dim, the New is what I tried to show you.
You are setting references to an existing textbox I assume.

Cor

I don't know what u mean, everything works fine except the appearance of
deleted numbers.
Doesn't matter, I used your method. Wasn't much work because I only had to
program it in my usertextboxclass (which inherits textbox). But I still
think this is a bug.
Thanx
Frank