csv to datagrid

[Stanley Cheung]

Hi all,

How can I import a csv file and display as a datagrid directly.
Now, I am using datatable to bind to datagrid, but I got the problem for
sorting and paging, i don't know how to make a sorting and paging.

Do I need to store data into dataset and sqldataadapter?
I am using c#.

Thanks in advanced.
steambun

[Dmytro Lapshyn [MVP]]

Hi,

Is it a WinForms or an ASP .NET grid?

The latter has built-in support for sorting and paging, the former supports
sorting but not paging (which though might be compensated with scrolling).

--
Sincerely,
Dmytro Lapshyn [Visual Developer - Visual C# MVP]
"Stanley Cheung" <st*****@starlabz.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

Hi all,

How can I import a csv file and display as a datagrid directly.
Now, I am using datatable to bind to datagrid, but I got the problem for
sorting and paging, i don't know how to make a sorting and paging.

Do I need to store data into dataset and sqldataadapter?
I am using c#.

Thanks in advanced.
steambun

[Stanley Cheung]

Hi,

it is ASP.NET grid

Actually, I can control the sorting and paging if it querys from database
which has select connection string...
but if it stored into datatable or dataset... i don't know how to do that...

Thank you.
steambun
"Dmytro Lapshyn [MVP]" <x-****@no-spam-please.hotpop.com> ???
news:u0*************@TK2MSFTNGP15.phx.gbl ???...

Hi,

Is it a WinForms or an ASP .NET grid?

The latter has built-in support for sorting and paging, the former supports sorting but not paging (which though might be compensated with scrolling).

--
Sincerely,
Dmytro Lapshyn [Visual Developer - Visual C# MVP]
"Stanley Cheung" <st*****@starlabz.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

Hi all,

How can I import a csv file and display as a datagrid directly.
Now, I am using datatable to bind to datagrid, but I got the problem for
sorting and paging, i don't know how to make a sorting and paging.

Do I need to store data into dataset and sqldataadapter?
I am using c#.

Thanks in advanced.
steambun

[Cor Ligthert [MVP]]

Stanley,

You can use OleDb.

See this sample from Paul in C# the newsgroup General
(be aware that it is probably recoded VBNet)

http://groups.google.com/group/micro...e81f3818e74ae3

I hope this helps.

Cor

"Stanley Cheung" <st*****@starlabz.com> schreef in bericht
news:%2****************@TK2MSFTNGP10.phx.gbl...

Hi,

it is ASP.NET grid

Actually, I can control the sorting and paging if it querys from database
which has select connection string...
but if it stored into datatable or dataset... i don't know how to do
that...

Thank you.
steambun
"Dmytro Lapshyn [MVP]" <x-****@no-spam-please.hotpop.com> ???
news:u0*************@TK2MSFTNGP15.phx.gbl ???...

Hi,

Is it a WinForms or an ASP .NET grid?

The latter has built-in support for sorting and paging, the former

supports

sorting but not paging (which though might be compensated with
scrolling).

--
Sincerely,
Dmytro Lapshyn [Visual Developer - Visual C# MVP]
"Stanley Cheung" <st*****@starlabz.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

> Hi all,
>
> How can I import a csv file and display as a datagrid directly.
> Now, I am using datatable to bind to datagrid, but I got the problem
> for
> sorting and paging, i don't know how to make a sorting and paging.
>
> Do I need to store data into dataset and sqldataadapter?
> I am using c#.
>
> Thanks in advanced.
> steambun
>
>

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

In www.opennetcf.org you will find a dataprovider you can use to fill a
datatable

cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"Stanley Cheung" <st*****@starlabz.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

Hi all,

How can I import a csv file and display as a datagrid directly.
Now, I am using datatable to bind to datagrid, but I got the problem for
sorting and paging, i don't know how to make a sorting and paging.

Do I need to store data into dataset and sqldataadapter?
I am using c#.

Thanks in advanced.
steambun