数据查找出来有2109条记录,但这样操作删除时,会出现超时,请问有什么办法能解决呀?CmdText="Select * d_NO from Vendition_Data"+term;
rs=OperateObject.ExecuteReader(CommandType.Text,CmdText,null);
while(rs.Read())
{
CmdText="Delete from Vendition_Data where d_NO='R"+rs["d_NO"].ToString().Substring(1,10)+"'"; //退
Cmd.CommandText=CmdText;
Cmd.ExecuteNonQuery();
CmdText="Delete from vendition_info where d_NO='"+rs["d_NO"].ToString()+"'";//整机
Cmd.CommandText=CmdText;
Cmd.ExecuteNonQuery();
CmdText="Delete from vendition_Pei where d_NO='"+rs["d_NO"].ToString()+"'";//整配件
Cmd.CommandText=CmdText;
Cmd.ExecuteNonQuery();
CmdText="Delete from Vendition_Fittings_Detail where s_code='"+rs["d_NO"].ToString()+"'";//配制
Cmd.CommandText=CmdText;
Cmd.ExecuteNonQuery();
Del_I++;
}
rs.Close();
CmdText="Delete from Vendition_Data"+term;
Cmd.CommandText=CmdText;
Cmd.ExecuteNonQuery();
rs=OperateObject.ExecuteReader(CommandType.Text,CmdText,null);
while(rs.Read())
{
CmdText="Delete from Vendition_Data where d_NO='R"+rs["d_NO"].ToString().Substring(1,10)+"'"; //退
Cmd.CommandText=CmdText;
Cmd.ExecuteNonQuery();
CmdText="Delete from vendition_info where d_NO='"+rs["d_NO"].ToString()+"'";//整机
Cmd.CommandText=CmdText;
Cmd.ExecuteNonQuery();
CmdText="Delete from vendition_Pei where d_NO='"+rs["d_NO"].ToString()+"'";//整配件
Cmd.CommandText=CmdText;
Cmd.ExecuteNonQuery();
CmdText="Delete from Vendition_Fittings_Detail where s_code='"+rs["d_NO"].ToString()+"'";//配制
Cmd.CommandText=CmdText;
Cmd.ExecuteNonQuery();
Del_I++;
}
rs.Close();
CmdText="Delete from Vendition_Data"+term;
Cmd.CommandText=CmdText;
Cmd.ExecuteNonQuery();
"Delete from vendition_info where exists (Select * d_NO from Vendition_Data where Vendition_Data.d_No = vendition_info.d_No)"