Hello everyone,
Consider in below screeshot i want to update all the rows column2 corresponding “text” value in Column1. I want to achieve it without using for each loop and SQL. I have to found few threads in forum now proper solution is given in that. Can someone help on it?
@lakshman Can you help on this?
Give me some time and am already trying this one.
Sorry. I tried so many ways but not finding required solution. I don’t know how to do this without using For Each loop.
@lakshman Thanks for your time, is it possible to get all indexes of particular element in colulm1 at once?
I didn’t not get. Could you please show me some sample input and output.
@lakshman In above screenshot,I want to get indexes of “text” data which 0,2,3 as output since text is present in those rows.
If I give input as “Form” I want to get indexes as 1,4.
Like wise if I give input as “Submit” I want to get index as 5.
I have to get this indexes without using for each loop. Can you get me solution for this.
@Manish_Pandey By using add data row we can only new data to datatable. Your answer will not give solution to my question. Anyhow thanks for reply.
Try this expression:
yourDT.AsEnumerable().Where(Function(row) row(“Column1”).ToString.Equals(“text”)).Select(Function(row) DT.Rows.IndexOf(row)).ToArray()
this will expression will give index of all matching rows and output is array of integer. If you have any doubts then let me know.
@lakshman Thanks for your time, query given by you is working perfectly.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
prashant1603765
yedukondaluaregala
V_Roboto_V
sharazkm32
Aki1111
cristian_camilo_gonzalez
mively
ashokkarale
sonaliaggarwal47
postwick