ASP.Net与数据库的连接方法 - 好技术学习网-|好技术|IT|建站|学习|网站|特效|图形|图象|网络|编程|教程|下载|数据库|web|wap|asp|jsp|html|java|.net|sql|oracle|mysql|photoshop|Dreamweaver|Flash|Fireworks|css

一、ASP.Net与Access数据库连接：
<%@ Import Namespace="system.data.oledb" %>
<%@ Import Namespace="system.data" %>
<%@ Import Namespace="System.IO" %>
<%
Dim dbconn as OledbConnection
dbconn = new OledbConnection("provider=microsoft.jet.oledb.4.0;data source="&server.MapPath("XXX.mdb"))
%>

<%@ Import Namespace="system.data.oledb" %>
<%@ Import Namespace="system.data" %>
<%@ Import Namespace="System.IO" %>
<%
Dim dbconn as OledbConnection
dbconn = new OledbConnection("provider=sqloledb;server=主机名称;initial catalog=数据库名称;user id=XXX;password=XXX;")
%>

<%
Dim i as integer
Dim sql as OledbDataAdapter
Dim ds as new dataset
sql = new OledbDataAdapter("select * from contact",dbconn)
sql.fill (ds,"guest")
%>

asp.net连接Access数据库例子

asp.net连接Access数据库

<%@ Import Namespace="System.Data" %>
    <%@ Import NameSpace="System.Data.OleDb" %>
    <script laguage="VB" runat="server">
    Dim myConnection As OleDbConnection
    Dim myCommand As OleDbCommand
    sub page_load(sender as Object,e as EventArgs)

    '1.连接数据库
    dim dbname as string
    dbname=server.mappath("authors.mdb")
    myConnection = New OleDbConnection( "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source="&dbname )
    myConnection.Open()
    la1.text="Connection Opened!"

    '2.添加记录
    myCommand = New OleDbCommand( "Insert INTO Authors(Authors,country) Values('Simson','usa')", myConnection )
    myCommand.ExecuteNonQuery()
    la2.text="New Record Inserted!"

    '3 更新数据(Access)
    myCommand = New OleDbCommand( "UPDATE Authors SET Authors='Bennett' WHERE Authors = 'Simson'", myConnection )
    myCommand.ExecuteNonQuery()
    la3.text="Record Updated!"

    '4 删除数据（access）
    myCommand = New OleDbCommand( "DELETE FROM Authors WHERE Authors = 'David'", myConnection )
    myCommand.ExecuteNonQuery()
    la4.text="Record Deleted!"

    '5 使用DateGrid显示数据
    myCommand = New OleDbCommand( "select * FROM Authors", myConnection )
    MyDataGrid.DataSource=myCommand.Executereader()
    MyDataGrid.DataB

[1] [2] 下一页