в 15:30, 26 мая 2010

2010-05-26T15:30:47Z

Admin: 1 версия

2010-05-26T11:51:10Z

1 версия

Новая страница

==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>
<h2>Using SQL directly</h2>
<asp:Label id="lblStatus" runat="server"/>
</body>
</html>

</source>

← Предыдущая	Версия 15:30, 26 мая 2010
(нет различий)

ASP.Net/ADO.net Database/OleDb Insert - История изменений

в 15:30, 26 мая 2010

Admin: 1 версия