VB.NET dataset from textfile

Hello everyone,

I need a 2005 program that will read a textfile (example attached) and parse the text line by line into a dataset. I need to be able to use SQL select statements to later retrieve the records.

An example of a line in the file looks like this: Serum_0.3_1440_HCT116_3_1 3.6155 3.8423 3.9098 3.0297 3.4987 4.0843 3.6383 2.9978 3.2785 3.9895

The dataset needs to contain the following columns:








I need to be able to parse the first value (in the example above, this is: "Serum_0.3_1440_HCT116_3_1") into the form:

Treatment_Dose_Time_Cell_Bioreps_Techreps. The value column needs to be filled with the remaining portion of the line as a string.

The example file has 1025 entries, so that means there should be 1025 records in the dataset.

The real task that I need it to be able to execute SQL commands on this (I.e. SELECT * FROM Table WHERE Treatment = 'UV').

Note: I DO NOT have an SQL server available...I need this program to be portable from computer to computer...including computers without MS Access. Is any of this possible?

When bidding, please give me a little bit of info as to how you will be doing this...that way I know you understand what I need and I can choose a better coder that way. Also, please provide an estimate as to how long this might take. I need it asap, and will gladly give a bonus for speed!

All questions welcome!


## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

VB.NET 2005

Win XP

Habilidades: .NET, Engenharia, MySQL, PHP, Arquitetura de software, Teste de Software, Visual Basic

Veja mais: what is the use of vb net, vb note, vb net program code, vb net for hire, use of vb net, use in, i need a c# net coder, how to work with vb net, how to use vb net, how to use in, how to read computer code, how to code, how to code in vb net, example of, example of vb net, desktop, desktop vb net, 9895, portable package, e vb, sql commands, parse a string, sql retrieve table, php string contain, php parse string

Acerca do Empregador:
( 57 comentários ) United States

ID do Projeto: #3021237

Concedido a:


See private message.

$25.5 USD em 5 dias
(37 Comentários)

2 freelancers estão ofertando em média $26 para esse trabalho


See private message.

$25.5 USD in 5 dias
(4 Comentários)