欧美激情理论,欧美日本国产视频,亚洲美洲欧洲综合国产一区

主頁 > 知識庫 > 將Access數(shù)據(jù)庫中數(shù)據(jù)導(dǎo)入到SQL Server中的詳細(xì)方法實(shí)例

將Access數(shù)據(jù)庫中數(shù)據(jù)導(dǎo)入到SQL Server中的詳細(xì)方法實(shí)例

Default.aspx

復(fù)制代碼代碼如下:

%@ 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>無標(biāo)題頁/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數(shù)據(jù)庫中數(shù)據(jù)寫入SQL Server數(shù)據(jù)庫中/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數(shù)據(jù)寫入SQL數(shù)據(jù)庫中" />
    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數(shù)據(jù)庫中顯示導(dǎo)入的數(shù)據(jù)" />
            /td>
        /tr>
        /table>
    /form>
/body>
/html>

Default.aspx.cs

復(fù)制代碼代碼如下:

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.OleDb;
using System.Data.SqlClient;

public partial class AccessToSQL : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            AccessLoadData();
        }
    }
    public OleDbConnection CreateCon()
    {
        string strconn = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + Server.MapPath("UserScore.mdb") + ";User Id=admin;Password=;";
        OleDbConnection odbc = new OleDbConnection(strconn);
        return odbc;
    }
    public SqlConnection CreateSQLCon()
    {
        string sqlcon = ConfigurationSettings.AppSettings["strCon"];
        SqlConnection mycon = new SqlConnection(sqlcon);
        return mycon;
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string sql = "";
        OleDbConnection con = CreateCon();//創(chuàng)建數(shù)據(jù)庫連接
        con.Open();
        DataSet ds = new DataSet(); //創(chuàng)建數(shù)據(jù)集
        sql = "select * from Score";
        OleDbDataAdapter myCommand = new OleDbDataAdapter(sql,con);//創(chuàng)建數(shù)據(jù)適配器
        myCommand.Fill(ds, "Score");
        myCommand.Dispose();
        DataTable DT = ds.Tables["Score"];
        con.Close();
        myCommand.Dispose();
        for (int j = 0; j DT.Rows.Count; j++)//循環(huán)ACCESS中數(shù)據(jù)獲取相應(yīng)信息
        {
            string sqlstr = "";
            string ID = DT.Rows[j][0].ToString();
            string UserName = DT.Rows[j][1].ToString();
            string PaperName = DT.Rows[j][2].ToString();
            string UserScore = DT.Rows[j][3].ToString();
            string ExamTime = DT.Rows[j][4].ToString();
            string selsql = "select count(*) from AccessToSQL where 用戶姓名='" + UserName + "'";
            if (ExScalar(selsql) > 0)//判斷數(shù)據(jù)是否已經(jīng)添加
            {
                Label1.Visible = true;
                Label1.Text = "script language=javascript>alert('該Access數(shù)據(jù)庫中數(shù)據(jù)已經(jīng)導(dǎo)入SQL數(shù)據(jù)庫中!');location='AccessToSQL.aspx';/script>";
            }
            else
            {
                string AccessPath = Server.MapPath("UserScore.mdb");//獲取ACCESS數(shù)據(jù)庫路徑
                //應(yīng)用OPENROWSET函數(shù)訪問 OLE DB 數(shù)據(jù)源中的遠(yuǎn)程數(shù)據(jù)所需的全部連接信息
                sqlstr = "insert into AccessToSQL(ID,用戶姓名,試卷,成績,考試時(shí)間)Values('" + ID + "','" + UserName + "','" + PaperName + "','" + UserScore + "','" + ExamTime + "')";
                sqlstr += "select * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','" + AccessPath + "';'admin';'',Score)";
                SqlConnection conn = CreateSQLCon();
                conn.Open();
                SqlCommand mycom = new SqlCommand(sqlstr, conn);
                mycom.ExecuteNonQuery();//執(zhí)行添加操作
                if (j == DT.Rows.Count - 1)
                {
                    Label1.Visible = true;
                    Label1.Text = "script language=javascript>alert('數(shù)據(jù)導(dǎo)入成功.');location='AccessToSQL.aspx';/script>";
                }
                else
                {
                    Label1.Visible = true;
                    Label1.Text = "script language=javascript>alert('數(shù)據(jù)導(dǎo)入失敗.');location='AccessToSQL.aspx';/script>";
                }
                conn.Close();
            }
        }

    }
    public void AccessLoadData()
    {
        OleDbConnection myConn = CreateCon();
        myConn.Open();   //打開數(shù)據(jù)鏈接，得到一個(gè)數(shù)據(jù)集
        DataSet myDataSet = new DataSet();   //創(chuàng)建DataSet對象
        string StrSql = "select   *   from Score";
        OleDbDataAdapter myCommand = new OleDbDataAdapter(StrSql, myConn);
        myCommand.Fill(myDataSet, "Score");
        GridView2.DataSource = myDataSet;
        GridView2.DataBind();
        myConn.Close();
    }
    public int ExScalar(string sql)
    {
        SqlConnection conn = CreateSQLCon();
        conn.Open();
        SqlCommand com = new SqlCommand(sql, conn);
        return Convert.ToInt32(com.ExecuteScalar());
        conn.Close();
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        string sqlstr = "select * from AccessToSQL";
        SqlConnection conn = CreateSQLCon();
        conn.Open();
        SqlCommand mycom = new SqlCommand(sqlstr, conn);
        SqlDataReader dr = mycom.ExecuteReader();
        dr.Read();
        if (dr.HasRows)
        {
            GetDataSet(sqlstr);
        }
        else
        {
            Label1.Visible = true;
            Label1.Text = "script language=javascript>alert('數(shù)據(jù)庫中沒有數(shù)據(jù)信息，請先導(dǎo)入再查詢！');location='AccessToSQL.aspx';/script>";
        }
        dr.Close();
        conn.Close();
    }
    public DataSet GetDataSet(string sqlstr)
    {
        SqlConnection conn = CreateSQLCon();
        SqlDataAdapter myda = new SqlDataAdapter(sqlstr, conn);
        DataSet ds = new DataSet();
        myda.Fill(ds);
        GridView1.DataSource = ds;
        GridView1.DataBind();
        return ds;
    }
}

