Split string and take into datagridview problems

Question

1.00/5 (2 votes)

See more:

i have string and i am splting this string using this code :

split = ast.Split(new Char[] { '!' });

after that i am making DataTable

DataTable table = new DataTable();

DataGridViewRow addRow = new DataGridViewRow();

int columnCount = 27;
                    for (int i = 1; i <= columnCount; i++)
                    {
                        DataColumn col = new DataColumn("col" + i);
                        table.Columns.Add(col);
                    }

DataRow row = table.NewRow();

after this i want to this splited string take into cells and i am using code that i am trying but there is 1 problem my string length may be 27 or 27+27 my string length is growig with constant number 27 soo i have columns 27 but if my code(what i have tryed) see that length is more then 27 it is erroring me

Additional information: Cannot find column 27.

plz help me do this

What I have tried:

                         for (int i = 0; i <= split.length; i++)
                         {

                             row[i] = split[i];
                         }
                         
                         table.Rows.Add(row);
  

                      
}
                     this.dataGridView1.DataSource = table;

Posted 24-Apr-17 2:22am

GTR0123

Updated 24-Apr-17 2:34am

Add a Solution

1 solution

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)

OriginalGriff · Answer 1 · 2017-04-24T02:34:00

Solution 1

The first thing to do is to see if there is another separator in there: it sound like you have 27 elements separated by "!", then an second set also separated by "!", then a third.
It would be normal under these circumstances to have a second separator to delimit each set:

1A!1B!...!1Z!1ZA|2A!2B!...

(often it's a newline to make it humanly readable.) So start by looking at your data and checking that. If you do, then it's simple: spilt it into each row via teh second separator, then split each row and add that:

C#

string[] rows = ast.Split('|');
foreach (string row in rows)
   {
   string cells = row.Split('!');
   // Add cells to a new row here.
   }

Posted 24-Apr-17 2:34am

OriginalGriff

Comments

GTR0123 24-Apr-17 8:40am

the problem is that there is no other seperator for example string looks like
1!2!3!
4!5!6!
i want this 1 2 3 go on 1 cell
and 4 5 6 on another sell but there can be more then 2 rows

sameer549 24-Apr-17 8:45am

give your exact input string.. is it contains multiple lines as you given above?

GTR0123 24-Apr-17 8:47am

SIP/1000-0000005f!from_cdn!2000!1!Up!Dial!SIP/2000!1000!!!3!9!SIP/2000-00000060!1492821337.95
SIP/1000-0000005d!from_cdn!3000!1!Up!Dial!SIP/3000!1000!!!3!18!SIP/3000-0000005e!1492821329.93
if this string is coming i mean length it is doing well everything
but
SIP/1000-0000005f!from_cdn!2000!1!Up!Dial!SIP/2000!1000!!!3!9!SIP/2000-00000060!1492821337.95
SIP/1000-0000005d!from_cdn!3000!1!Up!Dial!SIP/3000!1000!!!3!18!SIP/3000-0000005e!1492821329.93
SIP/1000-0000005f!from_cdn!2000!1!Up!Dial!SIP/2000!1000!!!3!9!SIP/2000-00000060!1492821337.95
SIP/1000-0000005d!from_cdn!3000!1!Up!Dial!SIP/3000!1000!!!3!18!SIP/3000-0000005e!1492821329.93
when it is twice more it is erroring me that

OriginalGriff 24-Apr-17 10:18am

That data is broken into "natural" lengths: you even placed them on separate lines.
It looks like PABX log data to me, and I suspect that it's in a very specific format, probably the lines you have broken it into.
Grab your raw data again, and use a hex editor to look at it closely: I suspect that each line is terminated with a #0D or #0A (CR or LF ASCII characters) and you should be observing that.