有一个名为S.txt的文件,内容是一些站号,形如:
H4010
H4035
H4036
H4037
H4059
H4060
H4061
H4062
先是读取文件,将文件中的作为查询数据库的条件,有符合查询条件的结果则生成新文件,将结果写入。代码如下:
//读取s.txt
FileStream checkStation = new FileStream("d:\\S.txt",FileMode.Open);
StreamReader mySr = new StreamReader(checkStation);
string mystrLine;
mystrLine = mySr.ReadLine();
while (mystrLine != null)
{
......
SqlConnection mySqlConnection = new SqlConnection(
@"Server=172.19.112.233;Database=CAWS600B;uid=sa;pwd=sasa;");
mySqlConnection.Open();
mySql = "select [一小时雨量],[区站号],[入库时间] from [CAWS600B].[dbo].[tabTimeData]
where 一小时雨量<>0 and 日期时间='" + dateTime + "' and 区站号='"+mystrLine+"'";
SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter(mySql, mySqlConnection);
//Console.WriteLine(mySql);
DataSet myDataSet = new DataSet();
mySqlDataAdapter.Fill(myDataSet, "Customers");
string fileName = null;
fileName = "QX" + DateTime.Now.ToString("yyyyMMddHHmm ");
......
if (!File.Exists("D:\\" + fileName + ".txt"))
{
//不存在就新建一个文本文件,并写入一些内容
FileStream firstFlieStream = new FileStream("D:\\" + fileName + ".txt", FileMode.Create, FileAccess.Write);
myStreamWriter = new StreamWriter(firstFlieStream);
myStreamWriter.WriteLine("ZCZC");
myStreamWriter.WriteLine("WSCI40 BESW " + tempDate + " " + tempTime);
foreach (DataRow myRow in myDataSet.Tables["Customers"].Rows)
{
myStreamWriter.WriteLine(myRow["区站号"] + " " + myRow["一小时雨量"] + "=");
}
myStreamWriter.WriteLine("NNNN");
myStreamWriter.Close();
firstFlieStream.Close();
}问题出现在,foreach处,新生成的文件不能够将数据库查询结果写入新文件。如果不传递S.txt中的内容作为参数,直接查询则一切正常。请帮忙看看哪里出了问题。
H4010
H4035
H4036
H4037
H4059
H4060
H4061
H4062
先是读取文件,将文件中的作为查询数据库的条件,有符合查询条件的结果则生成新文件,将结果写入。代码如下:
//读取s.txt
FileStream checkStation = new FileStream("d:\\S.txt",FileMode.Open);
StreamReader mySr = new StreamReader(checkStation);
string mystrLine;
mystrLine = mySr.ReadLine();
while (mystrLine != null)
{
......
SqlConnection mySqlConnection = new SqlConnection(
@"Server=172.19.112.233;Database=CAWS600B;uid=sa;pwd=sasa;");
mySqlConnection.Open();
mySql = "select [一小时雨量],[区站号],[入库时间] from [CAWS600B].[dbo].[tabTimeData]
where 一小时雨量<>0 and 日期时间='" + dateTime + "' and 区站号='"+mystrLine+"'";
SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter(mySql, mySqlConnection);
//Console.WriteLine(mySql);
DataSet myDataSet = new DataSet();
mySqlDataAdapter.Fill(myDataSet, "Customers");
string fileName = null;
fileName = "QX" + DateTime.Now.ToString("yyyyMMddHHmm ");
......
if (!File.Exists("D:\\" + fileName + ".txt"))
{
//不存在就新建一个文本文件,并写入一些内容
FileStream firstFlieStream = new FileStream("D:\\" + fileName + ".txt", FileMode.Create, FileAccess.Write);
myStreamWriter = new StreamWriter(firstFlieStream);
myStreamWriter.WriteLine("ZCZC");
myStreamWriter.WriteLine("WSCI40 BESW " + tempDate + " " + tempTime);
foreach (DataRow myRow in myDataSet.Tables["Customers"].Rows)
{
myStreamWriter.WriteLine(myRow["区站号"] + " " + myRow["一小时雨量"] + "=");
}
myStreamWriter.WriteLine("NNNN");
myStreamWriter.Close();
firstFlieStream.Close();
}问题出现在,foreach处,新生成的文件不能够将数据库查询结果写入新文件。如果不传递S.txt中的内容作为参数,直接查询则一切正常。请帮忙看看哪里出了问题。
能说的详细点么
-.-b 能指点一下么?谢谢!