ado.net

admin 49 0

下面是一个使用ADO.NET连接数据库并查询数据的简单案例:

```csharp

using System;

using System.Data;

using System.Data.SqlClient;

class Program

{

static void Main()

{

string connectionString = "Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=SampleDB;Integrated Security=True";

using (SqlConnection connection = new SqlConnection(connectionString))

{

connection.Open();

// 创建并执行 SQL 查询

string query = "SELECT * FROM Employees";

SqlCommand command = new SqlCommand(query, connection);

SqlDataReader reader = command.ExecuteReader();

// 读取查询结果

while (reader.Read())

{

int employeeId = (int)reader["EmployeeId"];

string firstName = (string)reader["FirstName"];

string lastName = (string)reader["LastName"];

Console.WriteLine("Employee ID: {0}, Name: {1} {2}", employeeId, firstName, lastName);

}

reader.Close();

}

}

}

```