I am having some data in data array variable “system.data.datarow” how can i write this data into excel file
my problem is that I have a DataTable which contains all the data in excel sheet so I want to convert it to DataRow, is this possible?Please help
you can use like “dtTable.Select()” . It will return the datarow array.
Thank you so much for quick reply,it worked:slightly_smiling_face:
Alongwith balu’s solution, dt.AsEnumerable() can also be used.
Edit: Remember that above will return
System.Data.EnumerbaleRowCollection(of System.Data.DataRow). .ToArray is essential to be converted into Datarow array