|
|
ASP
Jan 16, 2004 9:05:33 GMT 8
Post by mizz_seven on Jan 16, 2004 9:05:33 GMT 8
ader sesape yang tahu cam ner nak gune ASP?
plezz...kalo sesiapa tahu, tolong bagi skit penerangan...
jasa anda akan di kenang....
|
|
jaga_um
Senior Student
eidolon..eidolon..eidolon... warg..warg..warg... i summon the fire ice...
Posts: 320
|
ASP
Jan 16, 2004 12:19:20 GMT 8
Post by jaga_um on Jan 16, 2004 12:19:20 GMT 8
ader sesape yang tahu cam ner nak gune ASP? plezz...kalo sesiapa tahu, tolong bagi skit penerangan... jasa anda akan di kenang.... ASP itu merupakan teknologi sahaja..yang dimana nama panjang nyer ialah Active Server Pager......camne nak guna 1.Pastikan anda telah meng'on'kan pc anda 2.Pastikan PC anda telah diinstall dgn PWS(Publish Web Server) ngan IIS(Internet Information Server)....nama lain localhost 3.Pastikan anda telah menginstallkan tools yang diperlukan untuk mengkodkan asp..saranan tools adalah seperti berikut i)Macromedia Dreamweaver MX..atau sewaktu ngan dia ii)Microsoft Visual Studio 6.0 iii)Microsoft FrontPage iv)Notepad atau Wordpad atau Microsoft word(Ini kalau dah terer gile babi..sampai babi jadi babi gile...takpun kau sendiri dah gile) 4.Pastikan and telah mahir tentang HTML code(ala balun je bukan penting pun,semua buleh generate) 5. Pastikan anda telah mendapat sedikit pendedahan tentang javascript(bukan java) dan vbscript(bukan VB)... 6. Pastikan anda analisa keperluana database yang diperlukan(jika perlu guna database) 7. Prinsip C mesti anda ada... 8.Kalau ade masalah .....sila la tanya.... |
|
|
|
ASP
Jan 17, 2004 12:43:53 GMT 8
Post by mizz_seven on Jan 17, 2004 12:43:53 GMT 8
ASP itu merupakan teknologi sahaja..yang dimana nama panjang nyer ialah Active Server Pager......camne nak guna 1.Pastikan anda telah meng'on'kan pc anda 2.Pastikan PC anda telah diinstall dgn PWS(Publish Web Server) ngan IIS(Internet Information Server)....nama lain localhost 3.Pastikan anda telah menginstallkan tools yang diperlukan untuk mengkodkan asp..saranan tools adalah seperti berikut i)Macromedia Dreamweaver MX..atau sewaktu ngan dia ii)Microsoft Visual Studio 6.0 iii)Microsoft FrontPage iv)Notepad atau Wordpad atau Microsoft word(Ini kalau dah terer gile babi..sampai babi jadi babi gile...takpun kau sendiri dah gile) 4.Pastikan and telah mahir tentang HTML code(ala balun je bukan penting pun,semua buleh generate) 5. Pastikan anda telah mendapat sedikit pendedahan tentang javascript(bukan java) dan vbscript(bukan VB)... 6. Pastikan anda analisa keperluana database yang diperlukan(jika perlu guna database) 7. Prinsip C mesti anda ada... 8.Kalau ade masalah .....sila la tanya.... tapi kat tempat kite practikal ni pakai MS visual interdev 6.0... tak retila nak pakai...lepas tu nak kena import script dari SQL ... ko tahu tak cam ner nak buat |
|
ikod
Junior Student
Posts: 74
|
ASP
Jan 18, 2004 11:04:55 GMT 8
Post by ikod on Jan 18, 2004 11:04:55 GMT 8
asp hanya boleh digunakan kat window-based saje...so OS lain tak boleh.
|
|
jaga_um
Senior Student
eidolon..eidolon..eidolon... warg..warg..warg... i summon the fire ice...
Posts: 320
|
ASP
Jan 19, 2004 9:04:16 GMT 8
Post by jaga_um on Jan 19, 2004 9:04:16 GMT 8
tapi kat tempat kite practikal ni pakai MS visual interdev 6.0... tak retila nak pakai...lepas tu nak kena import script dari SQL ... ko tahu tak cam ner nak buat Interdev tu microsoft visual 6.0 la...saje je gune nama kuno...tak paham la maksud import script dari sql...selalunyer kite buat sendiri yang buat sendiri script sql tu...cube cite skit kena buat ape... |
|
|
|
ASP
Jan 19, 2004 9:35:42 GMT 8
Post by mizz_seven on Jan 19, 2004 9:35:42 GMT 8
kite nyer supervisor suruh generate report n kena import SQL script yang kite dah buat dalam SQL query analyzer...
from the SQL, dia suruh buat report guna visual interdev....
tu yang aku dapat cope yang dia cakap....
kalo ko ader any idea...tolong la aku yek...
|
|
jaga_um
Senior Student
eidolon..eidolon..eidolon... warg..warg..warg... i summon the fire ice...
Posts: 320
|
ASP
Jan 19, 2004 11:55:03 GMT 8
Post by jaga_um on Jan 19, 2004 11:55:03 GMT 8
kite nyer supervisor suruh generate report n kena import SQL script yang kite dah buat dalam SQL query analyzer... from the SQL, dia suruh buat report guna visual interdev.... tu yang aku dapat cope yang dia cakap.... kalo ko ader any idea...tolong la aku yek... selalu nyer aku main code terus atas dreamweaver..tapi kalau interdev..kau bule buat same cam dreamweaver...sql tu sebenar nyer bahasa unutuk access database..jadi..pastikan sql(structure query language) tu kau guna ngan betul... CTH sqlstr="SELECT * FROM (nama jadual) WHERE (Pernyataan bersyarat..)" sql analyzer tu sebenar nyer macam kompiler..dia nak tgk samada kau punyer sql tu bule jalan ....tapi kalau kau ikut betul-betul sql yang tulih dalam buku pun..dia pasti bule jalan sebab bahasa query language untuk semua jenis pembangunan sistem adalah sama..tak kire database jenis ape pun... |
|
jaga_um
Senior Student
eidolon..eidolon..eidolon... warg..warg..warg... i summon the fire ice...
Posts: 320
|
ASP
Jan 19, 2004 11:55:57 GMT 8
Post by jaga_um on Jan 19, 2004 11:55:57 GMT 8
selalu nyer aku main code terus atas dreamweaver..tapi kalau interdev..kau bule buat same cam dreamweaver...sql tu sebenar nyer bahasa unutuk access database..jadi..pastikan sql(structure query language) tu kau guna ngan betul... CTH sqlstr="SELECT * FROM (nama jadual) WHERE (Pernyataan bersyarat..)" sql analyzer tu sebenar nyer macam kompiler..dia nak tgk samada kau punyer sql tu bule jalan ....tapi kalau kau ikut betul-betul sql yang tulih dalam buku pun..dia pasti bule jalan sebab bahasa query language untuk semua jenis pembangunan sistem adalah sama..tak kire database jenis ape pun... benda nie kalau nak terang kena jumpe..kalau main cakap mesti tak paham nyer..lagi bagus kalau ade laptop |
|
jaga_um
Senior Student
eidolon..eidolon..eidolon... warg..warg..warg... i summon the fire ice...
Posts: 320
|
ASP
Jan 19, 2004 12:03:14 GMT 8
Post by jaga_um on Jan 19, 2004 12:03:14 GMT 8
<!-- #include file="include/dbConnection.asp"-->
<%
'**********************************************************
'This code is been created by Kamarul Anuar b. Abdul Aziz
'Practical Student from Universiti Malaya Kuala Lumpur
'Lend a helping by NorHaslinda bt Abdul Rahman
'Practical student from Kolej Islam Antarabangsa Kuala Lumpur
'**********************************************************
set RS = Server.CreateObject("ADODB.Recordset")
set Masuk = Server.CreateObject("ADODB.Recordset")
set kuma = server.CreateObject("ADODB.Recordset")
set ija = server.CreateObject("ADODB.Recordset")
set linda = server.CreateObject("ADODB.Recordset")
set kozzymint = server.CreateObject("ADODB.Recordset")
RS.Open "SELECT * FROM senarai", con
'******************masuk data**********************************
noSiriSampul = trim(request.form("noSiriSampul"))
PO = trim(request.form("PO"))
namaperisian1 = trim(request.form("namaperisian1"))
namaperisian2 = trim(request.form("namaperisian2"))
namaperisian3 = trim(request.form("namaperisian3"))
namaperisian4 = trim(request.form("namaperisian4"))
namaperisian5 = trim(request.form("namaperisian5"))
namaperisian6 = trim(request.form("namaperisian6"))
namaperisian7 = trim(request.form("namaperisian7"))
namaperisian8 = trim(request.form("namaperisian8"))
namaperisian9 = trim(request.form("namaperisian9"))
namaperisian10 = trim(request.form("namaperisian10"))
namaperisian11 = trim(request.form("namaperisian11"))
namaperisian12 = trim(request.form("namaperisian12"))
namaperisian13 = trim(request.form("namaperisian13"))
namaperisian14 = trim(request.form("namaperisian14"))
namaperisian15 = trim(request.form("namaperisian15"))
'******************************************************
noSiriDisket1 = trim(request.form("noSiriDisket1"))
noSiriDisket2 = trim(request.form("noSiriDisket2"))
noSiriDisket3 = trim(request.form("noSiriDisket3"))
noSiriDisket4 = trim(request.form("noSiriDisket4"))
noSiriDisket5 = trim(request.form("noSiriDisket5"))
noSiriDisket6 = trim(request.form("noSiriDisket6"))
noSiriDisket7 = trim(request.form("noSiriDisket7"))
noSiriDisket8 = trim(request.form("noSiriDisket8"))
noSiriDisket9 = trim(request.form("noSiriDisket9"))
noSiriDisket10 = trim(request.form("noSiriDisket10"))
noSiriDisket11 = trim(request.form("noSiriDisket11"))
noSiriDisket12 = trim(request.form("noSiriDisket12"))
noSiriDisket13 = trim(request.form("noSiriDisket13"))
noSiriDisket14 = trim(request.form("noSiriDisket14"))
noSiriDisket15 = trim(request.form("noSiriDisket15"))
'****************************************************
kuantiti1 = trim(request.form("kuantiti1"))
kuantiti2 = trim(request.form("kuantiti2"))
kuantiti3 = trim(request.form("kuantiti3"))
kuantiti4 = trim(request.form("kuantiti4"))
kuantiti5 = trim(request.form("kuantiti5"))
kuantiti6 = trim(request.form("kuantiti6"))
kuantiti7 = trim(request.form("kuantiti7"))
kuantiti8 = trim(request.form("kuantiti8"))
kuantiti9 = trim(request.form("kuantiti9"))
kuantiti10 = trim(request.form("kuantiti10"))
kuantiti11 = trim(request.form("kuantiti11"))
kuantiti12 = trim(request.form("kuantiti12"))
kuantiti13 = trim(request.form("kuantiti13"))
kuantiti14 = trim(request.form("kuantiti14"))
kuantiti15 = trim(request.form("kuantiti15"))
'888888888888888888888888888888888888888888888888888
kuantiti = trim(request.form("kuantiti"))
pembekal = trim(request.form("pembekal"))
modelCPU = trim(request.form("modelCPU"))
nama = trim(request.form("jabatan"))
do while not RS.EOF
if RS("noSiriSampul")<>noSiriSampul then
RS.Movenext
else
session("alert") = "Data yang dimasukkan telah wujud di dalam database"
response.Redirect("formagree.asp")
end if
loop
'*****************************masuk dalam senarai
Masuk.Open "SELECT * FROM senarai ",con,2,2
Masuk.AddNew
Masuk("namaperisian1") = namaperisian1
Masuk("noSiriSampul")=noSiriSampul
Masuk("noSiriDisket1")=noSiriDisket1
Masuk("PO")=PO
Masuk("kuantiti")=kuantiti
Masuk("pembekal")=pembekal
Masuk("modelCPU")=modelCPU
Masuk("nama")=nama
Masuk.Update
Masuk.Close
'**************************masuk dalam pinjam******************
kuma.Open "SELECT * FROM pinjam",con,2,2
kuma.AddNew
kuma("noSiriSampul")=noSiriSampul
kuma("nama")= nama
kuma.Update
kuma.close
'**************************masuk dalam perisian***********
ija.Open "SELECT * FROM perisian",con,2,2
ija.AddNew
ija("noSiriSampul")= noSiriSampul
ija("namaperisian1")= namaperisian1
ija("namaperisian2")= namaperisian2
ija("namaperisian3")= namaperisian3
ija("namaperisian4")= namaperisian4
ija("namaperisian5")= namaperisian5
ija("namaperisian6")= namaperisian6
ija("namaperisian7")= namaperisian7
ija("namaperisian8")= namaperisian8
ija("namaperisian9")= namaperisian9
ija("namaperisian10")= namaperisian10
ija("namaperisian11")= namaperisian11
ija("namaperisian12")= namaperisian12
ija("namaperisian13")= namaperisian13
ija("namaperisian14")= namaperisian14
ija("namaperisian15")= namaperisian15
ija.Update
ija.close
'******************************masuk dalam noSiriDisket********
linda.Open "SELECT * FROM noSiriDisket",con,2,2
linda.AddNew
linda("noSiriSampul")=noSiriSampul
linda("noSiriDisket1")=noSiriDisket1
linda("noSiriDisket2")=noSiriDisket2
linda("noSiriDisket3")=noSiriDisket3
linda("noSiriDisket4")=noSiriDisket4
linda("noSiriDisket5")=noSiriDisket5
linda("noSiriDisket6")=noSiriDisket6
linda("noSiriDisket7")=noSiriDisket7
linda("noSiriDisket8")=noSiriDisket8
linda("noSiriDisket9")=noSiriDisket9
linda("noSiriDisket10")=noSiriDiske10
linda("noSiriDisket11")=noSiriDisket11
linda("noSiriDisket12")=noSiriDisket12
linda("noSiriDisket13")=noSiriDisket13
linda("noSiriDisket14")=noSiriDisket14
linda("noSiriDisket15")=noSiriDisket15
linda.Update
linda.close
'********************************masuk dalam kuantitiperisian*************
kozzymint.Open "SELECT * FROM kuantitiperisian",con,2,2
kozzymint.AddNew
kozzymint("noSiriSampul")=noSiriSampul
kozzymint("kuantiti1")=kuantiti1
kozzymint("kuantiti2")=kuantiti2
kozzymint("kuantiti3")=kuantiti3
kozzymint("kuantiti4")=kuantiti4
kozzymint("kuantiti5")=kuantiti5
kozzymint("kuantiti6")=kuantiti6
kozzymint("kuantiti7")=kuantiti7
kozzymint.Update
kozzymint.close
set kozzymint = nothing
set linda = nothing
set ija = nothing
set kuma = nothing
Set Masuk=nothing
Set RS=nothing
session("alert") ="Data Ini telah dimasukkan ke dalam pangkalan data"
response.Redirect("formagree.asp")
'***************Bahagian untuk masukkan data
%>
yang mane ade select tu la contoh sql language
|
|
|
|
ASP
Jan 19, 2004 15:28:05 GMT 8
Post by mizz_seven on Jan 19, 2004 15:28:05 GMT 8
oo...yang maner ader select from where tu kire SQL la...
em...walaupun quite complicated, tapi leh la 10% faham..
anyway thanx jaga_um....
|
|
|
|
ASP
Jan 19, 2004 15:54:11 GMT 8
Post by enigma on Jan 19, 2004 15:54:11 GMT 8
kamarul anuar@kozzymind..
camna plak kalo nk buat system login 7 password?
kena guna dbase gak ker?
|
|
Qhas _da best
Senior Student
kelalaian itu kegelapan, kejahilan itu kesesatan, kesabaran itu ketenangan, fikirlah wahai teman!!!!
Posts: 374
|
ASP
Jan 19, 2004 16:41:24 GMT 8
Post by Qhas _da best on Jan 19, 2004 16:41:24 GMT 8
kamarul anuar@kozzymind.. camna plak kalo nk buat system login 7 password? kena guna dbase gak ker? akum... koozy yg suruh tanya.. login 7 pasword plak mcm mn? chracter 7 ke, atau pun password tu 7? kalu leh postlah kod tu ... aku nak nengok mcm mn rupe bentuknyaer... baru kozzy leh bgtau ko.... |
|
Saiyan
Junior Student
Posts: 87
|
ASP
Jan 19, 2004 16:43:54 GMT 8
Post by Saiyan on Jan 19, 2004 16:43:54 GMT 8
wei..comand2 tu jangan la tukar ke b.melayu...nampak peliklaaaa  |
|
Saiyan
Junior Student
Posts: 87
|
ASP
Jan 19, 2004 16:46:16 GMT 8
Post by Saiyan on Jan 19, 2004 16:46:16 GMT 8
if korang slalu try asp tu..mesti bole punye
|
|
Qhas _da best
Senior Student
kelalaian itu kegelapan, kejahilan itu kesesatan, kesabaran itu ketenangan, fikirlah wahai teman!!!!
Posts: 374
|
ASP
Jan 19, 2004 16:48:21 GMT 8
Post by Qhas _da best on Jan 19, 2004 16:48:21 GMT 8
akum.. command aper yg tuka bhs melayu.. kalau dlm bhs melayu tu pemboleh ubah......... ;D
|
|
