|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Beginner with problems
Help needed <br><br>Trying to teach myself ASP for my new job having trouble getting information from a form to the database looked at lots of different code and I am even more confused than before I started. <br><br>any help would be great<br>Thanks
|
|
#2
|
|||
|
|||
|
Basically, what you do is:
1. Create a connection object 2. Build a connection string (SQL Server: ConnectionString=PROVIDER=MSDataShape;Data Provider=MSDASQL;Driver=SQL Server;Server=MYSERVER;Database=MYDATABASE;UID=MYU SERNAME;PWD=MYPASSWORD;Network=DBMSSOCN; 3. Open this connection 4. Issue an SQL statement against that connection 4a. Eventually open a recordset ad1) set cn = CreateObject(ADODB.Connection) ad2) well, copy it and use your own params ad3) cn.Open ad4) cn.Execute("UPDATE Clients SET blabla")ad4) set rs=CreateObject("ADODB.Recordset") set rs= cn.Execute("SELECT * FROM Clients") |
|
#3
|
|||
|
|||
|
http://www.asp101.com/samples/index.asp
http://www.codeave.com http://www.asp.net/Tutorials/quickstart.aspx Hi I am new to asp too and found these links great help! Also, pick up a few asp books at Amazon. |
![]() |
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > Beginner with problems |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|