IDE: Databinding could not find a row in the list that is suitablefor all bindings.

[Aaron Smith]

Has anyone had their IDE do this before? I have 3 grids that are bound
to related tables. They are each in their own tab page.

Grid1 - DS.Table1.Table2
Grid2 - DS.Table1.Table2.Table3
Grid3 - DS.Table1.Table4

Table1
/ \
Table4 Table2
\
Table3

When I added grid1, I had a problem at first getting it to work.. Then I
finally figured out how to set the datamember correctly. Once I did that
the IDE start to throw that exception, and every once in a while it
will also say that the column Name can't contain nulls. Name is the name
of a column in table1 and table2. (not linked or indexed)...

It seems to throw the error pretty consistantly. It will throw it if I
try to run the program through the IDE.. I will build, then throw the
error, and even if you don't click the OK button, the program runs and
works fine (also runs on other machines fine). You can quit the program
and the message is still there waiting to be clicked. Once you click ok,
it will go back to the IDE and everything is fine.

If you have that form up and try to close the IDE, that is when you will
ALWAYS get that exception error, then the column cannot be null error
after that.

Any ideas? It's really annoying....

--
---
Aaron Smith
Remove -1- to E-Mail me. Spam Sucks.

[clorentson]

Aaron,

Given the date on your post I'm assuming you've probably figured out your
problem by now. However, I figured I would add my expereince and solution
here in the hopes that it will help others.

I received this exception when trying to databind a datetime picker's
"value" field, BUT the exception was raised several lines later. I found it
by commenting out code line-by-line. Here is the snippet:

'Orders panel

error occured on this line because of the "value" attribute but the exception was raised below. Changing it to "text" stopped the error. Me.dtOrderDate.DataBindings.Add(New Binding("value", OrderDS,
"Orders.OrderDate"))
Me.txtDeliveryMethod.DataBindings.Add(New Binding("Text", OrderDS,
"Orders.DeliveryMethod"))
Me.txtSpecialInstructions.DataBindings.Add(New Binding("Text",
OrderDS, "Orders.Special_Instr"))
Me.txtOrderTotal.DataBindings.Add(New Binding("Text", OrderDS,
"Orders.TotalOrderAmount"))
Me.bmbOrders = Me.panOrders.BindingContext(Me.OrderDS, "Orders")
'Order Details panel
Me.cboProductType.DataBindings.Add(New Binding("SelectedValue",
OrderDS, "Orders.OrdersOrderDetails.ProductTypeFK"))
Me.txtItemDescription.DataBindings.Add(New Binding("Text", OrderDS,
"Orders.OrdersOrderDetails.Description"))
Me.txtItemSpecialInstructions.DataBindings.Add(New Binding("Text",
OrderDS, "Orders.OrdersOrderDetails.ItemSpecialInstr"))
Me.txtItemTotal.DataBindings.Add(New Binding("Text", OrderDS,
"Orders.OrdersOrderDetails.TotalComponentPrice "))
Me.txtTray.DataBindings.Add(New Binding("Text", OrderDS,
"Orders.OrdersOrderDetails.Tray"))Exception was raised here, at the second binding manager base creation, not at the above. If there isn't a second one, I received it when showing the form; even harder to find where it was occuring.

Me.bmbOrderDetails = Me.panOrderDetails.BindingContext(Me.OrderDS,
"Orders.OrdersOrderPayments")

Hope that helps,
Carl

"Aaron Smith" wrote:
Has anyone had their IDE do this before? I have 3 grids that are bound
to related tables. They are each in their own tab page.

Grid1 - DS.Table1.Table2
Grid2 - DS.Table1.Table2.Table3
Grid3 - DS.Table1.Table4

Table1
/ \
Table4 Table2
\
Table3

When I added grid1, I had a problem at first getting it to work.. Then I
finally figured out how to set the datamember correctly. Once I did that
the IDE start to throw that exception, and every once in a while it
will also say that the column Name can't contain nulls. Name is the name
of a column in table1 and table2. (not linked or indexed)...

