Groups | Blog | Home
all groups > dotnet windows forms databinding > july 2005 >

dotnet windows forms databinding : How to determine that we are on a new row - Splitting an order


Pardo Jacques
7/24/2005 10:18:30 PM
1) In MS ACCESS we have a mean to determine that we are on a new record. How can we test this in ado.net with vb.net
2) Suppose the following problem occurs:
A client put an order. The amount of the product that he or she orders is lager than the stock. Is it possible with vb.net that in such a situation while entering the order, that the order item automatically is split in two orderitems after the requested quantity is entered and well as follows:
a) a first orderitem with a quantity as as what is present of the product in the stock
b) a second orderitem with the same product, but now with a quantity equal to the difference between what is ordered and what is booked in the first orderitem.
This second orderitem must than be qualified as a back order.

From http://www.developmentnow.com/g/31_0_0_0_0_0/dotnet-framework-windowsforms-databinding.htm

Posted via DevelopmentNow.com Groups
Ken Tucker [MVP]
7/25/2005 3:28:30 AM
Hi,

1)http://64.78.52.104/FAQ/WinForms/FAQ_c44c.asp#q823q

2) I would add a handler to the cells validate event and handle the
backorder problem
http://www.windowsformsdatagridhelp.com/default.aspx?ID=bece831d-6742-4364-bd0d-203ca99d2825

Ken
--------------------
[quoted text, click to view]
1) In MS ACCESS we have a mean to determine that we are on a new record. How
can we test this in ado.net with vb.net
2) Suppose the following problem occurs:
A client put an order. The amount of the product that he or she orders is
lager than the stock. Is it possible with vb.net that in such a situation
while entering the order, that the order item automatically is split in two
orderitems after the requested quantity is entered and well as follows:
a) a first orderitem with a quantity as as what is present of the product in
the stock
b) a second orderitem with the same product, but now with a quantity equal
to the difference between what is ordered and what is booked in the first
orderitem.
This second orderitem must than be qualified as a back order.

From
http://www.developmentnow.com/g/31_0_0_0_0_0/dotnet-framework-windowsforms-databinding.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

AddThis Social Bookmark Button