SQL va ASP

[parshia]

salam agar mikhahid keh az SQL dar barnameh haye khod estefadeh konid, bayad aval
(Installing MySQL server and MyODBC)
www.mysql.com keh man farz mikonam keh shoma raveshe DOwnload va nasb ro baladid
va shoam nabayad az noshkheh haye gheiyre motbar estefadeh konid, choun momkeneh badaz modaty dochare moshkel beshid, va digeh etelaat ghabele baz gasht nist
agar az mohite Windows estefadeh mikonid,shoma be MyODBC niyaz darid(ama na 100 darsad in yeki az ravesha hast)zirakeh az OLE,... ham misheh estefadeh kard
setup ro ejra konid, va hameh chio dar halate default bezarid bemouneh
.sepas barnameh mysql.exe ra az folder mysql\bin RUN konid
agar ba Microsoft SQL server ashnaie kamel darid, pishnahad mikonam keh az http://www.dbtools.com.br/ estefadeh konid
--------------------------------
marhaleh dovom bayad (Connection String)ra benevisim
ghabl az har chiz bayad ma Connection String khodemono tarif konim.
(behtarin tamirin, tarif kardane an dar file(global.asa
ast.
va be onvane subroutine misheh az Application variable
estefadeh kard.
HALA bayad in SUB ro be souraty keh ba SQL shoma ham khani darad taghir dahid(va in yek formoule kolie hast keh bana beniyaze shoma meghdar dehi mishavad)ke:


Sub Application_OnStart
Application("DBCONN")="Driver={MySQL};SERVER=localhost;DATABASE=xxx; UID=xxx;PWD=xxx;Extended Properties='OPTION=16387'"
End Sub
---------yadetoun nareh keh ----
shoma bayad (SERVER) va(DATABASE) va (UID) va(PWD ) ra bana beniyaz khodetoun tarif konid, ama dar in mesal moshkeli pish nemiyad
***************************
agar dar inja az OPTION=16387 estefadeh nakonid, peyghame "Multiple-step operation generated errors" ra khahid did

 

[parshia]

ama hanouz karemoun tamoum nashodeh balkeh bayad ye object hm dashteh bashim , pas miresim be marhakleh (Connection Handling) keh
bayad yek OBJ sakht va be data vaslesh kard, va bad az on anra baz kard
pas misheh be onvane mesal az nemouneh kode zir estefadeh kard
---
"openconn.inc"
keh abra tahte onvane openconn.inc misheh save kardesh
pas migim :


%>

Set myConn = Server.CreateObject("ADODB.Connection
("

myConn.open(Application("DBCONN
(("

<٪


hala bayad bastesh
"closeconn.inc"
%>
myConn.close
Set myConn=Nothing
<%
***
ba farze inkeh raveshe estefadeh az
INCLUDE
ra balad hastim forme zir ra be delkhah por mikonim



<!-- #include file="openconn.inc" -->
%>
...
... code
...

<%
<!-- #include file="closeconn.inc" -->
*******
hala misheh az (Accessing data)ham estefadeh kard
Set MyResultSet = MyConn.Execute("SELECT * FROM
("...

---va agar bekhahim az "RecordCount
estefadeh konim bayad aval "CursorLocation "ra be sourate RecordSet ba value adUseClient dashteh bashim
inam kodesh

("
Set MyResultSet = Server.CreateObject("ADODB.recordset
MyResultSet.CursorLocation = adUseClient
MyResultSet.Open "SELECT * FROM ...", myconn
*****

 

[parshia]

("..set MainQuery = MyConn.Execute("SELECT * FROM ... WHERE

("
set CountQuery = MyConn.execute("SELECT COUNT(*) FROM ... WHERE

(Count = CountQuery(0
set CountQuery = nothing
-------inam baraye AddNew yar Update

Set CheckCateg = Server.CreateObject("ADODB.recordset
("
CheckCateg.Open "SELECT * FROM ...", myconn, , adLockOptimistic
***
"

 

[parshia]

omid varam keh in matlab bedarde shoma khordeh basheh
va dar enteha mikham begam keh inja code nevisi be tarze vahshat naki sakhteh , va hamash code haro beham mirizeh agar kasi rahe behtari mitouneh pishnahad koneh mamnounmisham vagar na baraye man maghdour nist keh zamane ziyadio baraye neveshtane in code ha sarf konam, kami mordam

 

[giahchin]

دوست عزيز ،
من كه در رابطه با مشكلت در لينك زير توضيح دادم :
http://forum.majidonline.com/viewtopic.php?p=23316#23316

به هر حال امتحانش ضرري نداره

 

[parshia]

دوست عزيز ،
من كه در رابطه با مشكلت در لينك زير توضيح دادم :
http://forum.majidonline.com/viewtopic.php?p=23316#23316

به هر حال امتحانش ضرري نداره

mamnounam shoma ham yebare digeh in ravesho eraeh dadeh boudid, va manam baestefadeh az in ravesh be natijeh ie ham naresidam, man vaghty ham keh dar notepad minevisam baz ham vaghty copy mikonam eshtebah misheh

movafagh bashid

 

[parshia]

[

quote="parshia"]

دوست عزيز ،
من كه در رابطه با مشكلت در لينك زير توضيح دادم :
http://forum.majidonline.com/viewtopic.php?p=23316#23316

به هر حال امتحانش ضرري نداره
quote]

ageh doust dashtid be inadres sar bezanid, man az hamin raveshe pishnahadi shoma estefadeh kardam
ama natijeh?
http://forum.majidonline.com/viewtopic.php?p=24458#24458

 

[giahchin]

سلام ،
آقا يا لينكي كه دادي اشتباه بود يا اينكه اون روش استفاده نشده :!:
در اون روش كد شما بايد در يك كادري با رنگ روشن تر در نامه قرار بگيره
اينطوري :

My Code
My Code