Interested to Buy Any Domain ? << Click Here >> for more details...
how to connect asp with sql server.......?
Write some code for connectivity between sql server and ASP...
- 2 Answers
- 4304 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / thimmaiah
<%
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
%>
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Explain how to handle error in asp?
what are web handlers?
Explain the life cycle of asp page.
Suppose someone gives a VB dll file (component). How to use that in an ASP file?
What are server variables collection?
i am creating an e-learning site, i want my customers to pay directly through paypall to my paypall account directly from my page ? is it possible ? is there any ready paypall script ?
why we use data bind in asp.net
What are the event handlers of Session Object?
How do I print an aspx file?
IN THREE TIER AMONG THREE LAYERS WHICH ONE IS INDEPENDENT LAYER AND HOW?
what is execution of asp page
How we load the page in ASP?
ASP 
