제목 : 09.DELETE명령실행하기(데이터삭제).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 = "Delete ADOdotNET Where name = 'whiteboll' "
objCommand = New SqlCommand(strQuery, objConnection)
objCommand.ExecuteNonQuery()
objConnection.Close()
%>
<center>ADOdotNET 테이블의 데이터가 삭제되었습니다.</center>