If ID is the first column then syntax for array as per your example should be like {Nothing,"Rakesh"}, it will add first column with increamented value.
If Allow Null is checked for all other columns and ID with auto increment is kept as first column then its getting incremented for adding a blank row..
If ID is the first column then syntax for array as per your example should be like {Nothing,"Rakesh"}, it will add first column with increamented value.
Hi Yashwant, Yes correct. I have tried and it working as expected.
how to wite its not wrking
nice video for auto increment learning
thanks for the video !
What is the difference between ArrayRow vs DataRow ?
What If we want to add location details as well along with name, how can we do that using add data row.
If Allow Null is checked for all other columns and ID with auto increment is kept as first column then its getting incremented for adding a blank row..
Great to know, how are you entering values in the add data row property panel
i think we can define something like this {"", "Gopal","ABC" etc..} the first one can be left blank. Experiment and let me know!
You are trying to insert string value to int32 data type column (ID)
You are right, that is reason of that error! Good findig thanks!