Answer / sachin gupta

it consist
1. data source(Server)
2. database(Initial Catalog)
3. user name(Uid)
4. password(Pwd)
5. Integrated Security
6. Provider

Answer / ansu kamar

it consist of
data source
database
user name
password

Answer / hardit singh

sqlconnection con=new sqlconnection
("server=localhost;database=testdb;uid=sa;pwd=sa;");

Answer / m.chandran

Connection String for SQL Server consist of:
1.Data Source or server= “.”; or "Localhost" or "127.0.0.1" or "serverNameinstanceName" or "N/W SQL server IP Address" Server instance.
2.Initial Catalog or database = “DATABASE_NAME”;
Either3.Uid=”UserID for SQL server” and Password= “Password for SQL server”;
ORIntegrated Security=”True”; Use Windows security

optional
5.Provider Name =”System.Data.SqlClient”;

What are the benefits of using ado.net?

0 Answers  

---

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

0 Answers  

---

what is data Adapter?

26 Answers   CMC, CSS, IBM,

---

What provider ADO.net use by default ?

5 Answers   Accenture, BirlaSoft, Wipro,

---

What does executereader return?

0 Answers  

---

---

Define data access layer?

0 Answers  

---

What is connected architecture in ado.net?

0 Answers  

---

What is ambient transaction?

0 Answers  

---

Explain ado.net features? Benefits? Drawbacks?

0 Answers  

---

What is Debug.write does?

1 Answers  

---

If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?

0 Answers  

---

How would you connect to database using .NET?

0 Answers  

---