how to show data in next line of datagridview which fetch from datable using regex

See more:

regular-expression

DataGridView

, +

Hi

I have a list of string in which i have few name in the same line when i use my code i got all name in the same series what i want is to first user in first row of datagrid and second in second. here is my code:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;

namespace AQCConsolidator1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void btnGetData_Click(object sender, EventArgs e)
        {
            
            List<String> list1 = new List<String>();
string req =@"TST00003     DCA1S211E AD/18APR M 1 LD 20APR13 OD SDFSDF SI                     
T-E                                                                             
FXP/R,U                                                                         
   1.MCKEEL/WESLEY C   2.MCKEEL/MATTHEW M   3.SMITH/ALEXANDER P                 
 1   SDF AA 3273 Q 17MAY 1245P OK QLW0N8B1 CDTP        17AUG 2PC                
 2 X DFW AA  399 Q 17MAY  345P OK QLW0N8B1 CDTP        17AUG 2PC                
 3 X SFO AA 5815 Q 17MAY  705P OK QLW0N8B1 CDTP        17AUG 2PC                
 4   HND    ARNK                                                                
 5 O NRT AA  176 Q 30MAY 1130A OK QLX0N8B1 CDTP   20MAY17AUG 2PC                
 6 X DFW AA  830 Q 30MAY  320P OK QLX0N8B1 CDTP   20MAY17AUG 2PC                
     SDF                                                                        
FARE  F USD     488.00                                                          
TX001 X USD   580.00YRVB TX002 X USD     5.50YCAE TX003 X USD    17.20USAP      
TX004 X USD    17.20USAS TX005 X USD     5.00XACO TX006 X USD     7.00XYCR      
TX007 X USD    10.00AYSE TX008 X USD    21.08SWAE TX009 X USD     5.17OISE      
TX010 X USD    18.00XF                                                          
TOTAL   USD    1174.15                                                          
GRAND TOTAL USD    1174.15                                                      
SDF AA X/DFW AA X/SFO AA TYO M257.60QLW0N8B1/CDTP AA X/DFW AA                   
 SDF M230.00QLX0N8B1/CDTP NUC487.60END ROE1.000000 XF SDF4.5DFW                 
4.5SFO4.5DFW4.5"

string Req1 = @"FXP/R,U,CL-MBT                                                                  
   1.JAYAPAL/HEMACHANDRA                                                        
 1   ORD UA  940 T 21MAY  610P OK TKX6NCE  CN10   21MAY21MAY 1PC                
 2 X FRA LH  758 T 22MAY 1100A OK TKX6NCE  CN10   22MAY22MAY 1PC                
 3 O MAA 9W  470 H 17JUN  710P OK TKX6NCE  CN10   17JUN17JUN 1PC                
 4 X BOM LX  155 T 18JUN  050A OK TKX6NCE  CN10   18JUN18JUN 1PC                
 5 X ZRH LX 2608 T 18JUN  955A OK TKX6NCE  CN10   18JUN18JUN 1PC                
     ORD                                                                        
FARE  I USD     711.00                                                          
TX001 X USD   540.00YQAC TX002 X USD     5.50YCAE TX003 X USD    17.20USAP      
TX004 X USD    17.20USAS TX005 X USD     5.00XACO TX006 X USD     7.00XYCR      
TX007 X USD     2.50AYSE TX008 X USD    25.92RAEB TX009 X USD     8.71DESE      
TX010 X USD     3.65WOMU TX011 X USD    25.66CHAE TX012 X USD     4.50XF        
TOTAL   USD    1373.84                                                          
GRAND TOTAL USD    1373.84                                                      
CHI UA X/FRA LH MAA M/IT TKX6NCE/CN10 9W X/BOM LX X/ZRH LX CHI                  
 M/IT TKX6NCE/CN10 END XF ORD4.5                                         
                                                                                
 55.FE REFTHRUAG/NONEND/NONRERTE/LH/UA/AC/OS/SN/LX ONLY -BG:LH                  
 59.FM *M*0                                                                     
 60.FP CHECK";     
            list1.Add(Req);
            list1.Add(Req1);
            DataTable dt = mc.GetDetail(list1);
            dataGridView1.DataSource = dt;

this is my class code:

using System;
      using System.Collections.Generic;
      using System.Linq;
      using System.Text;
      using System.Data;
      using System.Text.RegularExpressions;

     namespace AQCConsolidator1
    {
        class MyClass1
        {
            string output;
            string subs;

            DataTable dt = new DataTable();
            DataRow dr = null;
             public DataTable GetDetail(List<string> request)
            {
            dt.Columns.Add("PAX", typeof(string));

            foreach (string data in request)
            {
                string item = data;
                dr = dt.NewRow();
                Regex regexs = new Regex(@"(FXP/R\s+(.+?)+\s)|(FXP/R.\S{0,10}\s\S{0,10}\s+(.+?)+\s)");
                foreach (Match m in regexs.Matches(item))
                {
                    output = m.ToString();
                }
                dr["PAX"] = output;
                dt.Rows.Add(dr);
            }
            return dt;
        }