ASP.Net/ADO.net Database/OleDb Insert

Материал из .Net Framework эксперт
Перейти к: навигация, поиск

Insert data into database table

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script language="VB" runat="server">
  Sub Page_Load(Sender As Object, E As EventArgs)
    Dim objConnection As OleDbConnection
    Dim objCmd        As OleDbCommand
    Dim strConnection As String
    Dim strSQL        As String
    
    strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
                    "Data Source=C:\Northwind.mdb"
  
    " Create and open the connection object
    objConnection = New OleDbConnection(strConnection)
    objConnection.Open()
    
    " set the SQL string
    strSQL = "INSERT INTO "Employees" ( "FirstName" , "LastName" )" & _
                      " VALUES ( "Beth" , "Hart" )"
    " Create the Command and set its properties
    objCmd = New OleDbCommand(strSQL, objConnection)
    
    " execute the command
    objCmd.ExecuteNonQuery()
    lblStatus.Text = "Command run"
  End Sub
</script>
<html>
  <body>
    <h2>Using SQL directly</h2>
    <asp:Label id="lblStatus" runat="server"/>
  </body>
</html>
Источник — «http://nfex.ru/index.php?title=ASP.Net/ADO.net_Database/OleDb_Insert&oldid=1689»