How would u connect to database using .NET?

Answers were Sorted based on User's Feedback



How would u connect to database using .NET?..

Answer / rajeev ranjan lall

SqlConnection conn = new SqlConnection("Data
Source=ServerName;Initial Calalog=DatabaseName;User
ID=username;Password=password")

Is This Answer Correct ?    15 Yes 1 No

How would u connect to database using .NET?..

Answer / ramakrishna

sqlconnection cn =new sqlconnection("uid=sa;pwd=sa;data
source=servername;database=databasename");

Is This Answer Correct ?    8 Yes 2 No

How would u connect to database using .NET?..

Answer / vivek

using Connection object
SqlConnectin cn=new SqlConnection();
from .net we can connect to any backend with middlleware
and direct connections.
middleware means ODBC,OleDb,ISAM etc.
we can directly connect to Sqlserver and Oracle
we can connect to sql server in 4 ways
1)direct connection
2)ODBC way
3)OleDb way
4)Express way
for oracle we can connect in 3 ways.
1)direct connection
2)ODBC way
3)OleDb way

Is This Answer Correct ?    0 Yes 0 No

How would u connect to database using .NET?..

Answer / lalitkumar

sqlconnection con=new
sqlconnection("@server=.sqlexpress;database=master;trusted_connection=yes")

Is This Answer Correct ?    0 Yes 0 No

How would u connect to database using .NET?..

Answer / rathish

go to project->add reference->adodb

DECLERATION

Dim con As ADODB.Connection
Dim cmd As ADODB.Command
Dim str, cnstr, sql As String
Dim cn As OleDb.OleDbConnection


FORM LOAD

Private Sub Form1_Load(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles MyBase.Load
con = New ADODB.Connection
con.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\new folder\employee.mdb")
End Sub

in the source you have to give the path of ur file name..

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More ADO.NET Interview Questions

What is reference by value how does it works in .net?

2 Answers   SQL Star,


What does adodb stand for?

0 Answers  


What are the key features of ado.net?

0 Answers  


Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?

0 Answers  


Which database is the ado.net?

0 Answers  


What is full form of ado?

0 Answers  


What are the rules to implement connection pooling?

0 Answers  


What are disadvantages of microsoft-provided data provider classes in ado.net?

0 Answers  


Which is faster datareader or dataadapter?

0 Answers  


What do you know about ado.net's objects?

0 Answers  


Does ado.net use odbc?

0 Answers  


Which object is used to add relationship between two Datatables?

0 Answers  


Categories