Hai,
I have to extract data from my SQL
Database is : client info
Table name is: production order
I need to extract data from SQL and stored in excel
1. I want Top 13 datas
2. I want bottom 5 datas only
Use Execute Query query to fetch data from Database and it will give output as DataTable. And then use Write Range activity and pass above output DataTable to write into Excel file.
How about Using below!
—> To take 13 datarows DT.AsEnumerable.Take(13).CopyToDatatable
---->To take last five datarows DT.AsEnumerable.skip(DT.Rows.count-5).CopyToDatatable**