<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"

how to connect asp with sql server.......?

Write some code for connectivity between sql server and ASP...

Question Posted / abera

2 Answers
4156 Views
I also Faced
E-Mail Answers

Answer Posted / abera

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0
Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html;
charset=windows-1252">
<META content="MSHTML 6.00.2900.2769" name=GENERATOR></HEAD>
<BODY
<%
Set conn=Server.CreateObject("ADODB.Connectiion")
Con.Provider="sql Sever Repulication OLEDB Provider for DTS"
conn.Open "C:/Programfile/Personnel
Records/Switching_Employee.Mdb"
set Rs=Server.createObject("ADODB.Connection")
Rs.OPen "Employee",conn
%>
<Form method="record.asp" action="post">
EmpID:<INPUT><BR>
Fname:<INPUT><BR>
Lname:<INPUT><BR>Position:<INPUT><BR>
Age:<INPUT type=char><BR>
Sex:<SELECT size=select one gender> <OPTION value=Male
selected>Male</OPTION>
<OPTION value=Female>Female</OPTION></SELECT><BR>
Date of birth:<SELECT size=1 date> <OPTION value=1
selected>1</OPTION> <OPTION
value=2>2</OPTION> <OPTION value=3>3</OPTION> <OPTION
value=4>4</OPTION>
<OPTION value=5>5</OPTION> <OPTION value=6>6</OPTION>
<OPTION
value=7>7</OPTION> <OPTION value=8>8</OPTION> <OPTION
value=9>9</OPTION>
<OPTION value=10>10</OPTION> <OPTION value=11>11</OPTION>
<OPTION
value=12>12</OPTION> <OPTION value=13>13</OPTION> <OPTION
value=14>14</OPTION>
<OPTION value=15>15</OPTION> <OPTION value=16>16</OPTION>
<OPTION
value=17>17</OPTION> <OPTION value=18>18</OPTION> <OPTION
value=19>19</OPTION>
<OPTION value=20>20</OPTION> <OPTION value=21>21</OPTION>
<OPTION
value=22>22</OPTION> <OPTION value=23>23</OPTION> <OPTION
value=24>24</OPTION>
<OPTION value=25>25</OPTION> <OPTION value=26>26</OPTION>
<OPTION
value=27>27</OPTION> <OPTION value=28>28</OPTION> <OPTION
value=29>29</OPTION>
<OPTION value=30>30</OPTION> <OPTION value=25>25</OPTION>
<OPTION
value=26>26</OPTION> <OPTION value=27>27</OPTION> <OPTION
value=28>28</OPTION>
<OPTION value=29>29</OPTION> <OPTION
value=30>30</OPTION></SELECT> Month<SELECT
size=1 month> <OPTION value=1 selected>1</OPTION> <OPTION
value=2>2</OPTION>
<OPTION value=3>3</OPTION> <OPTION value=4>4</OPTION>
<OPTION
value=5>5</OPTION> <OPTION value=6>6</OPTION> <OPTION
value=7>7</OPTION>
<OPTION value=8>8</OPTION> <OPTION value=9>9</OPTION>
<OPTION
value=10>10</OPTION> <OPTION value=11>11</OPTION> <OPTION
value=12>12</OPTION></SELECT> Year<SELECT size=1 year>
<OPTION value=1935
selected>1935</OPTION> <OPTION value=1936>1936</OPTION>
<OPTION
value=1937>1937</OPTION> <OPTION value=1938>1938</OPTION>
<OPTION
value=1939>1939</OPTION> <OPTION value=1940>1940</OPTION>
<OPTION
value=1941>1941</OPTION> <OPTION value=1942>1942</OPTION>
<OPTION
value=1943>1943</OPTION> <OPTION value=1944>1944</OPTION>
<OPTION
value=1945>1945</OPTION> <OPTION value=1946>1946</OPTION>
<OPTION
value=1947>1947</OPTION> <OPTION value=1948>1948</OPTION>
<OPTION
value=1949>1949</OPTION> <OPTION value=1950>1950</OPTION>
<OPTION
value=1951>1951</OPTION> <OPTION value=1952>1952</OPTION>
<OPTION
value=1953>1953</OPTION> <OPTION value=1954>1954</OPTION>
<OPTION
value=1955>1955</OPTION> <OPTION value=1956>1956</OPTION>
<OPTION
value=1957>1957</OPTION> <OPTION value=1958>1958</OPTION>
<OPTION
value=1959>1959</OPTION> <OPTION value=1960>1960</OPTION>
<OPTION
value=1961>1961</OPTION> <OPTION value=1962>1962</OPTION>
<OPTION
value=1963>1963</OPTION> <OPTION value=1964>1964</OPTION>
<OPTION
value=1965>1965</OPTION> <OPTION value=1966>1966</OPTION>
<OPTION
value=1967>1967</OPTION> <OPTION value=1968>1968</OPTION>
<OPTION
value=1969>1969</OPTION> <OPTION value=1970>1970</OPTION>
<OPTION
value=1971>1971</OPTION> <OPTION value=1972>1972</OPTION>
<OPTION
value=1973>1973</OPTION> <OPTION value=1974>1974</OPTION>
<OPTION
value=1975>1975</OPTION> <OPTION value=1976>1976</OPTION>
<OPTION
value=1977>1977</OPTION> <OPTION value=1978>1978</OPTION>
<OPTION
value=1979>1979</OPTION> <OPTION value=1980>1980</OPTION>
<OPTION
value=1981>1981</OPTION> <OPTION value=1982>1982</OPTION>
<OPTION
value=1983>1983</OPTION> <OPTION value=1984>1984</OPTION>
<OPTION
value=1985>1985</OPTION> <OPTION value=1986>1986</OPTION>
<OPTION
value=1987>1987</OPTION> <OPTION value=1988>1988</OPTION>
<OPTION
value=1989>1989</OPTION> <OPTION value=1990>1990</OPTION>
<OPTION
value=1991>1991</OPTION> <OPTION value=1992>1992</OPTION>
<OPTION
value=1993>1993</OPTION> <OPTION value=1994>1994</OPTION>
<OPTION
value=1995>1995</OPTION> <OPTION value=1996>1996</OPTION>
<OPTION
value=1997>1997</OPTION> <OPTION value=1998>1998</OPTION>
<OPTION
value=1999>1999</OPTION> <OPTION value=2000>2000</OPTION>
<OPTION
value=2001>2001</OPTION> <OPTION value=2002>2002</OPTION>
<OPTION
value=2003>2003</OPTION> <OPTION value=2004>2004</OPTION>
<OPTION
value=2005>2005</OPTION> <OPTION value=2006>2006</OPTION>
<OPTION
value=2007>2007</OPTION> <OPTION value=2008>2008</OPTION>
<OPTION
value=2009>2009</OPTION></SELECT><br/>
<input type="submit" value="Submit">
<input type="reset" value="Reset">
</form>

</BODY></HTML>

Is This Answer Correct ?

1 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the differences between asp and asp.net and is asp.net backward compatible to asp?

904

Explain the difference between a namespace and an assembly name?

945

Define a scripting language?

914

How do I view an asp file?

831

What is http header?

884

What purpose is served by the application.lock method?

904

Define common type system (cts)?

813

What are the attributes of the tags?

844

How do I convert an aspx file to pdf?

1052

Can be arrays resized by using the keyword redim?

886

Explain what are the methods in session object in asp?

883

What is asp give its application?

1072

What is .asp in html?

938

Explain the difference between the value-type variables and reference-type variables?

875

Define collection?

921