您可能感興趣的文章:

SQL Server中的數(shù)據(jù)復(fù)制到的Access中的函數(shù)
Access轉(zhuǎn)Sql Server問題實(shí)例說明
Sql Server、Access數(shù)據(jù)排名的實(shí)現(xiàn)方法(例如：成績排名)
SQLServer與Access常用SQL函數(shù)區(qū)別
SQL 隨機(jī)查詢包括(sqlserver,mysql,access等)
在ACCESS和SQL Server下Like 日期類型查詢區(qū)別
Access和SQL Server里面的SQL語句的不同之處
asp.net下Oracle,SQL Server,Access萬能數(shù)據(jù)庫通用類
SQL SERVER 與ACCESS、EXCEL的數(shù)據(jù)轉(zhuǎn)換方法分享
八步解決ACCESS自動(dòng)編號問題(將SQL SERVER 2000數(shù)據(jù)庫,轉(zhuǎn)換為ACCESS數(shù)據(jù)庫)
將ACCESS數(shù)據(jù)庫遷移到SQLSERVER數(shù)據(jù)庫兩種方法(圖文詳解)
sqlserver，sqlite，access數(shù)據(jù)庫鏈接字符串整理
自己動(dòng)手把ACCESS轉(zhuǎn)換到SQLSERVER的方法
Access 導(dǎo)入到SQL Server 2005的方法小結(jié)
JavaScript使用ActiveXObject訪問Access和SQL Server數(shù)據(jù)庫
SQL Server數(shù)據(jù)復(fù)制到的Access兩步走

標(biāo)簽：喀什新鄉(xiāng) 朝陽洛陽臺州周口百色朔州

巨人網(wǎng)絡(luò)通訊聲明：本文標(biāo)題《將Access數(shù)據(jù)庫中數(shù)據(jù)導(dǎo)入到SQL Server中的詳細(xì)方法實(shí)例》，本文關(guān)鍵詞將,Access,數(shù)據(jù)庫,中,數(shù)據(jù),；如發(fā)現(xiàn)本文內(nèi)容存在版權(quán)問題，煩請?zhí)峁┫嚓P(guān)信息告之我們，我們將及時(shí)溝通與處理。本站內(nèi)容系統(tǒng)采集于網(wǎng)絡(luò)，涉及言論、版權(quán)與本站無關(guān)。