How add new row to DataTable without duplicity.

Question

0.00/5 (No votes)

See more:

VS2010

, +

Visual studio creating automatically Form pro edit, delete and add row in DataTable (creating ToolBar with buttons Add, Delete, Update and Form with controls for editing, viewing data in DataTable. But, I do not find way, how to modify code for adding new row to DataTable, so that the user can not insert data into a form that is already contained.

Example: First control is ComboBox - User. This control is used for entering Name User (over his ID). Second control is ComboBox - Car. This control is used for entering car (over his ID) for business trip. How do I make the content control ComboBox - Car (and code for filtering data only during add new row to DataTable) that in ComboBox - Car not offered values which are already stored in the DataTable? (Example User with Id=1 use Car with Id=1, so ComboBox - Car do not have value 1, if I am change User to Id=2, ComboBox - Car refresh content and has only values, which will not duplicity rows in DataTable for user with Id=2).

I will be grateful for any tip or help.

Jaroslav

Posted 22-Jun-14 21:34pm

kracora

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

coded007 · Answer 1 · 2014-06-23T20:14:00

Solution 1

While binding data table to combo box check weather the data table has those values or not.

Posted 23-Jun-14 20:14pm

coded007

girlprogrammer · Answer 2 · 2014-06-27T03:44:00

Solution 2

While Binding do something like - dataTable.Select("ID <>" carIDOfTheUser.ToString()). This will return a datarow array. You can convert and create a datasource.Similarly you can create a dataview from the datatable based on the select condition.

Posted 27-Jun-14 3:44am

girlprogrammer

How add new row to DataTable without duplicity.

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

How add new row to DataTable without duplicity.

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us