Cammaner Nk Save Data To Dtbase

[kowmeng 0]

cammaner nk save data masuk ke dtbase erk?aku gune language VB in asp.net2.0 n baru lg dlm prgaming nih..pls help!! aku da design form registration

tp nk bubuh coding tu yg poblem ckit boleh postkn coding save data x?maksunye dkat class ape coding spatutnye nk letak and kt aspx.vb coding ape perlu diletakkn.. pls help..

[thalz142 0]

cammaner nk save data masuk ke dtbase erk?aku gune language VB in asp.net2.0 n baru lg dlm prgaming nih..pls help!! aku da design form registration

tp nk bubuh coding tu yg poblem ckit boleh postkn coding save data x?maksunye dkat class ape coding spatutnye nk letak and kt aspx.vb coding ape perlu diletakkn.. pls help..

dim dbconn,sql,dbcomm

dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;

data source=" & server.mappath("northwind.mdb"))

dbconn.Open()

sql="SELECT * FROM customers"

dbcomm=New OleDbCommand(sql,dbconn)

understand this code pls...

hth

[kowmeng 0]

dim dbconn,sql,dbcomm

dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; 'yang jet OLEDB4.0 ni aku rase utk pilih jnis dtbase yg nk dipakai kot..btul x? klu x silap dlu mase gune VB and dtbase acces ade gune OLEDB 4.0 nih

data source=" & server.mappath("northwind.mdb")) 'server.mappath ni name initial catalog database kn..btul x?

dbconn.Open()'yang ni open connection string...btul x? contoh dim dbcon as new sqlconnection("data source=server name;initial catalog=dtbase name;integrated security=SSPI")

sql="SELECT * FROM customers" 'yang ni lak select from table name dtbase kite...btul x?

dbcomm=New OleDbCommand(sql,dbconn)'yang dbcomm ni arahan sql stetement utk call data from dtbase.btul x?

bole x bg simple system utk registration yg bole jalan kn function Add Save Delete Update...xpn contoh coding utk function 4 function 2..kt mane spatutnye tmpt yg perlu utk ltak coding 2...cth kt dlm aspx.vb kt page load nk ltak code ape,kt event procedure utk btton Save nk ltak code ape and dkat class klu ade code lg nk diletak,code ape yg perlu?.kire mcm tu la...masalah sy skg ni nk ltak coding tu yg x pandai...klu coding pulak pn suam2 lg...

*for ur information this is not purpose for final project..TP sy nk Study sdiri coz sy br study web design..so nnti klu da tau coding baru la sy bleh bwat satu system yg lgkap...design +Coding

sory klu sume soalan aku ni bunyinye agak bodoh bg korg yg da expert...

understand this code pls...

hth

[kowmeng 0]

ok la aku da dapat dah code save 2....

kepade otai2 dotnet...bleh tolong explain x function fix kt bwah ni utk ape sbenanyer?aku dpt from planetsourcecode...aku gune utk wat function save data to dtbase and it working..lg satu ExecuteScalar tu amende erk?mintak penjelasan ckit..

Function fix(ByVal semak As String)

fix = Replace(semak, "'", "''")

End Function

============================================================

==================

str1 = "SELECT COUNT(*) FROM [studentInfo] where [username]='" & fix(txtUsername.Text) & "'"

str2 = "INSERT INTO [studentInfo] ([Name],[iCNumber],[Address],[username],[Password])"

str2 = str2 & "VALUES" ' Utk assign value sebab nak simpan

str2 = str2 & "('" & Fix(txtName.Text) & "','" & Fix(txtIcNumber.Text) & "','" & Fix(txtAddress.Text) & "','" & Fix(txtUsername.Text) & "','" & Fix(txtPassword.Text) & "');"

dbCon.Open()

check = New SqlCommand(str1, dbCon)

strcount = check.ExecuteScalar ///ni utk ape erk yg executeScalar ni??

Edited October 19, 2008 by kowmeng