sample source of asp(connection and recordset) with sql

[parsa56]

با سلام

دوستان عزيز

من احتياج به يك sample source of asp(connection and recordset) with sql دارم

اگر امكان دارد من را ياري كنيد.

با تشكر :wacko:

[email protected]

 

[reza9]

<%
dim conn,rs,sql
set conn = server.createobject("adodb.recordset") 'create a connection name CONN
set rs = server.createobject("adodb.recordset") ' create a recordset named RS
conn.connectionstring = "DSN=" ' put DSN after = and before "
sql = "select * from table name"
rs.open sql,conn

'here we have a table on RS
%>

good luck !

 

[reza9]

ببخشید در خط 2 اشتباه شده این یکی صحیحه

<%
dim conn,rs,sql
set conn = server.createobject("adodb.connection") 'create a connection name CONN
set rs = server.createobject("adodb.recordset") ' create a recordset named RS
conn.connectionstring = "DSN=" ' put DSN after = and before "
sql = "select * from table name"
rs.open sql,conn

'here we have a table on RS

 

[parsa56]

dear reza

tanx for U'r help