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

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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

textbox has viewstate property,but it does not depend on its property to retain their data across page,Explain.

1433


Define a form collection?

732


sir,please send me the NIC exam questions

1677


What purpose is served by the application.lock method?

720


Explain the difference between inline and code behind.

688






how u can use asp.net for making website?

1750


difference between html and asp?

2181


Explain what are the attributes of the tags? What are their functions?

692


Define application object?

660


Should user input data validation occur server-side or client-side?

659


. which tag i need to use manually to bind columns in a datagrid ?

1782


How do you make it so that code runs when the security system is stopping it?

714


How do I open aspx files?

728


What are the tasks performed by <> tags?

670


when we use ajax in.net

1607