how to connect database connectivity in dotNET? if suppose
SQL server?and also MS access?

Answer Posted / varun

in the sql server

using system.data.sqlclient
sqlconnection con=new
sqlconnection("server=;uid=;pwd=;database=;");
con.open();

Ms-Access:

Namespace->using system.data.oledb;

oledbconnection con=new oledb connection
("Servername="";uid="";pwd="";database="")

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain dataset.acceptchanges and dataadapter.update methods in .net?

555


Explain .NET architecture?

622


Explain the differences between server-side code and client-side code.

569


Please explain what is a delegate?

691


Difference between class and interface in .net?

591






Is .net a language?

562


Is Driver Script any how related to AOM?

616


Compare client server application with n-tier application

510


Explain the difference between static page and dynamic page?

548


What are the different types of Classes in .NET?

607


Can I write my own .net host?

613


How can I get at the win32 api from a .net program?

566


What is RCW (Run time Callable Wrappers)?

1958


Explain how garbage collection works?

571


What is shared and repeatable inheritance?

551