Answer / rajeev ranjan lall

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

Answer / ramakrishna

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

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

Answer / lalitkumar

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

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..

what is Sql Native Client?

5 Answers   Gantec Solutions,

Which parameter of ConnectionString is used to specify the name of the database?

0 Answers  

What are the different ado.net namespaces?

0 Answers  

Is it possible to load multiple tables in a Dataset?

0 Answers  

What is the provider and namespaces being used to access oracle database?

4 Answers   Microsoft,

What is ado.net objects?

0 Answers  

How to pass values into a datatable?

0 Answers  

What is ole word?

0 Answers  

I want to ask u that if i add radio button in ado.net form,and how radion button data insert in SQL2005 Database...

6 Answers  

Explain ado.net features?

0 Answers  

What provider ado.net use by default? Explain the role of data provider in ado.net?

0 Answers  

How would u connect to database using .NET?

5 Answers   TCS, Tesco,