Question

C#数据表格式字符串转DataTable

形如："
isql -Usa -P -Slinash02_rep
admin who
go
1> 2> Spid Name State Info
---- ---------- -------------------- ----------------------------------------
33 DSI EXEC Awaiting Command 176(1) lina_qa.LINA3
32 DSI Awaiting Message 176 lina_qa.LINA3
13 SQM Awaiting Message 176:0 lina_qa.LINA3
29 DSI EXEC Awaiting Command 108(1) linash02.LINA3
16 DSI Awaiting Message 108 linash02.LINA3
20 DIST Awaiting Wakeup 108 linash02.LINA3
25 SQT Awaiting Wakeup 108:1 DIST linash02.LINA3
11 SQM Awaiting Message 108:1 linash02.LINA3
10 SQM Awaiting Message 108:0 linash02.LINA3
104 REP AGENT Awaiting Command linash02.LINA3
27 DSI EXEC Awaiting Command 101(1) linash02.linash02_rep_RSSD
17 DSI Awaiting Message 101 linash02.linash02_rep_RSSD
21 DIST Awaiting Wakeup 101 linash02.linash02_rep_RSSD
26 SQT Awaiting Wakeup 101:1 DIST linash02.linash02_rep_RSSD
9 SQM Awaiting Message 101:1 linash02.linash02_rep_RSSD
8 SQM Awaiting Message 101:0 linash02.linash02_rep_RSSD
REP AGENT Down linash02.linash02_rep_RSSD
38 DSI EXEC Awaiting Command 137(1) newlinash02.LINA3
89 DSI Awaiting Message 137 newlinash02.LINA3
12 SQM Awaiting Message 137:0 newlinash02.LINA3
19 dSUB Sleeping
6 dCM Awaiting Message
7 dAIO Awaiting Message
23 dREC Sleeping dREC
24 dSTATS Sleeping
126 USER Active sa
5 dALARM Awaiting Wakeup
1> "
这样的字符串，如何把中间部分转为datatable?高分求！

Answer 1

转成CSV，当成EXCEL进行数据访问，用ado.net 来获取Datatable