How to Auto Increment Datattable using linq Query Iam having 10k rows so for loop not possible

Help Studio
, , , ,
1

In datatble I have 10000 rows so need to auto increment one row using linq query kindly help

2

This may help

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/320288f5-9dfd-4043-aefa-e154666f48c8/linq-update-a-column-with-auto-increment-value?forum=csharpgeneral

Cheers

3

@J0ska Thanks for the reply.

But if i am not wrong this query is to add a increment column if i have all the data. but in my case i am merging orignal datatable’s data with another data tabel’s data. So that increment column must be increment.

Thanks

4

Autoincrement column will increment it’s value as you are adding new rows to the datatable.
Just try it.

Cheers