Henry的专栏

讓夢想飛得更高……

用户操作

[留言] [发消息] [加为好友]

订阅我的博客

[编辑]henry365的公告

本專欄的文章大部分是從網絡上收集，只為個人學習之用，如果所帖的文章涉及到閣下的權利，請聯系指出，我會第一時間處理，謝謝。

[编辑]文章分类

[编辑]技术

初识Web2.0

存档

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("数据库名.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>

<html>
<body>
<asp:label id="la1" runat="server" /><br>
<asp:label id="la2" runat="server" /><br>
<asp:label id="la3" runat="server" /><br>
<asp:label id="la4" runat="server" /><br>
<ASP:DataGrid id="MyDataGrid" runat="server"
    BorderColor="black"
    BorderWidth="1"
    GridLines="Both"
    CellPadding="3"
    CellSpacing="0"
    Font-Name="Verdana"
    Font-Size="10pt"
    HeaderStyle-BackColor="#aaaadd"
    AlternatingItemStyle-BackColor="#eeeeee"
    >
</asp:DataGrid>

</body>
</html>