选择、插入和更新数据C#的静态方法

using System;
using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        string connectionString = "Data Source=(local);Initial Catalog=YourDatabase;Integrated Security=True";
        string query = "SELECT * FROM YourTable WHERE Condition = 'Value'";

        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            SqlCommand command = new SqlCommand(query, connection);
            connection.Open();

            SqlDataReader reader = command.ExecuteReader();

            while (reader.Read())
            {
                // 处理每一行数据
                string column1Value = reader.GetString(0);
                int column2Value = reader.GetInt32(1);

                Console.WriteLine("Column1: {0}, Column2: {1}", column1Value, column2Value);
            }

            reader.Close();
        }
    }
}

using System;
using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        string connectionString = "Data Source=(local);Initial Catalog=YourDatabase;Integrated Security=True";
        string query = "INSERT INTO YourTable (Column1, Column2) VALUES ('Value1', 2)";

        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            SqlCommand command = new SqlCommand(query, connection);
            connection.Open();

            int rowsAffected = command.ExecuteNonQuery();

            Console.WriteLine("Rows affected: {0}", rowsAffected);
        }
    }
}

using System;
using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        string connectionString = "Data Source=(local);Initial Catalog=YourDatabase;Integrated Security=True";
        string query = "UPDATE YourTable SET Column1 = 'NewValue' WHERE Condition = 'Value'";

        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            SqlCommand command = new SqlCommand(query, connection);
            connection.Open();

            int rowsAffected = command.ExecuteNonQuery();

            Console.WriteLine("Rows affected: {0}", rowsAffected);
        }
    }
}