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 betwen typed dataset and untyped dataset?in general which dataset can we use in programming?

0 Answers   EDS,

Which property is used to check whether a DataReader is closed or opened?

0 Answers  

What is the role of the dataset object in ado.net?

0 Answers  

What is the namespaces being used to access oracle database?

0 Answers  

What is dataset object? Explain the various objects in dataset.

0 Answers  

How can we check that some changes have been made to dataset since it was loaded?

0 Answers  

can u tell me the why ADO does not support xml..

2 Answers   Crea,

Is ADO.NET derived from COM? true /false

2 Answers   Infosys,

What are the steps to connect to a database?

0 Answers  

What property must be set and what method must be called in your code to bind the data from some data source to the Repeater control?

0 Answers  

What is a dynaset in access?

0 Answers  

What providers does Ado.net uses?

0 Answers