ASP and MS SQL

[aarushi2001]

Hi Guys,

I have been working on this problem since morning and can not find any where solution.

I have a form. When a user hits submit, the information should be stored in a table. I am using MS SQL.

Can someone please provide me with a dummy program on how to 'insert' information?

 

[damber]

Google is your friend...........

try "SQL INSERT ASP" as the keywords.. you'll be surprised at what you find.

http://www.w3schools.com

is also a useful site for beginners and will answer your question



A smile is worth a thousand kind words. So smile, it's easy!

 

[DotNetGnat]

something like this:

<%
Dim conn, sql
set conn = server.createobject("ADODB.Connection")
conn.open "your connection string here"
sql = " insert into mytable(field1,field2)"&_
      " Values('"request.form("val1")&"',"&_
      " '"&request.form("val2")&"'"
conn.execute(sql)
%>

but as damber suggested...do a search on google for more resources...

-DNG

 

[aarushi2001]

I did do google search before asking for help.. but I get access stuff..

n to be honest I did write the code.. its just not executing.. it gives an error.. n it sems perfectly fine..

thanks for ur help

 

[DotNetGnat]

then it would have been better that you showed us your code and also told us what error you were getting...there are many great people in this forum and i am sure that you would have got the answer already...

i would suggest you to read the FAQ that describes about how to post your question...i am not sure about the FAQ number...so please check it in the FAQ section...

-DNG

 

[damber]

aarushi2001

I did do google search before asking for help.. but I get access stuff..

OK, I'll type the words I noted above into Google for you and provide the link......

http://www.google.com/search?client=opera&rls=en&q=SQL+INSERT+ASP&sourceid=opera&ie=utf-8&oe=utf-8

You might want to read the VERY FIRST ARTICLE in the results.

Laziness will only proliferate stupidity.... Be one of the clever people, and take a bit of initiative.


A smile is worth a thousand kind words. So smile, it's easy!

 

[onpnt]

how about 2,940,000 hits

http://www.google.com/search?hl=en&q=sql+server+asp+insert

General FAQ faq333-2924
5 steps to asking a question faq333-3811

 

[onpnt]

alright, your 4,070,000 wins the count

Laziness will only proliferate stupidity.... Be one of the clever people, and take a bit of initiative.

I like that one. Think I may need a new signature


General FAQ faq333-2924
5 steps to asking a question faq333-3811