【www.gdgbn.com--网页配色】

asp.net 在网页上的 sql 替换程序
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Repair_data.aspx.cs" Inherits="admin_Repair_data" ValidateRequest="false" %>

   


   

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 = "完成";
    }
}

本文来源：http://www.gdgbn.com/wangyezhizuo/22808/