Fetching data from User

[itChirag]

Hi I want to know how data is fetched from web page & stored in sql data base. I have the design of webpage but cannot save data in sql table. please help!

[shweta123]

Hi,

What platform are you using? Is it a .Net?

If it is Asp and Sql Server then you can try this code

<%
Dim Con 
Dim Sql
 
Set con=Server.CreateObject("Adodb.Connection")
 
'Here comes your connectionstring
 
Con.ConnectionString = "Provider=SQLOLEDB.1;............ "
 
'Open the connection
Con.open
 
''''''Fetch the values from page e.g.
 
Dim myName
Dim myNo
 
myName = Request.Form("Textbox1")
myNo = Request.Form("Textbox2")
 
 
''''''''Insert data into db.
 
Sql = "Insert into tablename(No,Name) values(myNo,myName)"
 
Con.execute(Sql)
 
Con.close
 
%>