Error when committing the row to the original data store

[Sanjeev K B]

Hi all,

I am working on a project involving Datagrid with an extended feature of
combo box

i am trying to stop the occurance of duplicate ID's
i want to trap the message "Error when committing the row to the original
data store"
i would like to display my own message box and cancel the row that is being
added.

could anyone please help me out

Thanks and Regards,
Sanjeev K. B

[Ken Tucker [MVP]]

Re: Error when committing the row to the original data store

Hi,

You could override the SetColumnValueA tRow of your comboboxcolumn to
check for duplicate values before adding the data to original data store.

Ken
-----------------
"Sanjeev K B" <sanju@jcastnet .com> wrote in message
news:uqJCSclGEH A.2980@TK2MSFTN GP09.phx.gbl...[color=blue]
> Hi all,
>
> I am working on a project involving Datagrid with an extended feature of
> combo box
>
> i am trying to stop the occurance of duplicate ID's
> i want to trap the message "Error when committing the row to the original
> data store"
> i would like to display my own message box and cancel the row that is[/color]
being[color=blue]
> added.
>
> could anyone please help me out
>
> Thanks and Regards,
> Sanjeev K. B
>
>[/color]

[Sanjeev K B]

Re: Error when committing the row to the original data store

hi Ken,

thanks for the tip.

Could u also please tell me how to return an error to the user.
is there any other way of tackling this situation other than making
modifications to the DataGridComboBo x Column.

Thanks and Regards,
Sanjeev K.B

"Ken Tucker [MVP]" <vb2ae@bellsout h.net> wrote in message
news:eyuE74mGEH A.2308@tk2msftn gp13.phx.gbl...[color=blue]
> Hi,
>
> You could override the SetColumnValueA tRow of your comboboxcolumn[/color]
to[color=blue]
> check for duplicate values before adding the data to original data store.
>
> Ken
> -----------------
> "Sanjeev K B" <sanju@jcastnet .com> wrote in message
> news:uqJCSclGEH A.2980@TK2MSFTN GP09.phx.gbl...[color=green]
> > Hi all,
> >
> > I am working on a project involving Datagrid with an extended feature of
> > combo box
> >
> > i am trying to stop the occurance of duplicate ID's
> > i want to trap the message "Error when committing the row to the[/color][/color]
original[color=blue][color=green]
> > data store"
> > i would like to display my own message box and cancel the row that is[/color]
> being[color=green]
> > added.
> >
> > could anyone please help me out
> >
> > Thanks and Regards,
> > Sanjeev K. B
> >
> >[/color]
>
>[/color]

[Eng. Ashraf Fathy Fayez]

RE: Error when committing the row to the original data store

You can to make the enforce constrains on the dataset to be false, but u will need to check any database constarins by ur own

From http://www.developmentnow.com/g/38_2...data-store.htm

Posted via DevelopmentNow. com Groups

http://www.developmentnow.com