将Access数据库中数据导入到SQL Server中的详细方法实例

前端技术 2023/09/09 .NET

Default.aspx

复制代码 代码如下:

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

<!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>
    <style type=\"text/css\">

        .style1
        {
            height: 16px;
        }
        .style3
        {
            height: 23px;
        }
    </style>
</head>
<body>
    <form id=\"form1\" runat=\"server\">
    <div>

    </div>
    <table align=\"center\" border=\"1\" bordercolor=\"honeydew\" cellpadding=\"0\"
        cellspacing=\"0\">
        <tr>
            <td colspan=\"2\"
                style=\"FONT-SIZE: 9pt; COLOR: #ffffff; HEIGHT: 16px; BACKGROUND-COLOR: #ff9933; TEXT-ALIGN: center\">
                将Access数据库中数据写入SQL Server数据库中</td>
        </tr>
        <tr>
            <td style=\"BACKGROUND-COLOR: #ffffcc; TEXT-ALIGN: center\">
                <asp:GridView ID=\"GridView2\" runat=\"server\" CellPadding=\"4\" ForeColor=\"#333333\"
                    GridLines=\"None\" style=\"font-size: small\" Width=\"331px\">
                    <FooterStyle BackColor=\"#990000\" Font-Bold=\"True\" ForeColor=\"White\" />
                    <RowStyle BackColor=\"#FFFBD6\" ForeColor=\"#333333\" />
                    <PagerStyle BackColor=\"#FFCC66\" ForeColor=\"#333333\" HorizontalAlign=\"Center\" />
                    <SelectedRowStyle BackColor=\"#FFCC66\" Font-Bold=\"True\" ForeColor=\"Navy\" />
                    <HeaderStyle BackColor=\"#990000\" Font-Bold=\"True\" ForeColor=\"White\" />
                    <AlternatingRowStyle BackColor=\"White\" />
                </asp:GridView>
            </td>
            <td style=\"WIDTH: 190px; BACKGROUND-COLOR: #ffffcc; TEXT-ALIGN: center\">
                <asp:GridView ID=\"GridView1\" runat=\"server\" CellPadding=\"4\" Font-Size=\"9pt\"
                    ForeColor=\"#333333\" GridLines=\"None\" Width=\"228px\">
                    <FooterStyle BackColor=\"#990000\" Font-Bold=\"True\" ForeColor=\"White\" />
                    <RowStyle BackColor=\"#FFFBD6\" ForeColor=\"#333333\" />
                    <SelectedRowStyle BackColor=\"#FFCC66\" Font-Bold=\"True\" ForeColor=\"Navy\" />
                    <PagerStyle BackColor=\"#FFCC66\" ForeColor=\"#333333\" HorizontalAlign=\"Center\" />
                    <HeaderStyle BackColor=\"#990000\" Font-Bold=\"True\" ForeColor=\"White\" />
                    <AlternatingRowStyle BackColor=\"White\" />
                </asp:GridView>
            </td>
        </tr>
        <tr>
            <td style=\"HEIGHT: 23px; BACKGROUND-COLOR: #ff9900; TEXT-ALIGN: center\"
                valign=\"top\">
                <asp:Button ID=\"Button3\" runat=\"server\" Font-Size=\"9pt\" onclick=\"Button1_Click\"
                    Text=\"Access数据写入SQL数据库中\" />
    <asp:Label ID=\"Label1\" runat=\"server\" Text=\"Label\" Visible=\"False\"
                    style=\"font-size: x-small\"></asp:Label>
            </td>
            <td style=\"WIDTH: 190px; HEIGHT: 23px; BACKGROUND-COLOR: #ff9900; TEXT-ALIGN: center\">
                <asp:Button ID=\"Button2\" runat=\"server\" Font-Size=\"9pt\" onclick=\"Button2_Click\"
                    Text=\"SQL数据库中显示导入的数据\" />
            </td>
        </tr>
        </table>
    </form>
</body>
</html>

本文地址：https://www.stayed.cn/item/26108

转载请注明出处。

本站部分内容来源于网络,如侵犯到您的权益,请 联系我

我的博客

人生若只如初见，何事秋风悲画扇。

我的标签

随笔档案