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

Give an example that shows how to execute a stored procedure in ado.net?

0 Answers  

What is ado.net objects?

0 Answers  

Where does ADO.NET and XML web services come in the architecture ?

1 Answers   IBM, TCS,

How do we invoke queries from the application ?

2 Answers   ICICI, Microsoft,

Sequence to connect and retrieve data from database useig dataset ?

6 Answers   MMTS,

What are all the different authentication techniques used to connect to MS SQL Server?

0 Answers  

Does sqlclient and oledb class share the same functionality?

0 Answers  

Name which operations can you not perform on an ado.net dataset?

0 Answers  

What is connection in ado.net?

0 Answers  

what are types of Dataset ?

6 Answers   HCL,

Which one of the objects is a high-level abstraction of the connection and command objects in ado.net?

0 Answers  

What do you mean by performing asynchronous operation using command object?

0 Answers