asp.net 在网页上的 sql 替换程序
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Repair_data.aspx.cs" Inherits="admin_Repair_data" ValidateRequest="false" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>无标题页</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:TextBox ID="TextBox1" runat="server" Width="597px"></asp:TextBox>
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="修复" /><br />
<br />
进度:<br />
<asp:Literal ID="Literal1" runat="server"></asp:Literal></div>
</form>
</body>
</html>
cs文件
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.IO;
using System.Text.RegularExpressions;
public partial class admin_Repair_data : System.Web.UI.Page
{
my_basic my_b = new my_basic();
my_conn my_c = new my_conn();
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
}
}
protected void Button1_Click(object sender, EventArgs e)
{
DataTable dt = my_c.GetTable("SELECT name,id,crdate,refdate FROM sysobjects WHERE xtype = 'U' AND OBJECTPROPERTY (id, 'IsMSShipped') = 0");
for (int i = 0; i < dt.Rows.Count; i++)
{
DataTable dt1 = my_c.GetTable("SELECT Name,xtype FROM SysColumns WHERE id=Object_Id('" + dt.Rows[i]["name"].ToString() + "') ");
string t1 = "";
for (int j = 0; j < dt1.Rows.Count; j++)
{
if (dt1.Rows[j]["xtype"].ToString() == "231" || dt1.Rows[j]["xtype"].ToString() == "99")
{
if (t1 == "")
{
t1 = dt1.Rows[j]["Name"].ToString();
}
else
{
t1 = t1 + "|" + dt1.Rows[j]["Name"].ToString();
}
}
}
if (t1 != "")
{
DataTable dt2 = my_c.GetTable("select id," + t1.Replace("|", ",") + " from " + dt.Rows[i]["name"].ToString() + "");
for (int h = 0; h < dt2.Rows.Count; h++)
{
string sql = "update " + dt.Rows[i]["name"].ToString() + " set ";
string[] aa = t1.Split('|');
for (int l = 0; l < aa.Length; l++)
{
if (l == 0)
{
sql = sql + " " + aa[l].ToString() + "='" + dt2.Rows[h][aa[l].ToString()].ToString().Replace(my_b.c_string(this.TextBox1.Text), "") + "'";
}
else
{
sql = sql + "," + aa[l].ToString() + "='" + dt2.Rows[h][aa[l].ToString()].ToString().Replace(my_b.c_string(this.TextBox1.Text), "") + "'";
}
}
sql = sql + " where id=" + dt2.Rows[h]["id"].ToString();
//Response.Write(sql);
//Response.End();
my_c.genxin(sql);
}
}
}
Literal1.Text = "完成";
}
}