제목 : 08.UPDATE명령실행하기(데이터갱신).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 = "Update ADOdotNET Set name = 'whiteboll' "
objCommand = New SqlCommand(strQuery, objConnection)
objCommand.ExecuteNonQuery()
objConnection.Close()
%>
<center>ADOdotNET 테이블에 데이터가 수정되었습니다.</center>