C # generates a specified format for the results of PL/SQL query result column replication

Example: A column of SQL queries in Pl/sql has the following results:

Leaves

Wei

Hong

Sun

What

... Omitted after

To generate a dictionary format:

{1, "Ye"},{2, "Wei"},{3, "Hong"},{4, "Sun"},{5, "ho"} ...

First, copy the Pl/sql column and put it in a string, looping the string char, because the string contains the line break, so you should also judge the removal and judgment in the loop, and then do the processing.

The code is as follows:

private void Button1_Click (object sender, EventArgs e)

{

string s = @ "

Leaves

Wei

Hong

Sun

What

"; The following omitted ...

string result = "", r = "";

int i = 1;

foreach (char c in s)

{

R = c.tostring (). Replace (' R ', '). Replace (' n ', ');

if (R!= "")

{

result = "{" + i.tostring () + @ "," "+ R + @" ""}, ";

i++;

}

}

result = result. TrimEnd (', ');

Textbox1.appendtext (result);

}