asp.net在线订餐系统数据库如何实现

try
{
    string connectionString = "Server=your_server_address;Database=your_database_name;User Id=your_username;Password=your_password;";
    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        connection.Open();
        // 执行数据库操作
    }
}
catch (SqlException ex)
{
    Console.WriteLine("数据库连接失败: " + ex.Message);
}

try
{
    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        connection.Open();
        SqlTransaction transaction = connection.BeginTransaction();
        try
        {
            string insertSql = "INSERT INTO Orders (UserId, MenuItemId, Quantity, TotalPrice, OrderStatus) VALUES (@UserId, @MenuItemId, @Quantity, @TotalPrice, @OrderStatus)";
            using (SqlCommand command = new SqlCommand(insertSql, connection, transaction))
            {
                command.Parameters.AddWithValue("@UserId", userId);
                command.Parameters.AddWithValue("@MenuItemId", menuItemId);
                command.Parameters.AddWithValue("@Quantity", quantity);
                command.Parameters.AddWithValue("@TotalPrice", totalPrice);
                command.Parameters.AddWithValue("@OrderStatus", orderStatus);
                command.ExecuteNonQuery();
            }
            transaction.Commit();
        }
        catch (Exception ex)
        {
            transaction.Rollback();
            Console.WriteLine("数据插入失败: " + ex.Message);
        }
    }
}
catch (SqlException ex)
{
    Console.WriteLine("数据库连接失败: " + ex.Message);
}