How to write a function for excel with c#

Question

Hello everybody,
is it possible to write a function for excel with c-sharp?
I`ve found an interesting atricle which describes such a scenario (the url) but it`s about visual studio 2005. I tried it with visual studio 2010 but it doesn`t work for me.

Can anybody help me please!

Wish you a nice day

Answer 1

Use Linq to datatable, refer sample.

DataTable dtMain = new DataTable();
DataTable dt1 = new DataTable();
//bind datatable

var rows1_10 = from item in dt1.AsEnumerable()
     select item;
var top1_10 = rows1_10.Take(10);

//do a for-loop and insert into dtMain

DataTable dt2 = new DataTable();
//bind datatable
var rows2_10 = from item in dt2.AsEnumerable()
     select item;
var top2_10 = rows2_10.Take(10);

//do a for-loop and insert into dtMain

Answer 2

Hi Purna,
Try to create  two temp datasets with a datatable containing 10 rows. and bind these two dataset to gridviews seperately.
Thanks
Rajesh