How do I divide the string in loops in ASP.NET C#

Question

1.60/5 (2 votes)

See more:

string rowValue = row["TrainNo"].ToString();

im storing the value of train no in rowvalue and want to divide the rowvalue into the loops to find exact no plz help asap

What I have tried:

string rowValue = row["TrainNo"].ToString();

Posted 11-Jun-18 20:40pm

Shahbaz435

Updated 11-Jun-18 21:16pm

Add a Solution

Comments

[no name] 12-Jun-18 2:41am

What is the format of TrainNo and what is the expected output? The code you posted isn't relevant to the question.

Shahbaz435 12-Jun-18 2:45am

trainno datatype is varchar and i want the value coming in rowvalue should be divide in the loop

[no name] 12-Jun-18 2:48am

I have no idea what you're trying to say, sorry.

Shahbaz435 12-Jun-18 2:49am

kk

Shahbaz435 12-Jun-18 2:47am

string rowValue = row["TrainNo"].ToString();

string[] splitString = rowValue.Split(',');
foreach (string str in splitString)
{
if (str == ("0"))
{
SoundPlayer sd = new SoundPlayer();
sd.SoundLocation = Server.MapPath("~/SoundWave/0.wav");
sd.PlaySync();
}

here is the code i want to divide the value in loop i have code but its oly supported to the comma i want to take the whole string and divide by 10000

Member 12270013 12-Jun-18 3:07am

do you mean, the string is to be looped for checking every character in it? and based on that character you are going to perform some operations. Is that what you seeking for?

Also you could provide a Base string you have in row[TrainNo] and Output/decision you want as result after dividing.

Shahbaz435 12-Jun-18 3:10am

yes exactly

Maciej Los 12-Jun-18 3:15am

Can you share sample data and expected output?

Shahbaz435 12-Jun-18 3:17am

this is my data and im getting 12345 in rowvalue from database and i want to divide the rowvalue by 10000

Shahbaz435 12-Jun-18 4:09am

string rowValue = row["TrainNo"].ToString();

string[] splitString = rowValue.Split(',');
foreach (string str in splitString)
{
if (str == ("0"))
{
SoundPlayer sd = new SoundPlayer();
sd.SoundLocation = Server.MapPath("~/SoundWave/0.wav");
sd.PlaySync();
}

3 solutions

Solution 2

While the solution by Thaddeus Jones will work, do yourself a favour: Don;t store data in VARCHAR or NVARCHAR columns unless it is genuinely a string. Store data in appropriate datatypes: integers in INT columns, floating point numbers in FLOAT columns, date in DATE, DATETIME, or DATETIME2. It saves a lot of problems later and makes your code much, much, easier when you want to work with the data, because the column can't contain invalid data. If you have an integer TrainNumber column, then nothing can put "Jaipur" or "12K" in there, causing your code to fail because it isn't a number.
Then all you have to do is

int rowValue = (int) row["TrainNo"];

And off you go...

Posted 11-Jun-18 21:18pm

OriginalGriff

Comments

Shahbaz435 12-Jun-18 3:22am

see my train no datatype is varchar bcoz i 'm storing the int and char in that column so thts y im getting toruble

OriginalGriff 12-Jun-18 3:37am

Precisely. If you have a number, don't store it in a string based column: and definitely don't store it in a string based column with genuinely string based data!
Consider changing the column to two columns: a numeric part, stored probably in a INT and a string part in a NVARCHAR - you can add a Computed Column to return the combination if other code needs it, but it means you can work with the bit you want immediately (and the sort order works properly as well!)

While it's possible to split out the numeric and text part, it's a pain to do that whenever you need "just the number", especially if the data in the column isn't necessarily in a specific format (i.e. always four digits, then eight characters for example).

It may seem like more work, but it's a trivial change at eth beginning of the project that makies the rest of the project which works with the data considerably easier (and thus more reliable).
What does your TrainNo column data look like at the moment?

Solution 3

Based on your clarifications, your code has been modified. I hope this works for you.

C#

string rowValue = "12345,asdf,65431,10000";
           int result;

           string[] splitString = rowValue.Split(',');
           foreach (string str in splitString)
           {
               if(Int32.TryParse(str, out result))
               {

                   if (result % 10000 == 0)
                   {
                       Console.WriteLine(result +" : is needed");
                   }
                   else
                   {
                       Console.WriteLine(result +" : is not needed");
                   }

               }
               else
                   {
                       Console.WriteLine(str+" : is not needed");
                   }
           }

Posted 11-Jun-18 21:18pm

Member 12270013

Updated 12-Jun-18 2:34am

v2

Comments

Shahbaz435 12-Jun-18 3:23am

no sir this is not solving my problem my problem is the loop checkinhg the whole string and divide the string and then playing the sound

Member 12270013 12-Jun-18 3:45am

when you say 'Looping' you iterate through every single piece of string. i.e. every char in it & now you can divide that single digit by 10000. (but is that really what you need)
Now, other way around your question may be, "Condition checking on the whole string" if its a digit and then performing division on the whole string
then Do you mean to use
1> Mode(%) operation to divide the TrainNumber and get remainder?
This divides the string like (123456 % 10000) = 3456(result you get)
Now perform operations based on "3456"
OR
2> Divide(/) operation on TrainNumber and get Quotient?
This Divides string like (123456 / 10000) = 12.3456 (result you get)

Shahbaz435 12-Jun-18 4:08am

yes like this only but how can i write the code for the loop plz help sir im new to looping

Member 12270013 12-Jun-18 9:00am

I Have updated the solution.
please note, the value of rowValue is assumed to be a comma separated value. I hope it is the same way in your case too.

Add a Solution

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)

User 7429338 · Accepted Answer · 2018-06-11T20:58:00

Solution 1

If you want to turn it into a double and then divide it by 10000, you could do:

C#

if (!double.TryParse(rowValue, out double value)) {
  // Invalid format.
}
value /= 10000;

Posted 11-Jun-18 20:58pm

User 7429338

Comments

Shahbaz435 12-Jun-18 3:02am

can u plz type in detail bcoz i'm not fimiliar with loops plz help