多行sql转单行

最新推荐文章于 2024-04-18 21:07:05 发布

qq_42678477

最新推荐文章于 2024-04-18 21:07:05 发布

阅读量468

点赞数

本文链接：https://blog.csdn.net/qq_42678477/article/details/81772877

版权

using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

using System.Text.RegularExpressions;

public partial class Hcfxgj_Other_ConvertMultiLineToOne : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string txt = txtMutiLine.Text;
        string txt1 = Regex.Replace(txt, "\r\n", "");
        txt1 = Regex.Replace(txt1,@"\s*,\s*",",");
        txtOneLine.Text = txt1;
    }
}

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ConvertMultiLineToOne.aspx.cs" Inherits="Hcfxgj_Other_ConvertMultiLineToOne" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <title>多行SQL转一行</title>
    <style>
        hr {
            border:none;
        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:TextBox ID="txtMutiLine" TextMode="MultiLine" Width="600" Height="200" runat="server"></asp:TextBox>
        <hr />
        <asp:Button ID="Button1" runat="server" Text="转换" OnClick="Button1_Click" />
        <hr />
        <asp:TextBox ID="txtOneLine" TextMode="MultiLine" Width="600" Height="200" runat="server"></asp:TextBox>
    </div>
    </form>
</body>
</html>

qq_42678477

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
多行sql转单行

using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Text.RegularExpressions;public partial class Hcfxgj_Other_...
复制链接

扫一扫