472,325 Members | 1,379 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,325 software developers and data experts.

submitting data to a database using asp

hi,

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

thanks and God bless
Nov 12 '06 #1
4 1332
willakawill
1,646 1GB
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 :)
Nov 12 '06 #2
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
Nov 12 '06 #3
willakawill
1,646 1GB
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.
Nov 12 '06 #4
karthi84
271 100+
this code should help u
Expand|Select|Wrap|Line Numbers
  1. strConn1="PROVIDER=SQLOLEDB;SERVER=servername;UID=userid;PWD=pass;DATABASE=dbname"
  2. Set objConn1= Server.CreateObject("ADODB.Connection")
  3.   objConn1.Open strConn1
  4. strSQL1 = "insert into table_name set Credit_Notes="Credit_Notes", Last_Update_By="Last_Update_By              
  5.  
  6.  
  7. objConn1.Execute(strSQL1)
  8.  
any problem with the code post me a personal message so that i can help you
Dec 29 '06 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

14
by: windandwaves | last post by:
Hi Folk This question has been bugging me for month. I have a website where people can enter stuff into a mysql database. Some of this...
5
by: Don | last post by:
I have a need to submit a form, but don't need the user to click on a button. How do I do this? Is there some way, using JavaScript, to setup a...
1
by: Johnny | last post by:
Hello, I've read somewhere that you can validate form data before actually submitting it, similar to what validation controls would do. For...
0
by: Marc DVer | last post by:
I am at kind of a loss on how to design a certain database project I am working on. Basically, we have a proprietary program with a standard...
2
by: Syam | last post by:
Hello everyone, I am just barely two months old into learning asp.net and vb.net. Currently I am working on a project to store customer database....
2
by: ickwong | last post by:
Hi guys! I'm a complete beginner of this and have just started learning scripting recently therefore I hope anyone here could give me some help. ...
4
by: somaskarthic | last post by:
Hi I posted query about dynamically generating php code. Sorry for the inconvenience . I didn't given you the php code. Its just javascript code...
1
by: SachinBhargava | last post by:
Hi, I am faceing the problem while submitting the same page in ASP. When i am submitting the page, I am showing the java script alert message before...
7
by: bettor | last post by:
Hi guys, I have some text inputs which I would like to submit to a database via PHP using ajax. What i want to do is when the submit button is...
1
by: asp beginner | last post by:
I am building an Eccomerce site and I am trying to make my shopping cart work. I am having a problem with when I have entered data into my form it is...
0
by: tammygombez | last post by:
Hey fellow JavaFX developers, I'm currently working on a project that involves using a ComboBox in JavaFX, and I've run into a bit of an issue....
0
by: tammygombez | last post by:
Hey everyone! I've been researching gaming laptops lately, and I must say, they can get pretty expensive. However, I've come across some great...
0
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
0
better678
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
0
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
0
by: CD Tom | last post by:
This happens in runtime 2013 and 2016. When a report is run and then closed a toolbar shows up and the only way to get it to go away is to right...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
0
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
0
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.