submitting data to a database using asp

[giwababatunde]

hi,

can anybody put me through on how to use asp to submit data into the date base.

thanks and God bless

[willakawill]

hi,

can anybody put me through on how to use asp to submit data into the date base.

thanks and God bless

Hi. You will have to learn about ADO connections and recordsets. This is quite a lot to learn so give yourself some time :)

[vabsjava]

HI!
You should try this.......
but for the explanation u should refer some book


set conn= Server.CreateObject("ADODB.Connection")
set RS = Server.CreateObject("ADODB.Recordset")
db.Open "DSN=mydsn;UID=username;PWD=password“
SQL = "select * from tb_usr“
set rs = conn.execute(SQL)
rs.MoveFirst
do while NOT rs.eof
Response.Write rs("usrid") & “," & rs("usrpwd") & "<br>"
rs.MoveNext
loop
set conn = nothing
set RS = nothing

Have a nice Day

hi,

can anybody put me through on how to use asp to submit data into the date base.

thanks and God bless

[willakawill]

HI!
You should try this.......
but for the explanation u should refer some book


set conn= Server.CreateObject("ADODB.Connection")
set RS = Server.CreateObject("ADODB.Recordset")
db.Open "DSN=mydsn;UID=username;PWD=password“
SQL = "select * from tb_usr“
set rs = conn.execute(SQL)
rs.MoveFirst
do while NOT rs.eof
Response.Write rs("usrid") & “," & rs("usrpwd") & "<br>"
rs.MoveNext
loop
set conn = nothing
set RS = nothing

Have a nice Day

Unfortunately the question is about submitting data to a database and not writing data from a database to a page.

[karthi84]

this code should help u

strConn1="PROVIDER=SQLOLEDB;SERVER=servername;UID=userid;PWD=pass;DATABASE=dbname"
Set objConn1= Server.CreateObject("ADODB.Connection")
  objConn1.Open strConn1
strSQL1 = "insert into table_name set Credit_Notes="Credit_Notes", Last_Update_By="Last_Update_By              
 
 
objConn1.Execute(strSQL1)
 

any problem with the code post me a personal message so that i can help you