I want to separate the items in the database to be item by item

Question

1.00/5 (1 vote)

See more:

I need a big help i have a database, ineed a coding to split a item from database

database item
0000300005300113000000000000000000000
0000000000000000555535000105000000000
5533513503503000000000000000000000050

i need to split dbitem to 1 per 1
item 1 = 0
......
item 37 = 0

this code

VB

for i = 0 to dataset.tables(0).rows.count -1
dim str() as string = dataset.tables(0).rows(i).item("dbitem")
next

actually i have input item, iwant inputitem*dbitem
and comparing between rows, to get the greatest amount

Posted 3-Nov-15 15:19pm

Roymond Chandra Pradana

Updated 3-Nov-15 23:11pm

v2

Add a Solution

Comments

Garth J Lancaster 3-Nov-15 22:40pm

I think you need to edit & refine your question a little more - each of those 'lines'/?dbitems has ~37 characters - so, on what basis are you splitting them up ? if that whole thing is one item, then you definately need to indicate more on how its interpreted for split purposes

Roymond Chandra Pradana 4-Nov-15 4:13am

yes im sorry bad of english and yes, sorry the item 37, how to fixing that.
actually i have a input that same but per item
iwant iteminput X itemdb

and compare between rows, to get the greatest amount
and load that into datagridview

PIEBALDconsult 3-Nov-15 23:15pm

They should have been split before they were stored. Now it's too late.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)