<%@ Import NameSpace="System.Data" %>
<%@ Import NameSpace="System.Data.SqlClient" %>

<%
Dim objConnection As SqlConnection
Dim objCommand As SqlCommand
Dim objDataReader As SqlDataReader
Dim strQuery As String

objConnection = New SqlConnection("server=localhost;uid=sa;pwd=;database=ADOdotNET")
objConnection.Open()

strQuery = "Select * From ADOdotNET"

objCommand = New SqlCommand(strQuery, objConnection)
objDataReader = objCommand.ExecuteReader()
While objDataReader.Read()
    Response.Write(objDataReader.Item("name") & "<br>")
End While

objDataReader.Close()
objConnection.Close()
%>

관련 아티클 리스트
	제       목	파일	작성자	작성일	조회
	[C#]Connection 생성	-	레드플러스	2002-10-16	4435
	10.SELECT명령실행하기(데이터질의).aspx		RedPlus	2002-05-03	4070
	09.DELETE명령실행하기(데이터삭제).aspx		RedPlus	2002-05-03	3624