C # generate a specified format for the results of copying PL/SQL query result Columns

For example, the results of an SQL query in PL/SQL are as follows:

Leaf

Wei

Hong

Sun

He

... Is omitted later

To generate the dictionary format:

{1, "Ye" },{ 2, "wei" },{ 3, "Hong" },{ 4, "Sun" },{ 5, "He "}...

First, copy the columns of PL/SQL, put them in a string, and cycle the char of this string. Because the string contains a line break, we need to judge and remove it in the loop and then perform processing.

The Code is as follows:

Private void button#click (object sender, EventArgs e)

{

String s = @"

Leaf

Wei

Hong

Sun

He

"; // Unspecified...

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 );

}