Latest

recent

ADO CommandText Property


The CommandText property sets or returns a string that contains a provider command, like a SQL statement, a table name, a relative URL, or a stored procedure call.

Syntax

objcommand.CommandText

Example

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"
set comm=Server.CreateObject("ADODB.Command")
comm.CommandText="orders"
response.write(comm.CommandText)
conn.close
%>

ADO CommandText Property Reviewed by 1000sourcecodes on 09:14 Rating: 5
Powered by Blogger.