Asp.net连接Access数据库的方法

最新推荐文章于 2014-06-30 17:06:00 发布

qingxizhao

最新推荐文章于 2014-06-30 17:06:00 发布

阅读量1k

点赞数

分类专栏： .NET 文章标签： access 数据库 asp.net datagrid server asp

.NET 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

<%@ 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("数据库名.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 表名(字段1,字段2) Values('值1','值2')", myConnection )
myCommand.ExecuteNonQuery()
la2.text="New Record Inserted!"

'3 更新数据(Access)
myCommand = New OleDbCommand( "UPDATE 表名 SET 字段1='值1' WHERE 字段2 = '值2'", myConnection )
myCommand.ExecuteNonQuery()
la3.text="Record Updated!"

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

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

end sub
</script>