TXT存进SQL2000的IMAGE中，再读取出来转成二维数组怎么弄

TXT存进SQL2000的IMAGE中，再读取出来转成二维数组如何弄

C# code

 string sqlText = "server=localhost;initial catalog=TEST; integrated security=true;user id =sa;password = 123456";            string sqlstr = "select 系数文件 from 基本_部件 where 部件ID=6";            SqlConnection conn = new SqlConnection(sqlText);            conn.Open();           SqlCommand comm = new SqlCommand(sqlstr, conn);            //读取测试                   SqlDataReader dr = comm.ExecuteReader();            while (dr.Read())            {                Byte[] raw = (Byte[])dr[0];                string result = System.Text.Encoding.GetEncoding("GB2312").GetString(raw);                textBox1.Text = result;                        }            dr.Close();            conn.Close();

result的值是"12\t100.34\r\n13\t100.35\r\n14\t100.36\r\n15\t100.37\r\n16\t100.38\r\n17\t100.39\r\n18\t100.4\r\n19\t100.41\r\n20\t100.42\r\n21\t100.43\r\n22\t100.44\r\n23\t100.45\r\n24\t100.46\r\n25\t100.47\r\n"


\t就是一个TAB，\r\n就是换行。我想转成一个有2列的二维数组，有什么好的办法解析吗？

[解决办法]

C# code

 string result = "12\t100.34\r\n13\t100.35\r\n14\t100.36\r\n15\t100.37\r\n16\t100.38\r\n17\t100.39\r\n18\t100.4\r\n19\t100.41\r\n20\t100.42\r\n21\t100.43\r\n22\t100.44\r\n23\t100.45\r\n24\t100.46\r\n25\t100.47\r\n";                var temp_result = Regex.Matches(result, @"(\d+)\s(\d+(\.\d+)?)").Cast<Match>().Select(a => new { ID=a.Groups[1].Value,Value=a.Groups[2].Value});                /*                 +        [0]    { ID = "12", Value = "100.34" }    <Anonymous Type>                +        [1]    { ID = "13", Value = "100.35" }    <Anonymous Type>                +        [2]    { ID = "14", Value = "100.36" }    <Anonymous Type>                +        [3]    { ID = "15", Value = "100.37" }    <Anonymous Type>                +        [4]    { ID = "16", Value = "100.38" }    <Anonymous Type>                +        [5]    { ID = "17", Value = "100.39" }    <Anonymous Type>                +        [6]    { ID = "18", Value = "100.4" }    <Anonymous Type>                +        [7]    { ID = "19", Value = "100.41" }    <Anonymous Type>                +        [8]    { ID = "20", Value = "100.42" }    <Anonymous Type>                +        [9]    { ID = "21", Value = "100.43" }    <Anonymous Type>                +        [10]    { ID = "22", Value = "100.44" }    <Anonymous Type>                +        [11]    { ID = "23", Value = "100.45" }    <Anonymous Type>                +        [12]    { ID = "24", Value = "100.46" }    <Anonymous Type>                +        [13]    { ID = "25", Value = "100.47" }    <Anonymous Type>                 */ 

 

查看更多 下一篇