Answer / chaitanya.k

1. U need to declare name space according to which database
u need to connect.

2. U can declare connection string in two ways.

1. U can declare in web.config in appsettings.
2. U can delare directly in code behind or in inline code

These can delared by using connection string.

3. Then u can do the operations by open the connection.
4. After complete all ur transcations u need to close the
database.

Answer / sireesha

C#:
System.Data.SqlClient;
In the method {}...
Step 1: Create a connection:
SqlConnection con = new SqlConnection();
Con.ConnectionString = “DataSource =Server Name;
Initial Catalog = Database Name; Integrated Security=True”;
Step 2: Create a Command:
SqlCommand cmd = new SqlCommangd();
Step 3: Bind the Command to Connection:
cmd.Connection = con;
Step 4: Initialise the Command with SQL Statement to execute
EX:-
String Name = txtName.Text;
decimal Salary = decimal.parse(txtsalary.Text);
cmd.CommandText = "insert into Emp
(EmpName,EmpSalary) Value(' "+name+" ',"+salary")";
Step 5: Open the Connection
con.Open();
Step 6: Execute the Command
Like we have different execute command statements
like ExecuteNonQuery(),ExecuteScalar(),ExecuteReader(). Use
as per the requirement of data.
Step 7: Close the connection
con.Close();

Answer / sanket pandit

An alternate, and preferred way, to using the DriverManager class is to use a DataSource object.

This is for SQ L Ans.
1. The data source is registered on the server side, which stores connection information, like: host, port, sid, credentials (optional), driver to use, etc.

2. The application gets a handle on the data source through a JNDI lookup.

3. The DataSource object is a connection factory and you can invoke .getConnection()

One of the reasons it is preferred over the DriverManager is because it is more flexible. The connection in

What is the difference between ado.net and entity framework?

0 Answers  

---

Diff. b/w DataReader and DataSet?

8 Answers   Avon, Value Labs,

---

What is difference between datagridview and datagrid control in winforms?

0 Answers  

---

What are the benefits of ADO.NET?

0 Answers   B-Ways TecnoSoft,

---

What is Serialization in .NET? what are the types of Serialization?

0 Answers   Arigo Infotech,

---

What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)

0 Answers  

---

What is sequence of code in retrieving data from database ?

3 Answers   Accenture, BirlaSoft,

---

What is the role of data provider in ado.net?

0 Answers  

---

What is the main difference between ADO and ADO.Net

4 Answers   HCL,

---

What is the full form of ado.net?

0 Answers  

---

What are major difference between classic ADO and ADO.NET?

2 Answers  

---

How to add Primary key in DataSet

6 Answers  

---