<!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
4324 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

How do you initialize a two-dimensional array that you don't know the dimensions of?

1061

How many types of report in asp.net 2008?

2303

What does asp stand for?

975

What is asp used for?

988

why and how static variable retain their value after postback form ?

2797

What is an asp program?

971

What are asp controls?

991

When did classic asp come out?

1001

Name the event handlers of application object?

1069

by puting attendance to students if he absent tat should intimate to his fathers mobile automatically anybody having code send to me

1810

Where we get good training and LABS facility In C#.net courses in Hyderabad, I completed the classes in Peers even though im sure in good practice to get right position in jobs please help me who no well in this field?

2132

How to make page break in Crystal Report..?

2001

What are the different types of html?

1014

what is stored procedural

2387

Define a variable in asp?

989