使用C#开发一个sqlserver增删改查

以下是一个简单的C#程序，用于连接到SQL Server数据库并执行增删改查操作：

using System; using System.Data.SqlClient;

namespace SqlServerCRUD { class Program { static void Main(string[] args) { string connectionString = "Data Source=myServerAddress;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword"; SqlConnection connection = new SqlConnection(connectionString); connection.Open();

        // 插入数据
        string insertQuery = "INSERT INTO myTable (id, name, age) VALUES (1, 'Tom', 20)";
        SqlCommand insertCommand = new SqlCommand(insertQuery, connection);
        insertCommand.ExecuteNonQuery();

        // 更新数据
        string updateQuery = "UPDATE myTable SET age = 21 WHERE id = 1";
        SqlCommand updateCommand = new SqlCommand(updateQuery, connection);
        updateCommand.ExecuteNonQuery();

        // 删除数据
        string deleteQuery = "DELETE FROM myTable WHERE id = 1";
        SqlCommand deleteCommand = new SqlCommand(deleteQuery, connection);
        deleteCommand.ExecuteNonQuery();

        // 查询数据
        string selectQuery = "SELECT name, age FROM myTable";
        SqlCommand selectCommand = new SqlCommand(selectQuery, connection);
        SqlDataReader reader = selectCommand.ExecuteReader();
        while (reader.Read())
        {
            string name = reader.GetString(0);
            int age = reader.GetInt32(1);
            Console.WriteLine("Name: {0}, Age: {1}", name, age);
        }

        connection.Close();
    }
}

}

请注意，此示例仅用于演示目的。在实际应用程序中，您需要使用参数化查询来避免SQL注入攻击，以及处理异常和错误情况。