ASP.Net/ADO.net Database/OleDb Insert

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

Insert data into database table

   <source lang="csharp">

<%@ 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>

Using SQL directly

   <asp:Label id="lblStatus" runat="server"/>
 </body>

</html> 

      </source>
Источник — «http://nfex.ru/index.php?title=ASP.Net/ADO.net_Database/OleDb_Insert&oldid=1689»