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 the difference between a datareader and a dataset?

0 Answers  

What is DataReader Object?

0 Answers  

What is ado code?

0 Answers  

What does sqldatareader return?

0 Answers  

What is data relation in ado.net?

0 Answers  

What is the difference between Dataset. clone and Dataset.copy?

0 Answers  

What is connection pooling and what is the maximum pool size in ado.net connection string?

0 Answers  

Difference between ADO and ADO.net ?

11 Answers   Accenture, BirlaSoft, College School Exams Tests, Krest, Red Apple,

Which method is used to sort the data in ADO.Net?

0 Answers  

How do you merge two datasets into the third dataset in a simple manner?

3 Answers   IBM,

how do u connect ado.net to sql server

1 Answers   Microsystems,

What is the Magic Tables in Sqlserver2000?

7 Answers   IBM, SQL Star,