"Duong Nguyen" <duongnguyen@mail.ru> wrote in message
news:uo%23bc1Q%23GHA.3312@TK2MSFTNGP02.phx.gbl...
> Hello!
> I have 2 tables Products (ProductID,ProductName, Del) and Sale(id,
> productID, qty, price)
> Del setted to 1 if user deletes this product.
> I have DataGridView and a BindingNavigator which binds to this table.
> How can I control the Delete Method of the productsBindingSource everytime
> when use tries to delete some product. Because row only is deleted
> logically (set Del = 1), so I want to check if there is this product in
> the table Sale, if there is- then not allow to delete this product from
> table Product and vice verse.

> Thanks in advance!
>

"Bart Mermuys" <bmermuys.nospam@hotmail.com> wrote in message
news:ya90h.150230$yh3.2526271@phobos.telenet-ops.be...
> Hi,
>
> "Duong Nguyen" <duongnguyen@mail.ru> wrote in message
> news:uo%23bc1Q%23GHA.3312@TK2MSFTNGP02.phx.gbl...
>> Hello!
>> I have 2 tables Products (ProductID,ProductName, Del) and Sale(id,
>> productID, qty, price)
>> Del setted to 1 if user deletes this product.
>> I have DataGridView and a BindingNavigator which binds to this table.
>> How can I control the Delete Method of the productsBindingSource
>> everytime when use tries to delete some product. Because row only is
>> deleted logically (set Del = 1), so I want to check if there is this
>> product in the table Sale, if there is- then not allow to delete this
>> product from table Product and vice verse.
>
> Doubt there is anything build in. You probely gonna have to disconnect
> the Delete button (see BindingNavigator properties) and then add your own
> handler for the delete button, do the processing and then manually delete
> the row using the BindingSource.
>
> HTH,
> Greetings
>
>
>> Thanks in advance!
>>
>
>