how to connect asp with sql server.......?
Write some code for connectivity between sql server and ASP...
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 |
Actually i downloaded Ajax news flash module but i am having issues enabling it on my site. need help.
How do I change a aspx file to a pdf?
How many global.asa files can an Application have?
Define a class in css?
How do in-process and cross-process communication work in the common language runtime?
What are ARRAYS?
Explain the order of precedence for logical operators.
Hii My Question is How the Down Payment will clear in APP? Can any one help me
What is aspx format?
What is the difference between the value-type variables and reference-type variables
Name the command to display characters to the html page?
What is aspx cs file?