我做一个timer,每10秒读一次数据库,将DateTr=0的记录写到sqlConnection1的远程服务器上,为什么下述程序只能成功执行一条数据,后面的数据就插入失败,提示--未处理的“System.Data.SqlClient.SqlException”类型的异常出现在 system.data.dll 中。--高手快救我其他信息: 系统错误。
string Sql;
private void timer1_Tick(object sender, System.EventArgs e)
{
this.sqlConnection1.Open();
this.sqlDataAdapter1.SelectCommand.CommandText="select * from T1 where DateTr=0";
SqlDataReader reader=this.sqlDataAdapter1.SelectCommand.ExecuteReader();
while(reader.Read())
{
Sql="INSERT INTO T1(status,SendTel,ReceiveTel,Date,Time,RecordFile,SongFile,CallCount) VALUES (@status,@SendTel,@ReceiveTel,@Date,@Time,@RecordFile,@SongFile,@CallCount)";
this.sqlDataAdapter2.InsertCommand.CommandText=Sql;
this.sqlDataAdapter2.InsertCommand.Parameters.Add("@status",reader["status"].ToString());
this.sqlDataAdapter2.InsertCommand.Parameters.Add("@SendTel",reader["SendTel"].ToString());
this.sqlDataAdapter2.InsertCommand.Parameters.Add("@ReceiveTel",reader["ReceiveTel"].ToString());
this.sqlDataAdapter2.InsertCommand.Parameters.Add("@Date",reader["Date"].ToString());
this.sqlDataAdapter2.InsertCommand.Parameters.Add("@Time",reader["Time"].ToString());
this.sqlDataAdapter2.InsertCommand.Parameters.Add("@RecordFile",reader["RecordFile"].ToString());
this.sqlDataAdapter2.InsertCommand.Parameters.Add("@SongFile",reader["SongFile"].ToString());
this.sqlDataAdapter2.InsertCommand.Parameters.Add("@CallCount",reader["CallCount"].ToString());
this.sqlDataAdapter2.InsertCommand.Connection.Open();
this.sqlDataAdapter2.InsertCommand.ExecuteNonQuery();
this.sqlDataAdapter2.InsertCommand.Connection.Close();
}
reader.Close();
this.sqlConnection1.Close();
}