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 are the different methods available under the sqlcommand class to access the data?

0 Answers  

---

What are relation objects in dataset and how & where to use them?

1 Answers  

---

What is microsoft ado.net?

0 Answers  

---

Which is the feature of ado.net?

0 Answers  

---

What is meant by entity framework?

1 Answers  

---

---

What is connected architecture in ado.net?

0 Answers  

---

What are the steps you will take to improve performance? Will you use dataset or datareader?

0 Answers  

---

What is ado.net in mvc?

0 Answers  

---

How xml files and be read and write using dataset ?

1 Answers  

---

i have two textboxes one for user name and another for password . i have a table name compare(which contains name,passwod etc.,)my doubt is how compare username textbox with name column and how compare password textbox with passwod column. i want the code

9 Answers   Wipro,

---

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

0 Answers  

---

Why edit is not possible in repeater?

0 Answers  

---