<%@ WebHandler Language="C#" Class="getitemname" Debug="true" %> using System; using System.Collections.Generic; using System.Web; using System.Data; using System.Data.Common; using System.Text; using eMIS; using eMIS.Data; public class getitemname : IHttpHandler { public void ProcessRequest (HttpContext context) { string r="ok"; try { DataManager dm = new DataManager(); string sql = "delete [172.27.203.113].pmis.dbo.sw_hkxx_dw where id in (select id from SW_HKXX_UP);insert into [172.27.203.113].pmis.dbo.sw_hkxx_dw select * from sw_hkxx where id in (select id from SW_HKXX_UP);delete SW_HKXX_UP"; dm.ExecuteNonQuery(sql); } catch (Exception exc) { r="err"; } context.Response.ContentType = "text/xml"; context.Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8"); context.Response.Write(""+r+""); } public bool IsReusable { get { return false; } } }