与C#数据库交互简介

using System;
using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        // 连接字符串
        string connectionString = "Server=localhost;Database=myDatabase;User Id=myUsername;Password=myPassword;";

        // 创建数据库连接
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();

            // 创建SQL查询
            string query = "SELECT * FROM myTable";

            // 执行SQL查询
            using (SqlCommand command = new SqlCommand(query, connection))
            {
                using (SqlDataReader reader = command.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        // 读取数据并执行相应操作
                        Console.WriteLine(reader["columnName"]);
                    }
                }
            }
        }
    }
}