本人有个文件,用文件流按行读出后结果如下
"2008-02-19 12:10:00",15398,14.31,7.993,7.42,55.5,0.572,0.498,354.3,18.78,0,3.207,490,266.1,1.627,0.424,416.7,407.5,0.168,0.043,68.37
"2008-02-19 12:20:00",15399,14.18,8.33,8.06,53.02,0.57,0.269,350.3,8.5,0,3.205,502.7,265.9,1.558,0.423,412.9,399.1,0.167,0,68.36
。。等
现在需要在读取数据时做个处理将每条数据按字段插入到datatable里或者转换成json数据格式,求各为达人给各算法!!!
我现在读取数据的代码
string path = @"C:\Documents and Settings\Administrator\桌面\000.dat"; using (StreamReader sr = File.OpenText(path))
{
string s = "";
while ((s = sr.ReadLine()) != null)
{
Response.Write(s+"\n");
}
}
另求教输出数据时,换行符没有起作用,为什么??
"2008-02-19 12:10:00",15398,14.31,7.993,7.42,55.5,0.572,0.498,354.3,18.78,0,3.207,490,266.1,1.627,0.424,416.7,407.5,0.168,0.043,68.37
"2008-02-19 12:20:00",15399,14.18,8.33,8.06,53.02,0.57,0.269,350.3,8.5,0,3.205,502.7,265.9,1.558,0.423,412.9,399.1,0.167,0,68.36
。。等
现在需要在读取数据时做个处理将每条数据按字段插入到datatable里或者转换成json数据格式,求各为达人给各算法!!!
我现在读取数据的代码
string path = @"C:\Documents and Settings\Administrator\桌面\000.dat"; using (StreamReader sr = File.OpenText(path))
{
string s = "";
while ((s = sr.ReadLine()) != null)
{
Response.Write(s+"\n");
}
}
另求教输出数据时,换行符没有起作用,为什么??
{ if (t.Trim() != "\"")
Response.Write(t + "<br>");
}
这样,然后我再构建数据表后插入即可???
dt.Columns.Add("ab");
dt.Columns.Add("cd");
ArrayList arrText = new ArrayList(); string sLine = ""; while (sLine != null)
{
sLine = reader.ReadLine();
if (sLine != null)
{
arrText.Add(sLine);
}
} reader.Close(); char[] chart = new char[] { ',' };
foreach (string s in arrText)
{
DataRow dr = dt.NewRow();
string[] field = s.Split(chart);
int i = 1;
foreach (string fs in field)
{
switch (i)
{
case 1:
dr["ab"] = fs.Trim();
break;
case 2:
dr["cd"] = fs.Trim();
break;
}
i++;
}
dt.Rows.Add(dr);
}
string connectionString = "Data Source=127.0.0.1;Initial Catalog=table;uid=sa;pwd=sa";
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
SqlBulkCopy bcp = new SqlBulkCopy(conn); bcp.DestinationTableName = "TempTable";
bcp.WriteToServer(dt);
conn.Close(); Response.Write("成功");code]