我做一个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();
}
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();
}
解决方案 »
- ARCGIS Server9.2 发布地图服务问题
- UTF8Encoding 的问题,急!!!
- C#.NET中在TextBox中输入一个数值,当焦点离开时,触发一个往dropdownlist里添加数据的事件,怎么判断TextBox值是整数,是才触发。
- 函数的本质是啥?高手请解答(偶是个初学者,不太明白)
- 我应该用那个控件,将按扭归类显示(美化界面)!
- Help me!!!
- 语音聊天问题??需要大家帮忙!!!!!!!!!
- DataTable的变量传递问题
- 那位可以提供一些c#的比较实用的实例程序下载。载到就给分
- C#根据需要将某一时间内报警时间的累计
- 如何在网站不用window.open而打开窗口?
- 怎样查看picturebox的image的属性
this.sqlDataAdapter2.InsertCommand.Connection.Open(); 在循环外
this.sqlDataAdapter2.InsertCommand.ExecuteNonQuery();正常
this.sqlDataAdapter2.InsertCommand.Connection.Close();在循环外的最后