It seems to throw the error pretty consistantly. It will throw it if I
try to run the program through the IDE.. I will build, then throw the
error, and even if you don't click the OK button, the program runs and
works fine (also runs on other machines fine). You can quit the program
and the message is still there waiting to be clicked. Once you click ok,
it will go back to the IDE and everything is fine.

If you have that form up and try to close the IDE, that is when you will
ALWAYS get that exception error, then the column cannot be null error
after that.

Any ideas? It's really annoying....

--
---
Aaron Smith
Remove -1- to E-Mail me. Spam Sucks.

[Aaron Smith]

Thanks for the info. I haven't fixed the problem yet.. I went through
the form and looked at my data bindings, and I don't have any set to the
value, just to the text... As a side note, this is the first time in
about 3 months that I've had to look at that form through the IDE, and
when I did, no exceptions showed up. Go figure. I'll keep it in mind though.

Aaron

clorentson wrote:

Aaron,

Given the date on your post I'm assuming you've probably figured out your
problem by now. However, I figured I would add my expereince and solution
here in the hopes that it will help others.

I received this exception when trying to databind a datetime picker's
"value" field, BUT the exception was raised several lines later. I found it
by commenting out code line-by-line. Here is the snippet:

'Orders panel

error occured on this line because of the "value" attribute but the exception was raised below. Changing it to "text" stopped the error.
Me.dtOrderDate.DataBindings.Add(New Binding("value", OrderDS,
"Orders.OrderDate"))
Me.txtDeliveryMethod.DataBindings.Add(New Binding("Text", OrderDS,
"Orders.DeliveryMethod"))
Me.txtSpecialInstructions.DataBindings.Add(New Binding("Text",
OrderDS, "Orders.Special_Instr"))
Me.txtOrderTotal.DataBindings.Add(New Binding("Text", OrderDS,
"Orders.TotalOrderAmount"))
Me.bmbOrders = Me.panOrders.BindingContext(Me.OrderDS, "Orders")
'Order Details panel
Me.cboProductType.DataBindings.Add(New Binding("SelectedValue",
OrderDS, "Orders.OrdersOrderDetails.ProductTypeFK"))
Me.txtItemDescription.DataBindings.Add(New Binding("Text", OrderDS,
"Orders.OrdersOrderDetails.Description"))
Me.txtItemSpecialInstructions.DataBindings.Add(New Binding("Text",
OrderDS, "Orders.OrdersOrderDetails.ItemSpecialInstr"))
Me.txtItemTotal.DataBindings.Add(New Binding("Text", OrderDS,
"Orders.OrdersOrderDetails.TotalComponentPrice "))
Me.txtTray.DataBindings.Add(New Binding("Text", OrderDS,
"Orders.OrdersOrderDetails.Tray"))
Exception was raised here, at the second binding manager base creation, not at the above. If there isn't a second one, I received it when showing the form; even harder to find where it was occuring.

Me.bmbOrderDetails = Me.panOrderDetails.BindingContext(Me.OrderDS,
"Orders.OrdersOrderPayments")

Hope that helps,
Carl

"Aaron Smith" wrote:

Has anyone had their IDE do this before? I have 3 grids that are bound
to related tables. They are each in their own tab page.

Grid1 - DS.Table1.Table2
Grid2 - DS.Table1.Table2.Table3
Grid3 - DS.Table1.Table4

Table1
/ \
Table4 Table2
\
Table3

When I added grid1, I had a problem at first getting it to work.. Then I
finally figured out how to set the datamember correctly. Once I did that
the IDE start to throw that exception, and every once in a while it
will also say that the column Name can't contain nulls. Name is the name
of a column in table1 and table2. (not linked or indexed)...

It seems to throw the error pretty consistantly. It will throw it if I
try to run the program through the IDE.. I will build, then throw the
error, and even if you don't click the OK button, the program runs and
works fine (also runs on other machines fine). You can quit the program
and the message is still there waiting to be clicked. Once you click ok,
it will go back to the IDE and everything is fine.

If you have that form up and try to close the IDE, that is when you will
ALWAYS get that exception error, then the column cannot be null error
after that.

Any ideas? It's really annoying....

--
---
Aaron Smith
Remove -1- to E-Mail me. Spam Sucks.

--
---
Aaron Smith
Remove -1- to E-Mail me. Spam Sucks.