Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / Languages / C# / May 2007

Tip: Looking for answers? Try searching our database.

sort column as int, not string after populate dataTable from a file

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ryan Liu - 15 May 2007 19:21 GMT
Hi,

I read a csv file to a datatable. I don't know what are the column types at
this moment, so I treat all columns as string type.

After I read data from file, I use dataTable.Select(condition) to select
some lines.

The problem is with numeric columns, since in datatable, it is string type,
it compares rows as string so make Select() return wrong set of rows.

I was trying to change DataColumn type, but it is an error since there are
already data in the column.

What is the best way to solve this problem? Any input is highly appreciated!

Ryan Liu
Sergey Poberezovskiy - 16 May 2007 05:33 GMT
Ryan,

You could use Convert function within your select - this way you will be
able to compare as a numeric datatype.
Not sure how can you know that a column contains numeric values when using
Select, but cannot use this knowledge when loading the data...

> Hi,
>
[quoted text clipped - 13 lines]
>
> Ryan Liu

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.