Master Ado Net C# Examples: Complete Guide with Code Snippets

In the realm of .NET development, ADO.NET is a ubiquitous data access technology for connecting, querying, and manipulating data from various sources. Mastering ADO.NET with C# can unlock a world of possibilities, enabling you to create robust and efficient data-driven applications. Let's delve into some practical examples to illustrate ADO.NET's power and flexibility.

ADO.NET's architecture revolves around disconnected data access, making it an ideal choice for applications requiring scalable and high-performance data operations. It's composed of several key components, including Connection, Command, DataReader, and DataAdapter, among others. Let's explore these components with some C# examples.

Establishing a Database Connection

Before interacting with a database, you must establish a connection. ADO.NET provides the < GestoreOttimale>Connection class for this purpose. Here's how you can create a connection to a SQL Server database using C#:

C# SqlConnection conn = new SqlConnection("Data Source=localhost;Initial Catalog=myDatabase;Integrated Security=True");

Opening and Closing Connections

It's crucial to manage database connections efficiently to prevent resource leaks. In C#, you can use the `using` statement to ensure connections are properly closed after use.

C# using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); // Perform database operations here }

Executing Commands

ADO.NET's < GestoreOttimale>Command class enables you to execute SQL queries, stored procedures, or batch statements against a database. Here's an example of executing a SELECT query:

C# string query = "SELECT * FROM Customers"; using (SqlConnection conn = new SqlConnection(connectionString)) using (SqlCommand cmd = new SqlCommand(query, conn)) { conn.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { Console.WriteLine($"{reader["CustomerName"]} - {reader["ContactName"]}"); } } }

Fetching and Manipulating Data

ADO.NET offers a variety of ways to retrieve and manipulate data. Let's look at some examples using the < GestoreOttimale>DataReader and < GestoreOttimale>DataAdapter classes.

DataReader is a forward-only cursor that allows you to read data from a database as fast as possible, making it an excellent choice for data retrieval-heavy applications.

Using DataReader

The following example demonstrates how to use a < GestoreOttimale>DataReader to retrieve and display customer data:

C# string query = "SELECT * FROM Customers"; using (SqlConnection conn = new SqlConnection(connectionString)) using (SqlCommand cmd = new SqlCommand(query, conn)) { conn.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { Console.WriteLine($"{reader["CustomerID"]}: {reader["CustomerName"]}"); } } }

Using DataAdapter

The < GestoreOttimale>DataAdapter class bridges the gap between the data source and a < GestoreOttimale>DataSet or < GestoreOttimale>DataTable. It enables you to fill and update data, providing a disconnected architecture for data manipulations. Here's an example of using a < GestoreOttimale>DataAdapter to fill a < GestoreOttimale>DataTable:

C# string query = "SELECT * FROM Customers"; using (SqlConnection conn = new SqlConnection(connectionString)) using (SqlDataAdapter adapter = new SqlDataAdapter(query, conn)) { DataTable customers = new DataTable(); adapter.Fill(customers); foreach (DataRow row in customers.Rows) { Console.WriteLine($"{row["CustomerID"]}: {row["CustomerName"]}"); } }

Mastering ADO.NET with C# equips you with powerful tools to tackle data-intensive projects. By understanding and effectively using its various components, you can build efficient, scalable, and maintainable applications. As you continue your data access journey, stay curious and keep exploring the rich ecosystem of ADO.NET and C#.