Problem with big datatable

[mtnhan]

Hi everybody.
I have a plain text file and I read row by row after that put it into
datatable (one cell contains one character). So this Datatable size can be
50,000x50,000 or more than. After that I bind this datatable to datagrid.
Everything is ok until the datatable > 2,000x2,000 . My program runs very
slowly with big datatable, especially when read from file to datatable .
I tried to use ArrayList and Array Charracter to instead of Datatable.But I
don't know how to bind ArrayList or Array char to datagrid.
Could you give me a solution ?
Thank you very much.

[guy]

50,000 columns?

could you please explain how and why you need this many columns and who can
read that many?

guy
"mtnhan" wrote:

Hi everybody.
I have a plain text file and I read row by row after that put it into
datatable (one cell contains one character). So this Datatable size can be
50,000x50,000 or more than. After that I bind this datatable to datagrid.
Everything is ok until the datatable > 2,000x2,000 . My program runs very
slowly with big datatable, especially when read from file to datatable .
I tried to use ArrayList and Array Charracter to instead of Datatable.But I
don't know how to bind ArrayList or Array char to datagrid.
Could you give me a solution ?
Thank you very much.

[mtnhan]

Because, I read a text file and put it into datatable.so You can't know how
long is a Row.

[guy]

perhaps you could explain what you are trying to achieve after reading this
text file?
why do you need to use a datagrid?

guy

"mtnhan" wrote:

Because, I read a text file and put it into datatable.so You can't know how
long is a Row.

[mtnhan]

My program is like Excel, after read from text file. I use datagrid to show
it. And User can change data on datagrid.
for example: User can Cut,Paste,Copy,Del... Column, Row or block Cell.. .
Drag and drop Column.....
So, I realize that datagrid is good.
Do you think so ?
Thanks