제목 : 07.INSERT명령실행하기(데이터삽입).aspx
<%@ Import NameSpace="System.Data" %>
<%@ Import NameSpace="System.Data.SqlClient" %>
<%
Dim objConnection As SqlConnection
Dim objCommand As SqlCommand
Dim strQuery As String
objConnection = New SqlConnection("server=localhost;uid=sa;pwd=;database=ADOdotNET")
objConnection.Open()
strQuery = "Insert ADOdotNET(name) Values('RedPlus')"
objCommand = New SqlCommand(strQuery, objConnection)
objCommand.ExecuteNonQuery()
objConnection.Close()
%>
<center>ADOdotNET 테이블에 데이터가 입력되었습니다.</center>