473,232 Members | 1,647 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,232 software developers and data experts.

Error when committing the row to the original data store

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
Nov 20 '05 #1
4 3409
Hi,

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

Ken
-----------------
"Sanjeev K B" <sa***@jcastnet.com> wrote in message
news:uq**************@TK2MSFTNGP09.phx.gbl...
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

Nov 20 '05 #2
Hi,

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

Ken
-----------------
"Sanjeev K B" <sa***@jcastnet.com> wrote in message
news:uq**************@TK2MSFTNGP09.phx.gbl...
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

Nov 20 '05 #3
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 DataGridComboBox Column.

Thanks and Regards,
Sanjeev K.B

"Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message
news:ey**************@tk2msftngp13.phx.gbl...
Hi,

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

Ken
-----------------
"Sanjeev K B" <sa***@jcastnet.com> wrote in message
news:uq**************@TK2MSFTNGP09.phx.gbl...
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


Nov 20 '05 #4
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 DataGridComboBox Column.

Thanks and Regards,
Sanjeev K.B

"Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message
news:ey**************@tk2msftngp13.phx.gbl...
Hi,

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

Ken
-----------------
"Sanjeev K B" <sa***@jcastnet.com> wrote in message
news:uq**************@TK2MSFTNGP09.phx.gbl...
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


Nov 20 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: Benjamin Scott | last post by:
Hello. I attempted to build a compound dictionary: len(Lst)=1000 len(nuerLst)=250 len(nuestLst)=500 Dict={}
4
by: Kain0o0 | last post by:
Hello , thanks for any help in advance. Im writing some code for a c++ class and the proffessor wants us to implement a list template using arrays. I thought this would be an easy task but have...
0
by: David Elliott | last post by:
I have a DataGrid with a checkbox that is mapped to a field in a collection. Sometimes when I click on the check box, I get this annoying message. Error When committing the row to the original...
0
by: michael schindler | last post by:
I get this error message...why? And what can I do? ****************************************** Error when committing the row to the original data store: The Listmanager's position must be...
1
by: AH | last post by:
Hi, I used a dataTable to bind to datagrid. I setup code to handle the rowchanging event but whenever I change from one row to another in the datagrid, the datagrid changed to a white box with a...
3
by: Sanjeev K B | last post by:
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...
3
by: Adriano | last post by:
Hello, when I try to print something, either DataGrid or from Crystal Report viever the folowing error message appears and cancels printing: Object reference not set to an instance of an...
6
by: tgnelson85 | last post by:
Hello, C question here (running on Linux, though there should be no platform specific code). After reading through a few examples, and following one in a book, for linked lists i thought i would...
3
by: Jim Armstrong | last post by:
Hello all - This is driving me crazy. I have a table called tblClients - very simple, has the following fields: taxID (PK) ClientName SalesName The main form of my application allows a...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.